From the course: Tableau 10 for Data Scientists
Unlock the full course today
Join today to access over 23,300 courses taught by industry experts.
Join transformations - Tableau Tutorial
From the course: Tableau 10 for Data Scientists
Join transformations
- [Instructor] We're gonna look at the Superstore sales Excel sheet which you can find in your Exercise folder. This visualization here shows the number of orders for each of our subcategories split across our regions. We've got subtotals and grand totals on there to make things a little bit clearer. As you can see here, we have 5,009 unique orders within our data set. We now want to look at orders that have been returned back to the store. This information isn't held within this data set. Instead, we're gonna have to make a connection to a secondary data source, join the common fields together on order ID, and then bring in the returned information. The type of join that we use to do this is gonna have an effect on the overall data that we're gonna get back. First, let's connect the data. For that, we edit our data source, and we click on add. The returned file is in our exercise folder, and its called Superstore Returns. This workbook has a single sheet called Returns. We drop this…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.