From the course: Tableau 10 for Data Scientists

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Join transformations

Join transformations - Tableau Tutorial

From the course: Tableau 10 for Data Scientists

Start my 1-month free trial

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…

Contents