Cleaning, Transforming and Prepping Your Data With Tableau Prep

Focused View

Matt Francis

2:28:15

177 View

01 - Introduction

01 - Why use Tableau Prep before jumping into Tableau Desktop.mp4

00:50

02 - Software setup.mp4

01:36

02 - 1. Introduction to Tableau Prep

01 - Introducing the analytic cycle.mp4

02:16

02 - What is Tableau Prep.mp4

02:34

03 - A tour of the Tableau Prep workspace.mp4

02:49

04 - Tableau anatomy.mp4

04:02

03 - 2. Connecting to Data

01 - Connecting to a data source.mp4

02:38

02 - Using the data interpreter.mp4

01:53

03 - Connecting to multiple files.mp4

02:38

04 - Configuring the data input process.mp4

04:03

05 - Challenge 1 Connecting files and configuring data inputs.mp4

00:37

06 - Solution 1 Connecting files and configuring data inputs.mp4

01:22

04 - 3. Exploring Your Data

01 - Using the Profile pane.mp4

02:52

02 - Examine the distribution of the data.mp4

01:54

03 - Examine row-level data in the data grid.mp4

02:17

04 - How to search and sort.mp4

03:22

05 - Challenge 2 Exploring the data.mp4

00:37

06 - Solution 2 Exploring the data.mp4

02:07

05 - 4. Cleaning Your Data

01 - Splitting fields into new ones.mp4

03:34

02 - Removing and renaming fields.mp4

02:40

03 - Cleaning data using calculated fields.mp4

03:33

04 - Filtering data.mp4

03:48

05 - Grouping values.mp4

03:48

06 - Replacing values.mp4

03:49

07 - Keeping track of changes.mp4

04:23

08 - Challenge 3 Cleaning data.mp4

00:33

09 - Solution 3 Cleaning data.mp4

02:43

06 - 5. Combining Your Data

01 - Merging data using unions.mp4

03:03

02 - Union data using wildcards.mp4

03:58

03 - Correcting mismatched fields.mp4

03:40

04 - Explaining the different join types.mp4

04:09

05 - Creating joins.mp4

04:08

06 - Correcting join errors.mp4

03:38

07 - Challenge 4 Combining data.mp4

00:41

08 - Solution 4 Combining data.mp4

03:55

07 - 6. Reshaping Your Data

01 - Reshaping using pivots.mp4

03:08

02 - Aggregating data.mp4

03:41

03 - Challenge 5 Aggregate data.mp4

00:49

04 - Solution 5 Aggregate data.mp4

03:43

08 - 7. Sampling Your Data

01 - Sampling your data.mp4

02:42

02 - Sampling options.mp4

03:36

03 - Challenge 6 Data sampling.mp4

00:53

04 - Solution 6 Data sampling.mp4

03:16

09 - 8. Previewing and Sharing Your Data

01 - Preview the flow in Tableau Desktop.mp4

03:49

02 - Creating output files.mp4

04:01

03 - Challenge 7 Generating a flow output.mp4

00:37

04 - Solution 7 Generating a flow output.mp4

03:19

10 - 9. Example Flows

01 - Flight delays.mp4

04:45

02 - World indicators.mp4

04:25

03 - Superstore.mp4

04:41

04 - Minimum wage.mp4

04:09

11 - Conclusion

01 - Next steps.mp4

00:11

Description

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. Matt also shows how to sample data, adjust sampling size, and preview and share your final output with Tableau Desktop. The training wraps up with some example flows that show Tableau Prep in action. By the end of the course, you will have learned the skills to make Tableau Prep an essential part of your Tableau data viz process.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Data Analysis

Tableau

Matt Francis

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.