Preparing Data for Blending
Tableau has two inbuilt data sources named Sample-superstore and Sample coffee chain.mdb which will be used to illustrate data blending.
First load the sample coffee chain to Tableau and look at its metadata. Go to the menu - Data → New Data Source and browse for the sample coffee chain file, which is a MS Access database file. The following screenshot shows the different tables and joins available in the file.
Adding Secondary Data Source
Next, add the secondary data source named Sample-superstore by again following the steps - Data → New Data Source and choosing this data source. Both the data sources now appear on the Data window as shown in the following screenshot.
Blending The Data
Presently you can incorporate the information from both the above sources in view of a typical aspect. Note that a little chain picture shows up close to the aspect named State. This shows the normal aspect between the two information sources. Drag the State field from the essential information source to the lines rack and the field Profit Ratio from the auxiliary information source to the Columns rack. Then, select the projectile graph choice from Show Me to get the shot outline displayed in the accompanying screen capture. The graph shows how the benefit proportion fluctuates for each state in both the superstore and espresso chain shops.