About This Class
Tableau: Mystery to Mastery II will push your use of Tableau Desktop to new heights!
We cover preparing data for analysis, making data efficient, relationships, parameters, filtering order of operations, design best practices and design interactivity. Join us to expand your Tableau horizons!
How is the class structured?
This class is broken into five, 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)
Day Four, 9:00 am to 12:00 pm (Eastern Time)
Day Five, 9:00 am to 12:00 pm (Eastern Time)
Where will this be hosted?
Meeting links will be sent upon registration.
WHAT WILL YOU GET?
A 200+ Page Digital Manual
Data files to revisit concepts
Access to class recordings for two weeks
Class Agenda :
DAY ONE:
1. Review Key Concepts
Date Part/Date Value
Measure Names & Measure Values
2. Common Data Issues
Null Data
Refreshing a Data Source
3. Advanced Data Setup
Blending
Join Calculations
Extracts
4. Preparing Data with Relationships
Relationships vs. Joins
Avoiding Duplications with Relationships
Exposing Unmatched Data in Relationships
DAY TWO:
5. Advanced Visuals
Donut Charts
Tree Maps
Filling up a shape with a bar (No practice)
People bar charts (No practice)
100% Stacked Bar (w/ Overlying Circle)
6. Parameters
Top N
Adjust a Field
Worksheet swap
DAY THREE:
7. Advanced Calculations
Aggregation Levels
Level of Detail Calculations
Find and Replace using REGEX
8. Advanced Table Calculations
Highlighting Lowest 5 Days
Specific Dimensions
9. Advanced Concepts
Order of Operations
Context Filters
Sets
Set Actions
10. Statistical Analysis
Histograms
Box and Whisker
Trend Lines
Forecasts (no practice)
DAY FOUR:
11. Design with Intent
Visual Analytics Process
Sensory Memory
Short-Term Memory
Long-Term Memory
12. Choosing the Right Chart Type
Viewing Specific Values
Comparing and Ranking Categories
Comparing Parts to the Whole
Comparing Measures
Viewing Correlation
Viewing Distributions
Viewing Data Over Time
Mapping
13. Crafting Your Brand
Custom Color Palettes
Custom Shapes
14. Advanced Dashboarding & Design
Navigation Between Dashboards
Custom Titles
Info Buttons
Highlight & URL Actions
REQUIREMENTS
A Laptop
Tableau Desktop Professional 2020.1 or Later
PREREQUISITES
Intermediate level Tableau skills. 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
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!
WHAT PEOPLE ARE SAYING ABOUT ONENUMBER AND TRAINER Ollie Liney:
"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
Questions: oliver.linley@onenumber.biz