
Download Tableau desktop by visiting the official site, start a free trial, activate via email, then log in and download the installer.
Explore quick table calculations in Tableau with predefined functions like running total, difference, percent difference, percent of total, rank, percentile, and moving average.
Compute moving averages from monthly sales by combining the current value with previous months, handling nulls, and dividing by the actual count to produce the smoothed output.
Identify three level of detail expressions in Tableau calculations: fixed, include, and exclude. Fixed is independent; include and exclude are dependent on the visualization and context filters.
Explore how year and product category filters let you compare sales by category in a pie chart and color by the sum of sales as a percentage of total.
Visualize customers on a world map by region, using distinct count for customer names as bubble size, with region filters, color by region, and in-bubble labels.
WHO'S THIS FOR?
This course is designed specifically for experienced & intermediates who wants to Enhance the understanding by learning Advance Tableau Calculations .
Note : This course is not for a absolute beginners.
Tableau is a leading data visualization tool used for data analysis and business intelligence. Gartner's Magic Quadrant classified Tableau as a leader for analytics and business intelligence.
Advantages of Tableau
Data visualization.
Quickly Create Interactive visualizations.
Ease of Implementation.
Tableau can handle large amounts of data.
Use of other scripting languages in Tableau.
Mobile Support and Responsive Dashboard.
Tableau Company Strategy.
Scheduling or notification of reports.
PROBLEMS YOU'VE EXPERIENCED WITH EXCEL IN THE PAST
Excel becomes slow or crashes when you have lots of data, formatting and Charts inside a workbook.
Mistakenly working on the wrong file you saved.
It’s so annoying to email multiple Excel files to the same people everyday.
It takes hours to create a dashboard with multiple charts and formula functions.
Some time Excel files are used to store the large amount data which is a very wrong decision because to update the data everyday on that file is a headache because it takes so much time to get open and then to get save.
Section 1:Stater
Lecture 1:Download Tableau
Lecture 2:Install
Lecture 3:Visualize data in workspace
Section 2:Quick Table Calculations
Lecture 4:Quick Table Calculations Intro
Lecture 5:Running Total
Lecture 6:Difference
Lecture 7:Percent Difference
Lecture 8:Percent of Total
Lecture 9:Rank
Lecture 10:Rank Dense
Lecture 11:Moving Average Part1.1
Lecture 12:Moving Average Part1.2
Lecture 13:Moving Average Part1.3
Lecture 14:Rank_Unique Part1
Lecture 15:Rank_Unique Part2
Lecture 16:Rank_Unique Part3
Section 3:LOD
Lecture 17:1
Lecture 18:2
Lecture 19:3
Lecture 20:4
Lecture 21:5
Lecture 22:6
Lecture 23:7
Lecture 24:8
Lecture 25:9
Lecture 26:10
Lecture 27:11
Lecture 28:12
Lecture 29:13
Lecture 30:14
Lecture 31:15
Lecture 32:16
Lecture 33:17
Lecture 34:18
Lecture 35:19
Section 4:Tableau Calculations including Visuals Extra Addition
Lecture 36:Download Data Set
Lecture 37:Viz1
Lecture 38:Viz2
Lecture 39:Viz3
Lecture 40:Viz4
Lecture 41:Viz5
Lecture 42:viz6
Lecture 43:viz7
Lecture 44:viz8
Lecture 45:Viz9
Curriculum item
Section
THE END