Data Blending in Tableau
Data Blending is a powerful feature of Tableau. It is used to analyze the data in a single view from a related data in multiple data source.
For example: Suppose a Sales data is present in a relational database and Sales Target data in an Excel sheet.
Now, for comparing the actual sales with the target sales, you have blended the data based on common dimensions to get access into the Sales Target measure.
The two data sources are involved in data blending are referred as the primary data source and the secondary data source.
A left join is built between the primary and the secondary data source with all the data rows from primary and only matching data rows from the secondary data source.
How to do data blending
Tableau has two inbuilt data sources that are Sample coffee chain.mdb and Sample-superstore, which can be used to illustrate data blending.
The below screenshot shows the different tables and joins available in the file:
How to Add Secondary Data Source
Add the secondary data source which name is Sample-superstore.xls with the following steps:
Blending the Data
You can integrate the data from sample-superstore and sample coffee chain sources based on a common dimension.