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
Data Wrangling with MongoDBMongoDB via Udacity Getting and Cleaning Data
Johns Hopkins University via Coursera 软件包在流行病学研究中的应用 Using software apps in epidemiological research
Peking University via Coursera Creating an Analytical Dataset
Udacity Implementing ETL with SQL Server Integration Services
Microsoft via edX