Join Matt Francis for an in-depth discussion in this video Next steps, part of Cleaning, Transforming and Prepping Your Data With Tableau Prep.
- [Narrator] Now you've learned how to prepare your data,…you need to build dashboards.…Check out my other courses on how to use Tableau Desktop…and how to create brilliant dashboards.…You can find them in the library.…
Resume Transcript Auto-Scroll
Author
Matt Francis
Released
1/2/2019
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.
Topics include:
- The data prep cycle
- Connecting to data
- Examining data in the preview pane
- Cleaning data
- Combining data using joins and unions
- Reshaping and pivoting data
- Previewing and sharing data
- Data sampling to improve performance
Skill Level Intermediate
2h 28m
Duration
35,680
Views
Show More
Show Less
-
Introduction
-
Software setup1m 36s
-
1. Introduction to Tableau Prep
-
What is Tableau Prep?2m 34s
-
Tableau anatomy4m 2s
-
2. Connecting to Data
-
Connecting to a data source2m 38s
-
Using the data interpreter1m 53s
-
Connecting to multiple files2m 38s
-
-
3. Exploring Your Data
-
Using the Profile pane2m 52s
-
How to search and sort3m 22s
-
-
4. Cleaning Your Data
-
Removing and renaming fields2m 40s
-
Filtering data3m 48s
-
Grouping values3m 48s
-
Replacing values3m 49s
-
Keeping track of changes4m 23s
-
Solution 3: Cleaning data2m 43s
-
5. Combining Your Data
-
Union data using wildcards3m 58s
-
Correcting mismatched fields3m 40s
-
Creating joins4m 8s
-
Correcting join errors3m 38s
-
Solution 4: Combining data3m 55s
-
6. Reshaping Your Data
-
Reshaping using pivots3m 8s
-
Aggregating data3m 41s
-
Solution 5: Aggregate data3m 43s
-
-
7. Sampling Your Data
-
Sampling your data2m 42s
-
Sampling options3m 36s
-
Solution 6: Data sampling3m 16s
-
-
8. Previewing and Sharing Your Data
-
Creating output files4m 1s
-
9. Example Flows
-
Flight delays4m 45s
-
World indicators4m 25s
-
Superstore4m 41s
-
Minimum wage4m 9s
-
-
Conclusion
-
Next steps11s
-
Show MoreShow Less
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Next steps