Advanced Calculations in Tableau
Enhancing your understanding of Tableau
Tableau Desktop is often referred to as the Gold Standard for Data Visualization, Data Discovery and Self-Service Data Analytics, and caters for all users from IT Practitioners, to Data Scientists, to Data Consumers. One of the area's people shy away from (to their detriment) is learning about the vast power of Advanced Calculations in Tableau; through understanding these advanced calculations and associated concepts, you will further enhance your ability to translate your requirements into amazing dashboards. Plus, these are the advanced questions asked at interviews and too often seem as a gauge for identifying your skill level in Tableau. In this course, we will learn about Table Calculations and Level-of-Detail (LOD) Expressions.
Understanding and leveraging Table Calculations
Understanding and leveraging Level-of-Detail (LOD) Expressions
Intermediate / Advanced Tableau Concepts
6-12 Months of Tableau Desktop Experience
Tableau Desktop / Tableau Public Installed
About this Course
Focus on Learning
Superstore Data Source
Introduction to Table Calculations
Exploring Quick Table Calculations
Configuring Quick Table Calculations
Writing Table Calculations
Configuring Table Calculations
Working with Nested Table Calculations
Table Calculation and Filtering
Summary
Exercise: Cumulative Aggregations
Exercise: Percentage of Total
Exercise: Ranking
Exercise: Moving Averages
Exercise: Differences
Exercise: Anchor Values
Introduction to Level-of-Detail (LOD) Expressions
Understanding Aggregations in Tableau
Understanding Level-of Detail (LOD) Scoping Keywords
FIXED LOD Expressions
INCLUDE LOD Expressions
EXCLUDE LOD Expressions
Understanding Nested Level-of Detail (LOD) Expressions
Understanding LOD Filtering
Understanding Level-of-Detail (LOD) Limitations
Summary
Exercise: Table Scoped
Exercise: Customer Order Frequency
Exercise: Cohort Analysis
Exercise: Avg. Sales per Customer
Exercise: Avg. Daily Sales
Exercise: Excluding from View
Course Review
Practice make Perfect
Thank You
A very thorough review of two of Tableau's powerful tools. Highly recommended for in depth learning and refreshing of existing knowledge
A very thorough review of two of Tableau's powerful tools. Highly recommended for in depth learning and refreshing of existing knowledge
Read LessClear explanation, well paced session with hands on practice & Do it at same to understand each concept.
Clear explanation, well paced session with hands on practice & Do it at same to understand each concept.
Read LessClear and concise thank you so much, I am a beginner and these exercises are very helpful in giving me ideas.
Clear and concise thank you so much, I am a beginner and these exercises are very helpful in giving me ideas.
Read LessToan has a great understanding of Tableau and gives an in-depth look into table calculations and level of detail (LOD) expressions. There are practical examp...
Read MoreToan has a great understanding of Tableau and gives an in-depth look into table calculations and level of detail (LOD) expressions. There are practical examples and the content is short, to the point, and easily digestible. Highly recommend even if you think you have a grasp on the subject.
Read Less