LOUISVILLE, KENTUCKY
ATLANTA, GEORGIA
CHICAGO, ILLINOIS
CINCINNATI, OHIO
DENVER, COLORADO
MADISON, WISCONSIN
RARITAN, NEW JERSEY
TORONTO, ONTARIO
NOIDA, INDIA
HYDERABAD, INDIA

V-Soft's Corporate Headquarters

101 Bullitt Lane, Suite #205
Louisville, KY 40222

502.425.8425
TOLL FREE: 844.425.8425
FAX: 502.412.5869

Denver, Colorado

6400 South Fiddlers Green Circle Suite #1150
Greenwood Village, CO 80111

TOLL FREE: 844.425.8425

Chicago, Illinois

208 N. Green Street, #302, Chicago, IL 60607

TOLL FREE: 844.425.8425

Madison, Wisconsin

2810 Crossroads Drive, Ste. 4000
Madison, WI 53718

TOLL FREE: 844.425.8425

Atlanta, Georgia

1255 Peachtree Parkway Suite #4201
Cumming, GA 30041

TOLL FREE: 844.425.8425

Cincinnati, Ohio

Spectrum Office Tower 11260
Chester Road Suite 350
Cincinnati, OH 45246

Phone: 513.771.0050

Raritan, New Jersey

216 Route 206 Suite 22 Hillsborough Raritan, NJ 08844

Phone: 513.771.0050

Toronto, Canada

1 St. Clair Ave W Suite #902, Toronto, Ontario, M4V 1K6

Phone: 416.663.0900

Hyderabad, India

Incor 9, 3rd Floor, Kavuri Hills
Madhapur, Hyderabad – 500033 India

PHONE: 040-48482789

Noida, India

H-110 - Sector 63 ,
NOIDA , Gautham Budh Nagar ,
UP – 201301

How Tableau's Data Blending Feature Transforms Data

Man working on Tableau data blending tool

Tableau is a robust Business Intelligence (BI) tool that comes with a wide-range of data visualization and analytics capacities, to enable businesses to gain deeper insights into the vast enterprise data and drive better business decisions. This application facilitates easy integration with any data source of varied data representations and effortlessly extracts and maps data to generate data visualizations in interactive dashboards.  Let's examine how Tableau transforms and blends data using the Data Blending feature.

Ways Tableau Transforms Data

Clean Data with Data Interpreter

After importing data using available data sources, if Tableau detects any discrepancy within the data, such as improper display of header column names. In such cases, Tableau offers a “Clean with data interpreter” option to clean data. The option will remove extra information and share information about what tableau has done. Upon clicking the button, an excel file will be opened and the data will be added to green section and headers will be added to orange sections.

Split Fields

After importing data using available data sources, using the split option we can split columns. For example, if one column has state and city data, using a split option  will make it easy to divide those data points into 2 fields and will change the header names to "state" and "city".

Merge Data with Unions

Using tableau, we can merge data into one table and combine 2-column data into single columns.

Adding Relationships with Joins

Tableau provides different types of joins like Inner, Outer, Left, Right, & Full Outer. Using these joins, we can transform the data as needed.

How Tableau Displays Data in Reports Using Data Blending

Tableau solves various data visualization and analytics challenges by offering strong analytics dashboards. The Tableau Analytics dashboard displays data as views. Before this, data imported from different data sources were classified into measures & dimensions. Using the data blending technique, data coming from numerous data sources is combined into a single view. Using the data blending feature in Tableau, we can directly display information in the view by combining different data sources (as shown in the image below).

Figure: Add Relationships in Data Blending Process

Figure: Add Relationships in Data Blending Process

Key Aspects of Data Blending

  • Data blending works on a sheet by sheet basis
  • The primary data source is marked in blue, any secondary data sources and fields are marked in orange
  • Shared file names that are determined automatically by linking fields or relationships for blend will be created manually
  • Data blending behaves similarly to a left join, which may result in missing data from the secondary data source
  • Asterisks (*) indicates numerous dimension values in a single mark because data blending considers aggregated results and combines them in one view

Steps for Data Blending

Data blending is an efficient tool to combine multiple data sources. It is important to remember that data blending used to link fields vary from sheet to sheet.

To create a blend in the workbook, it is mandatory to connect at least 2 different data sources. First, we should identify common fields from both data sources and then bring the first field from one data source to the sheet, this becomes the primary data source and will be marked blue (refer below screenshot).  After selecting the field from other data sources, it automatically becomes a secondary data source on relationship pane and marked orange.

Figure: How to add data blend feature using different data sources

Figure: How to add data blend feature using different data sources

Data Blending Limitations

There are some data blending limitations such as:

  • Non-additive aggregates (COUNTD, MEDIAN, and RAWSQLAGG)
  • When published, blended data sources are published one by one in the same server and do not publish as a unit
  • For secondary data sources, data must always be aggregated in calculations

Conclusion

Tableau's data blending feature helps connect and source data from multiple data sources and provides relationships, combines data, generates reports easily. This allows businesses  to avoid using third party tools and applications to connect and source data from various enterprise systems. This saves effort and time for businesses. The blending feature allows businesses to gain deeper intelligence information from enterprise data. 

Suresh KarriAbout Author

Suresh Karri is the Technical Lead for Enterprise Application Development at V-Soft Consulting. He holds 8+ years of experience in Application Development & Database Design. Apart from these, he also possesses skills in building Web, Windows and Dashboard applications using technologies like Microsoft, Angular, Tableau and more.

Topics: Tableau, Data Visualization with Tableau, Data Visualization, data blending in tableau

Get tech and IT industry Updates

New call-to-action