Combining Data Sources Using Data Blending in Tableau

In this video, we explore the concept of data blending in Tableau, a powerful feature that allows you to combine multiple data sources seamlessly. The tutorial demonstrates how to connect a Tableau workbook to two CSV files, establish relationships between the datasets, and use fields from both sources to create a comprehensive analysis. We dive into creating calculated fields, understanding how Tableau determines the best type of join automatically, and visualizing the combined data.

What will you learn

• How to connect Tableau to multiple CSV files.
• The concept of data blending and how it differs from traditional joins.
• How to establish relationships between datasets in Tableau.
• Creating calculated fields using data from multiple sources.
• Visualization techniques using blended data.
• How Tableau automatically determines the type of join needed.
• The significance of common fields in data blending.

Takeaway notes

• Data blending in Tableau allows combining data from different sources without specifying the type of join.
• Relationships are established using common fields between datasets.
• You don't need to merge databases manually; Tableau handles it based on the selected fields.
• You can use fields from different datasets to create calculated fields and perform a comprehensive analysis.
• Tableau segregates data from different sources in the dimensions and measures pane.
• A new calculated field can combine data from multiple datasets, allowing for sophisticated visualizations.

Practice questions

1. What is data blending in Tableau?
2. How does data blending differ from traditional joins?
3. Explain the process of connecting Tableau to multiple CSV files.
4. What is a relationship in the context of Tableau data blending?
5. How does Tableau determine the type of join when blending data?
6. Describe the steps to establish a relationship between two datasets in Tableau.
7. How can you use fields from different datasets to create a calculated field?
8. Why is it unnecessary to merge databases manually when using data blending in Tableau?
9. How does Tableau display fields from different datasets in the dimensions and measures pane?
10. What is the significance of common fields in data blending?
11. Give an example of a calculated field that combines data from multiple datasets.
12. What are the advantages of using data blending in Tableau?
13. How can relationships be edited once they are established in Tableau?
14. Describe a scenario where data blending would be beneficial in a business context.
15. How does dragging and dropping datasets help in establishing relationships in Tableau?