...

Open source softwares - Tableau

Back to Course

Lesson Description


Lession - #867 TABLEAU DATA BLENDING


TABLEAU DATA BLENDING

Information Blending is an extremely strong element in Tableau. It is utilized when there is connected information in various information sources, which you need to dissect together in a solitary view. For instance, consider the Sales information is available in a social data set and Sales Target information in an Excel calculation sheet. Presently, to contrast real deals with target deals, you can mix the information in view of normal aspects to gain admittance to the Sales Target measure. The two sources engaged with information mixing are alluded as essential and auxiliary information sources. A left join is made between the essential information source and the optional information source with every one of the information columns from essential and matching information lines from auxiliary information source.

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.