About This Class
Tableau: Mystery to Mastery II is an advanced class that incorporates the best of the following Tableau classes; Tableau Prep, Desktop III, Visual Analytics. We’ve used our experience of teaching these classes numerous times and consulting at many organizations to cut out the unnecessary fluff and only include relevant content.
How is the class structured?
This class is broken into four, 4-hour sessions.
Day One, 8:30 am to 12:30 pm (Pacific Time)
Day Two, 8:30 am to 12:30 pm (Pacific Time)
Day Three, 8:30 am to 12:30 pm (Pacific Time)
Day Four, 8:30 am to 12:30 pm (Pacific 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
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
WHAT PEOPLE ARE SAYING ABOUT ONENUMBER AND TRAINER ERIC PARKER:
"After spending a couple days working with OneNumber, we are months, no, lightyears ahead of where we would be otherwise." - A OneNumber client to their CEO.
"Eric is one of the best instructors that I have ever had. Everything was paced very well and the content was extremely valuable. Personable, helpful and patient. Willing to explore with us students and excited about using Tableau, like we are!" - A Former Student