What You Will Learn

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

Course curriculum

  • 1

    Introduction

    • About this Course

    • Focus on Learning

    • Superstore Data Source
  • 2

    Table Calculations

    • 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
  • 3

    Table Calculation Exercises

    • Exercise: Cumulative Aggregations

    • Exercise: Percentage of Total

    • Exercise: Ranking

    • Exercise: Moving Averages

    • Exercise: Differences

    • Exercise: Anchor Values
  • 4

    Level-of-Detail (LOD) Expression

    • 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
  • 5

    Level-of-Detail (LOD) Exercises

    • Exercise: Table Scoped

    • Exercise: Customer Order Frequency

    • Exercise: Cohort Analysis

    • Exercise: Avg. Sales per Customer

    • Exercise: Avg. Daily Sales

    • Exercise: Excluding from View
  • 6

    Closing the Course

    • Course Review

    • Practice make Perfect

    • Thank You

What our Students Say?

5 star rating

Clear, focused and insightful

Gil Ben-Itzhak

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 Less
5 star rating

Clarity, pace and learn by doing

YOUVRAJ SEEAM

Clear 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 Less
5 star rating

Excellent Exercises

Fahad Qadir

Clear 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 Less
5 star rating

Great for beginners, excellent refresh for experts

Dan Girard

Toan 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 More

Toan 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