Overview
-
Learn to clean, transform, pivot, and prep data for visualization in Tableau Desktop with Tableau Prep.
Syllabus
-
Introduction
- Why use Tableau Prep before jumping into Tableau Desktop?
- Software setup
- Introducing the analytic cycle
- What is Tableau Prep?
- A tour of the Tableau Prep workspace
- Tableau anatomy
- Connecting to a data source
- Using the data interpreter
- Connecting to multiple files
- Configuring the data input process
- Challenge 1: Connecting files and configuring data inputs
- Solution 1: Connecting files and configuring data inputs
- Using the Profile pane
- Examine the distribution of the data
- Examine row-level data in the data grid
- How to search and sort
- Challenge 2: Exploring the data
- Solution 2: Exploring the data
- Splitting fields into new ones
- Removing and renaming fields
- Cleaning data using calculated fields
- Filtering data
- Grouping values
- Replacing values
- Keeping track of changes
- Challenge 3: Cleaning data
- Solution 3: Cleaning data
- Merging data using unions
- Union data using wildcards
- Correcting mismatched fields
- Explaining the different join types
- Creating joins
- Correcting join errors
- Challenge 4: Combining data
- Solution 4: Combining data
- Reshaping using pivots
- Aggregating data
- Challenge 5: Aggregate data
- Solution 5: Aggregate data
- Sampling your data
- Sampling options
- Challenge 6: Data sampling
- Solution 6: Data sampling
- Preview the flow in Tableau Desktop
- Creating output files
- Challenge 7: Generating a flow output
- Solution 7: Generating a flow output
- Flight delays
- World indicators
- Superstore
- Minimum wage
- Next steps
