Total Runtime:

4 hours of video, budget an additional 4-5 hours to work through practice exercises.

Have you ever wanted to analyze your data in Tableau but thought...

• It's too messy

• I can't get the data formatted the way I want

• I don't really know how to prepare data

Join us as we explore the foundational concepts behind Tableau's newest tool, Tableau Prep. We've been using it behind the scenes for 6 months already and have consolidated what you need to know into 3 half-days. We'll discuss how it will help you get your foot in the door to do more robust data preparation work. Save hours per week that you spend doing manual, repetitive data preparation and get out ahead of the curve using this powerful tool.

Table of Contents

Topics we will explore include:

Tableau Prep Background

• File Types

• Connecting to Data

• Exploring Your Data

• Editing the Metadata

• Sharing Your Work

• Calculations in Tableau Prep

Understand Data Preparation

• Tableau's Preferred Data Source

• Working with Tables from a Database

• Joins

• Unions

• Pivots

Common Issues

• Reducing Rows and Columns

• Refreshing Data Sources

• Join Type Mismatches

• Duplicated Data

Real World Scenarios

• Preparing Messy Crosstab Data

• Business Services

• Freight Analysis

• Patient Wait Times

When do you need more than Tableau Prep?

• When do you need more than Tableau Prep?

• Alternatives

Requirements:

• A Computer

• A Reliable Internet Connection

• A Google-based account for sharing of the video and course content.

• Tableau Prep 2018.1 or Later

• Tableau Desktop

• An External Monitor (strongly recommended for optimal experience)

Prerequisites:

Basic understanding of Tableau. You should be able to do the following:

• Connect to a data source.

• Understand the difference between measures and dimensions.

• Build a basic dashboard.

What will you get?

• Recording of the virtual instruction.

• A 100 page digital manual.

• Data files to revisit concepts.

• One free office hour to get help on your own data.

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

eric.parker@onenumber.biz

onenumber.biz