Cleaning, Transforming and Prepping Your Data With Tableau Prep
- Offered byLinkedin Learning
Cleaning, Transforming and Prepping Your Data With Tableau Prep at Linkedin Learning Overview
Duration | 3 hours |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Go to Website |
Credential | Certificate |
Cleaning, Transforming and Prepping Your Data With Tableau Prep at Linkedin Learning Highlights
- Earn a certificate of completion from LinkedIn Learning
- Learn from expert faculty
- Access on tablet and phone
Cleaning, Transforming and Prepping Your Data With Tableau Prep at Linkedin Learning Course details
- Professionals responsible for analyzing and interpreting data for decision-making
- Understand the importance of data cleanliness and its impact on analysis
- Master Tableau Prep's interface and functionalities for efficient data cleaning
- Gain proficiency in transforming raw data into usable formats for analysis
- Learn advanced data prep techniques to handle complex datasets effectively
- Very rarely is data perfectly ready for visualization. Tableau Prep is a visual data preparation tool that allows you to get to data analysis faster by enabling the quick cleaning, reshaping, and prepping of data—using the same drag-and-drop paradigm as Tableau Desktop
- This course shows exactly how to use Tableau Prep for data preparation. Instructor Matt Francis show how to connect to multiple data sources and combine them into a single source of data using joins and unions. Then learn how to filter, split, and rename data and how to pivot data to convert wide data into the tall data that Tableau Desktop prefers
Cleaning, Transforming and Prepping Your Data With Tableau Prep at Linkedin Learning Curriculum
Introduction
Why use Tableau Prep before jumping into Tableau Desktop
Software setup
Introduction to Tableau Prep
Introducing the analytic cycle
What is Tableau Prep?
A tour of the Tableau Prep workspace
Connecting to Data
Connecting to a data source
Using the data interpreter
Connecting to multiple files
Exploring Your Data
Using the Profile pane
Examine the distribution of the data
Examine row-level data in the data grid
Cleaning Your Data
Splitting fields into new ones
Removing and renaming fields
Cleaning data using calculated fields
Combining Your Data
Merging data using unions
Union data using wildcards
Correcting mismatched fields
Reshaping Your Data
Reshaping using pivots
Aggregating data
Challenge 5: Aggregate data
Sampling Your Data
Sampling your data
Sampling options
Challenge 6: Data sampling
Previewing and Sharing Your Data
Preview the flow in Tableau Desktop
Creating output files
Challenge 7: Generating a flow output
Example Flows
Flight delays
World indicators