AC3405
Tableau Data Prep Training
This Tableau Data Prep course teaches participants how to use Tableau Prep Builder, a Tableau product for data preparation. Attendees learn how to clean, shape, and analyze data correctly to gain business insights.
Course Details
Duration
2 days
Prerequisites
Experience using Tableau, joining data in Tableau, and working with calculations.
Skills Gained
- Use Tableau Prep
- Overcome many of their thorniest data cleaning and preparation issues
- Enable their Tableau analysis and visualization process to be smoother and easier
- Ease data prep challenges
Course Outline
- Introduction
- Preferred structure and layout of data in Tableau
- Introduction to the Tableau Prep workspace
- Data cleansing and preparation concepts, such as joins, unions, wildcard matches, fuzzy matching, and addressing nulls, irregularities and outliers
- When to do your data preparation in Tableau Prep vs. the normal Tableau Desktop
- Understand data sampling
- Connecting to and configuring data
- Exploring data
- Joining and unioning data
- Combining data
- Cleaning data
- Changing data types and data roles
- Filtering data
- Removing duplicates
- Shaping and pivoting data
- Aggregating Data
- Validating results
- Complex data cleaning tasks
- Best practices for data preparation and optimizing Tableau Prep
- Exporting to various Tableau formats and publishing to Tableau Server
- Automating Tableau Prep flows with Tableau Prep Conductor or the Command Line Interface (if desired)
- Conclusion
Upcoming Course Dates
