Cleaning, Transforming and Prepping Your Data With Tableau Prep
Offered By: LinkedIn Learning
Course Description
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
Taught by
Matt Francis
Related Courses
Business Metrics for Data-Driven CompaniesDuke University via Coursera Big Data: Data Visualisation
Queensland University of Technology via FutureLearn Creating Dashboards and Storytelling with Tableau
University of California, Davis via Coursera Explaining Your Data Using Tableau
University of California, Davis via Coursera Visual Analytics with Tableau
University of California, Davis via Coursera