This is an advanced, 16-hour course for experienced Tableau users. It covers data prep, calculations and visual analytics.
"Tableau: Mystery to Mastery II is an advanced class that incorporates the best of the following Tableau classes; Tableau Prep, Desktop III, Visual Analytics. I've used my experience of teaching these classes numerous times and consulting at many organizations to cut out the unnecessary fluff and only include relevant content."
-Eric Parker
This class can take place in either of the following formats:
Two, 8-hour sessions
Five, 3-hour sessions
Course Agenda :
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. Shaping Data with Tableau Prep
Tableau Prep File Types
Unions from Different Data Sources
Pivoting Data
Unpivoting Data
Cleaning Data
Text String Manipulation (Combining multiple text values)
Different Levels of Aggregation
5. Advanced Tableau Prep Uses
Suppression
Preparing Survey Data
Dealing with multi-response questions
6. 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)
7. Parameters
Top N
Adjust a Field
Worksheet swap
8. Advanced Calculations
Aggregation Levels
Level of Detail Calculations
Find and Replace using REGEX
9. Advanced Table Calculations
Highlighting Lowest 5 Days
Specific Dimensions
10. Advanced Concepts
Order of Operations
Context Filters
Sets
Set Actions
11. Statistical Analysis
Histograms
Box and Whisker
Trend Lines
Forecasts (no practice)
12. Design with Intent
Visual Analytics Process
Sensory Memory
Short-Term Memory
Long-Term Memory
13. 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
14. Crafting Your Brand
Custom Color Palettes
Custom Shapes
15. Advanced Dashboarding & Design
Navigation between dashboards
Custom titles
Info buttons
Highlight & URL Actions
A Laptop
Tableau Desktop Professional 2018.3 or Later
Tableau Prep Builder 2018.3 or Later
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
A 200+ Page Digital Manual
Data files to revisit concepts
"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