Ultimate Tableau Desktop Course - Beginner to Advanced Bundle - Using Multiple Data Sources

The video tutorial explains data blending in Tableau, highlighting its differences from joins and relationships. It covers setting up data blending, managing linking fields, and compares it with various join types. The tutorial also introduces UNION as a method to combine data vertically, emphasizing its use when tables have the same structure.

What is a key difference between data blending and joins in Tableau?

• Joins work only with published data sources.

• Blending combines data sources into one.

• Blending queries each data source independently.

• Joins aggregate data before combining.

In data blending, what does a red chain icon indicate?

• The field is not used in the view.

• The field is a potential linking field.

• The field is the active linking field.

• The field is a primary data source.

What happens when a linking field is removed in data blending?

• The blend is deactivated.

• The data sources are combined.

• The view shows aggregated data.

• The primary data source changes.

How does data blending handle aggregation compared to joins?

• Joins aggregate data after combining.

• Blending aggregates data after combining.

• Blending aggregates data before combining.

• Joins do not aggregate data.

Which join type includes all records from the left table and matching records from the right table?

• Inner join

• Left join

• Right join

• Full outer join

What is the result of a full outer join?

• All records from both tables

• Only matching records from both tables

• All records from the left table

• All records from the right table

Which join type results in NULL values for non-matching records from the right table?

• Inner join

• Left join

• Right join

• Full outer join

How does UNION differ from other data combining methods in Tableau?

• It only works with published data sources.

• It requires matching field names.

• It appends data vertically.

• It combines data horizontally.

What is required for a successful UNION in Tableau?

• Different number of fields in each table

• Unique field names in each table

• Matching field names and data types

• Different data types in each table

What additional fields are created in a UNION to provide information about the original data?

• Sheet and Table Name

• Path and File Size

• Field Name and Type

• Data Type and Length