NewDataLabs

Tableau - Business Intelligence Tools

  • Solutions
    • ETL
      • Tableau Prep
      • Airflow
      • Power Query
      • Microsoft Integration Services
      • Fivetran
    • Data warehouses
      • Snowflake
      • Google Big QUERY
      • Microsoft SQL Server
      • PostgreSQL
      • Web analytics
      • Amplitude
    • Business Intelligence
      • Tableau
        • What is Tableau?
        • How to implement Tableau properly?
        • Interactive management dashboard
        • Tableau price list
        • Products of Tableau
          • – Tableau Desktop
          • – Tableau Server
          • – Tableau Prep
          • – Tableau Online
        • Tableau Audit
        • Tableau Day
      • Power BI
  • Services
    • Tableau workshops on your data – Proof of Concept
    • Preparation of data – ETL
    • Reporting and data visualization
    • Migration services
    • Tableau training courses
    • Embedded Analytics
  • Salesforce
    • Salesforce CRM
      • Customer relationship management
      • Sale
        • Sales opportunity management
      • Business Intelligence analysis
      • Salesforce Manufacturing Cloud
      • Salesforce Service Cloud
      • Salesforce Marketing Cloud
    • Services
      • Proof of Concept
      • CRM workshops
      • Implementation of CRM
      • Post-implementation support
      • Data migration
      • Salesforce training
      • CRM consultancy
      • Salesforce integrations
    • Tableau + Salesforce
  • About Us
  • Customers
    • Our Customers
    • Customer stories
      • Totalizator Sportowy Sp. z o.o.
      • Snieżka S.A.
      • Werner Kenkel Sp. z o.o.
      • DOZ S.A.
  • Events
    • Webinars >
      • Salesforce
      • Tableau
      • Power BI
    • Tableau Training Courses >
      • New Data Model
      • Tableau online course
      • Tableau training courses
    • Power BI Training Course
  • Blog
  • Download Tableau
    • Tableau Desktop – Trial
    • Tableau Server – Trial
    • Tableau Prep – Trial
    • Tableau Reader
  • Contact
EN / PL

Data Blending in Tableau

2024-05-05

Do you work with Explorer and want to combine your data? Or perhaps you have a license for Creator, but your ability to link the data is limited due to data security policies? If yes, you should definitely find out more about Data Blending.

How to combine data in Tableau?

Everyone, who works with Tableau, is aware that sometimes a single table with data is not sufficient and you need to extract additional information from another table. There are several ways to do that. You can ask you data engineer to perform it in SQL, however it is best to do it by yourself. If you have a license for Creator, you have the following three options: joins, relationships and blending. Joins allow you to combine data into one large table. Relationships present tables separately, but they define the way to quickly join the data when needed. Then Tableau will automatically create relevant joins. The last option is blending. The simplest definition would be to say it is the aggregated left join “on the fly.” But what does it mean and when to use it?

The story behind blending

In the past, data blending in Tableau played a significant role as it helped join the data from various databases. Later on, the function Cross Data Join was introduced, which allows us to combine the data by joins, and it took over this capability from blending almost completely. However, blending still helps combine the data at various levels of detail, but these days, it is being pushed out by relationships. When should you use it then?

First of all, it’s suitable for users, who have a license for Explorer. They can create reports only based on ready data sources stored in Tableau Online (Cloud) or Tableau Server. They don’t have access to joins and relationships, but they can use blending.

However, if you have a Creator license, you can work on the source protected in the Row Level Security. Adding a table to your source to configurate the security on the row level makes it almost impossible to use relationships. There is no problem with joins, however they aren’t good when you have data sources with various levels of detail. Blending would be a better choice here.

How does blending work?

I have already quoted my favourite definition, which says “blending is the aggregated left join on the fly.” What does it mean? The best approach is to explain it step by step. Let’s start with the left join. It is a method allowing to combine two tables in one summary table. In order to do that, start with identifying the key field. This is a column with the dimension that is common for two tables. In the below example, this will be a Segment. Sometimes you may have several common fields and the left join allows you to add to all the rows in the left table (the first table) the rows from the second table, which have the values of the key field in the first table. Where there is no data to be combined, cells are left blank (nulls), as illustrated in the drawing below.

The Left Join is additionally aggregated in blending. This means a different approach in the situation where in the table on the right you have several rows which correspond with the row on the left. In the case of a join, all of these rows will be added to the summary table, each of them separately. In blending, the values from the table on the right-hand side will be aggregated and further processed in the aggregated form. This aggregation is usually the sum as illustrated below.

It is the aggregation that makes blending useful when you have various levels of data since it prevents unnecessary duplication of rows.

Last but not least, the term “on the fly.” Blending works the same way as the left join, the only difference is that the left join permanently links the tables. It is an integral part of preparing the source of data, whereas blending is built at the level of one specific visualization and will work in this particular visualization only.

Drawbacks of blending

It is not without a reason that blending has been gradually replaced by other solutions. Also many Tableau users don’t like it for a reason as it has certain drawbacks. The most significant disadvantage is that it doesn’t work for non-additive aggregations. We can sum up – calculate the average. However, you won’t be able to count unique items – COUNTD, or medians. Another issue are all number functions except for MIN() and MAX(). Therefore, you may not be able to calculate roots, cosines on the blended data, or to round them off. In addition, it’s also difficult to calculate LODs based on blending, so these solutions seem to be designed for simpler tasks, but sometimes there is no other choice.

Agata Mężyńska

Tableau Desktop Certified Professional

Webinars
> Amplitude Webinars
> Tableau Webinars
> Power BI Webinars

Tableau training courses
Power BI online course
ETL
> Tableau Prep
> Airflow
> Power Query
> Microsoft Integration Services
Data warehouses
> Snowflake
> Google BigQuery
> Microsoft SQL Server
> PostgreSQL
Business intelligence
> Tableau
> Salesforce
> Power BI
Web analytics
> Amplitude
Salesforce
> Customer relationship management
> Sale
> Sales opportunity management
> Analysis Business Intelligence
> Salesforce Manufacturing Cloud
> Salesforce Service Cloud
> Salesforce Marketing Cloud
Contact

contact@newdatalabs.com
contact@newdatalabs.com


601797783
+48 781 648 194


Adres
Correspondence address:
al. T. Boy’a – Żeleńskiego 26,
51-160 Wrocław

Copyright © 2025

Manage Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage {vendor_count} vendors Read more about these purposes
View preferences
{title} {title} {title}
The newdatalabs.com/en website uses cookies. We use information saved using cookies and similar technologies, including for advertising and statistical purposes and to adapt our website to the individual needs of users. By continuing to use the site, you agree to the terms.Close