Day One
9:00 AM - 12:00 PM Eastern
Day Two
9:00 AM - 12:00 PM Eastern
Day Two
9:00 AM - 12:00 PM Eastern
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!
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:
- Combine Multiple Tables of Data for Analysis in Tableau
- Write Calculations
- Build and Share Dashboards
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. Details will be sent after registration.
What people are saying about OneNumber and trainer Ollie Linley:
"Your guidance & best practices are hands down among the most practical and valuable of ANY Tableau content I have come across." -A Tableau Solution Engineer
“If I hadn’t linked up with you, I would’ve quit Tableau. Now, it’s my whole career and I haven’t had this much fun in years.” - A Former Student
For questions: oliver.linley@onenumber.biz
onenumber.biz
