EDUCBA

EDUCBA

MENUMENU
  • Blog
  • Free Courses
  • All Courses
  • All in One Bundle
  • Login
Home Data Science Data Science Tutorials Tableau Tutorial Data Blending in Tableau

Data Blending in Tableau

Priya Pedamkar
Article byPriya Pedamkar

Updated March 20, 2023

Data Blending in Tableau

Introduction to Data Blending in Tableau

A feature that clearly depicts the versatile character of Tableau is Data Blending. Blending, in general, means combining. Often data is stored in multiple tables at different levels. In database terminology, we can say having the same data in multiple tables but with different granularities. E.g., a table contains distribution volume at the regional level, while another table has distribution volume at the divisional level. The tables will have certain fields in common. Sometimes, we may need fields from both tables for analysis. In such cases, the concept of data blending offers an easy solution to combine data from different data sources.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

Need for Data Blending in Tableau

In Tableau, data blending refers to combining data. The crucial aspect of data blending is that it combines the tables at the view level without actually performing a join between the tables. Because Tableau is essentially a visual analytics tool, and that not every time, there may be the need to join the tables. Moreover, the combination happens sheet-wise and not workbook-wise. This ensures the view level combining features of data blending.

Blending Data in Tableau

Now, we will see how to blend data in Tableau. For our demonstration, we are considering distribution data. Two different tables contain data pertaining to distribution volume. They are present in two different Excel files. One table contains data at the Distribution Channel level, while the other contains the distribution unit level. A couple of fields are common in the two tables, though they exist with different names.

Following is the step-by-step procedure to perform data blending in Tableau and to use the combined data.

Step 1:

Loading data from two tables one by one.

Data Blending in Tableau Step 1.1

  • In Data Menu, click on the New Data Source option, select the required source and load it into Tableau.

Perform the above step twice to load both the tables into Tableau. They shall appear under the Data tab as shown in the following screenshot.

Data Blending in Tableau Step 1.2

  • Once loaded, both the sources will appear under the Data tab.

Data Blending in Tableau Step 1.3

Step 2:

For blending data, we will perform the following steps:

Data Blending in Tableau Step 2.1

  • Click on “Edit Relationships…” in the Data menu. It will pop up the Relationships dialogue box.

Step 2.2

  • By default, the currently selected data source becomes the primary data source.
  • However, we can select the requisite primary data source from the drop-down menu.
  • When the Automatic option is selected, these options are not active.

Step 2.3

  • The requisite primary data source can be selected from the drop-down menu.
  • Click on OK after selecting the requisite data source as the primary data source.

Step 2.4

  • Clicking on Add button pops up Add/Edit Field Mapping dialogue box.

Step 2.5

  • Using Add/Edit Field Mapping, we can add custom fields for mapping data between the two data sources.
  • Click on OK once requisite selections from the two sections, i.e. Primary and Secondary data source fields, are made.

Step 3:

Once the above steps are performed, we will check if the blending is successful or not by using appropriate dimensions from both tables.

Step 3.1

Step 3.2

Step 4:

Step 4.1

Step 4.2

The above graphical analysis shows Division wise Distribution Volume for a product. While Distribution Volume is a numeric field present in both the tables with the same name, Division is present in the secondary data source, i.e. Distribution Unit Volume table as Distribution Unit field. Through data blending operation, we have combined the two tables and mapped the values. So, in the graph, we could see DU Code values against respective divisions. Not performing data blending would have generated blanks for the DU Code field.

Step 5:

Both the tables contain distribution volume data, but only at different levels, so division-wise volumes for both the tables should be the same and the total volume. Let’s verify this.

Step 5.1

Note, as seen above, both the graphs depict the same pattern for Division wise Distribution Volume, though the measure has been selected from both primary as well as secondary data sources. This shows that though present at different levels in different tables, the Distribution Volume will remain the same. This is another proof of correct data blending facilitated by mapping over appropriate fields.

Conclusion

Data Blending is a simple and fast way to combine data from multiple sources in Tableau. It doesn’t actually join the tables, though it can be compared to Left Join, treating the primary data source as the left table. It just combines data at the view level to facilitate detailed graphical analysis.

Recommended Articles

This is a guide to Data Blending in Tableau. Here we discuss the basic concept with a step-by-step procedure to perform data blending in Tableau. You may also look at the following article to learn more –

  1. Data Science Platform
  2. Data Mining Applications
  3. Big Data Architecture
  4. Data Science Career
WINDOWS POWERSHELL Course Bundle - 7 Courses in 1
19+ Hours of HD Videos
7 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
SALESFORCE Course Bundle - 4 Courses in 1
24+ Hours of HD Videos
4 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
MINITAB Course Bundle - 9 Courses in 1 | 2 Mock Tests
35+ Hour of HD Videos
9 Courses
2 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
SAS PROGRAMMING Course Bundle - 18 Courses in 1 | 8 Mock Tests
123+ Hours of HD Videos
18 Courses
8 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
Primary Sidebar
Popular Course in this category
TABLEAU Course Bundle - 16 Courses in 1 | 2 Mock Tests
 54+ Hour of HD Videos
16 Courses
2 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.5
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more