From the course: Complete Guide to Analytics Engineering

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Blending multiple data sources together

Blending multiple data sources together

From the course: Complete Guide to Analytics Engineering

Start my 1-month free trial Buy for my team

Blending multiple data sources together

“

- [Instructor] If you recall, in our Python chapters, we use Panda's Merge to combine multiple data frames together. In our SQL chapter, we use joins to bring multiple data tables together, and you guessed it in Tableau we can use blend relationships to add multiple data sources together, just like in Python and SQL. In order to blend two data sources together in Tableau, we need a linking field, a column that is found in both data sets so that we can bring the data together. Let's create a new worksheet and click on the discounts query data source. Notice that this data source has the employee ID dimension. That can be our linking field in order to join to the Sales Associates query data source. Let's start by bringing a few fields from Discounts Query into our visual. Let's bring employee ID to rows, and discounted rank to text. Let's add measure names to columns. Let's give the measure name an alias and call it our most discounts rank. Right click on no measures here. Edit Alias…

Contents