Mastering Tableau 2018.1, Second Edition 4.1: Joining Your Data

The video tutorial explains how to combine and transform data from multiple sources using Tableau. It covers merging tables and worksheets, understanding different types of joins like inner, right, left, and full outer joins, and demonstrates these concepts using the Sample Superstore dataset. The tutorial also introduces joining different data sources such as Excel and CSV files, emphasizing the importance of data blending to gain insights.

What is the primary goal of merging different tables and worksheets?

• To separate data into different tables

• To create duplicate data

• To gain insights from combined data

• To delete unnecessary data

Which type of join should be used to get only the common data between two tables?

• Full outer join

• Left join

• Inner join

• Right join

What is a potential downside of using a full outer join?

• It creates a Cartesian product

• It only retrieves data from the left table

• It only retrieves data from the right table

• It does not allow data merging

In the Sample Superstore example, what is used as the primary key for joining tables?

• Product ID

• Order ID

• Customer ID

• Transaction ID

What is the result of performing a right join in the Sample Superstore example?

• No rows are returned

• Common rows from both tables

• All rows from the left table

• All rows from the right table

What is the main challenge when joining data from different data sources?

• Incompatible data types

• Lack of data blending tools

• Data sources cannot be combined

• Different data formats

What technique is used to join data from different sources like Excel and CSV files?

• Data separation

• Data deletion

• Data blending

• Data duplication