About This Class
Calculations are one of the most intimidating topics in Tableau. Especially when it comes to advanced features like incorporating Sets and Parameters into your formulas and utilizing Level of Detail expressions to alter levels of aggregation.
Years in the making, Mastering Tableau Calculations II will open doors you didn't know existed! From de-duplicating data to filtering multiple time periods with a single input, this workshop will teach you the skills you need to be a certified Tableau calculation ninja.
Are you ready to take your Tableau calculation game to new heights? Join us!
Timing
This class is broken into three, 3-hour sessions.
Day One, 9:00 am to 12:00 pm (Eastern Time)
Day Two, 9:00 am to 12:00 pm (Eastern Time)
Day Three, 9:00 am to 12:00 pm (Eastern Time)
WHAT WILL YOU GET?
In addition to two half-days of instruction, attendees will walk away with a 100+ page digital manual and data files to revisit the concepts on their own later.
WHERE WILL THIS BE HOSTED?
This training will be hosted virtually.
What We’ll Cover
Topics we will explore include:
Sets and Calculations
Top 10 and Other
Asymmetric Drilldowns
Multi-Select Sets in Calculations
Segmented Comparisons
Adjust Values with Parameters
Change Top N
Dynamic Goals and Reference Lines
Filtering on Top Percent of Values
Dynamic Labels
Swap Fields with Parameters
Swap Measures
Swap Dimensions
Swap Worksheets
Customize Dates with Parameters
Swap Date Units
Filter Multiple Date Fields at Once
Custom Date Filters
Dynamic Date Parameter
Level of Detail Expressions Introduction
FIXED
INCLUDE and EXCLUDE
Data Source Level Aggregation
Level of Detail Expressions for Analysis
Cohort Analysis
Frequency Analysis
Finding Highest/Lowest Values in a Range
Multi-Row Logic
Keep Only Values with Multiple Records
Level of Detail Expressions for Duplication
Return a Single Record Count for a Stacked Bar Chart
De-Duplicate Repeated Values
Keep Only Over Value per ID
Requirements:
A Personal Computer
An External Monitor (strongly recommended)
Tableau Desktop Professional 2020.1 or later
Prerequisites:
Some experience using Tableau Desktop. You should be able to do the following:
Connect to a data source.
Understand the difference between measures and dimensions.
Be able to build calculated fields on your own.
Build a basic dashboard.
Price
$995
Ollie Linley
Ollie Linley is a Tableau Certified Trainer with a passion for helping his students get the most out of Tableau. When he’s not writing calculations and building beautiful dashboards he can be found trail running on a mountain or traveling the world with his wife!