Tableau Mystery to Mastery II

This is an advanced, 16-hour course for experienced Tableau users. It covers data prep, calculations and visual analytics.

About this event

"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 :

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. 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

Day Two:

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

Day Three:

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)

Day Four:

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

Requirements

  • A Laptop

  • Tableau Desktop Professional 2018.3 or Later

  • Tableau Prep Builder 2018.3 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 will you get?

  • A 200+ Page Digital Manual

  • Data files to revisit concepts

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