• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Data Blending in Tableau

Data blending

Data blending is when you blend data from multiple data sources on a single worksheet. The data is joined on common dimensions. Data Blending does not create row level joins and is not a way to add new dimensions or rows to your data.

Data blending should be used when you have related data in multiple data sources that you want to analyze together in a single view.

To integrate data, you must first add one of the common dimensions from the primary data source to the view.

For example, when blending Actual and Target sales data, the two data sources may have a Date field in common. The Date field must be used on the sheet. Then when you switch to the secondary data source in the Data window, Tableau automatically links fields that have the same name. If they don’t have the same name, you can define a custom relationship that creates the correct mapping between fields.

For each data source that is used on the sheet, a query is sent to the database and the results are processed. Then all the results are left joined on the common dimensions. The join is done on the member aliases of the common dimensions so if the underlying values aren’t an exact match, you can fix it up in Tableau.

In general, a good test to see whether data can be integrated smoothly is to drag the dimensions from the primary data source into a text table on one sheet. Then on another sheet, drag the same fields from the secondary data source into a text table. If the two tables match up then the data is most likely going to blend correctly in Tableau.

 At TekSlate, we offer resources to help you learn various IT courses. We avail both written material and demo video
            tutorials. For in-depth knowledge and practical experience explore Tableau Careers.

Data Blending on a Worksheet

Two data sources: Sample – Superstore Sales (Excel) that comes with the application and an auxiliary Excel file that contains forecasted sales information.

An example of each of their columns are shown below: Follow the steps below to use data from both data sources on a single worksheet.

Connect to Sample – Superstore Sales (Excel) and build a view that shows Sales by Customer Segment and Product Category.

Tableau_DataBlending

Select Data > Connect to Data and connect to the Sales Plan spreadsheet.

Drag the Sales Plan measure to the Level of Detail shelf.

Tableau_DataBlending1

Right-click the Sales axis and select Add Reference Line.

In the Reference Line dialog box, add a reference line that shows Sales Plan per cell. When finished, click OK.

Tableau_DataBlending2

The Worksheet is now pulling data from the secondary data source (Sales Plan) to show how actual sales compared to the forecasted sales.

Tableau_DataBlending3

For indepth knowledge on Tableau, click on below

Summary
Review Date
Reviewed Item
Data Blending in Tableau
Author Rating
4

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Data Blending in Tableau"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.