- [Instructor] Here's a challenge using unions and joins.…First, you're going to open up 05_07_Challenge,…which is looking at our flight data.…You're going to need to add the additional flight data…for week two and week three,…which you can find in the data folder.…We're going to combine those using a union.…Remember to add those after the initial clean step.…Next, you need to fix any mismatch errors,…and then remove any extra columns…you don't think add to the analysis.…Lastly, we want to combine the data…from the Flight delays.csv file.…

To do that, we need to import that data…and use an inner join.…This should take you about five minutes.…

Resume Transcript Auto-Scroll

Author

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.