Data Blending In Tableau 

Pasting some common interview questions on Data Blending: When to use Data Blending * When you wan to combine data from different databases that are not supported by cross-database joins * When data is at different level of detail * When you are dealing with large amount of data * When your data needs some cleaning Limitation Of Datablending *"We cannot publish a blended data source as a single data source on the server. Instead, we need to publish the two data sources separately on the same server and then blend the published sources. It is a must to always aggregate data in calculations from the secondary data sources You might face issues while using non-additive aggregates like MEDIAN, COUNTD, etc when blending data" Difference between Join and Blending Joining your data can only be done when the data comes from the same source, for example from two sheet tabs within a single Excel file. If that same information was stored in separate Excel files you would need to do a data blend in Tableau