Multiple data sources in Tableau - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does 'Multiple data sources' mean in Tableau?

It means connecting and using data from more than one place or file in a single Tableau workbook to create combined views or analysis.

intermediate

What is a 'Data Blend' in Tableau?

Data Blend is a way to combine data from different sources by linking them on a common field, allowing you to analyze them together without merging the data physically.

intermediate

What is the difference between 'Data Join' and 'Data Blend' in Tableau?

Data Join combines tables from the same data source before analysis, while Data Blend combines data from different sources after aggregation, linking on common fields.

beginner

How do you add a second data source in Tableau?

You click 'Add' in the Data pane, select the new data source, and then you can use fields from both sources in your views.

beginner

Why is it important to have a common field when blending data sources?

A common field acts like a link or key to match related data from different sources, so Tableau knows how to combine the information correctly.

What is the main purpose of using multiple data sources in Tableau?

A To delete old data

B To speed up Tableau software

C To create more colors in charts

D To analyze data from different places together

Using multiple data sources lets you combine and analyze data from different places in one view.

Which method combines data from different sources after aggregation in Tableau?

A Data Join

B Data Extract

C Data Blend

D Data Filter

Data Blend links aggregated data from different sources using a common field.

What must two data sources have to blend data successfully in Tableau?

A A common field

B Same file format

C Same number of rows

D Same column names

A common field is needed to link data from different sources correctly.

How do you add a new data source in Tableau?

A Restart Tableau

B Click 'Add' in the Data pane

C Delete existing data

D Change worksheet name

You add a new data source by clicking 'Add' in the Data pane.

Which of these is NOT a way to combine data in Tableau?

A Data Filter

B Data Blend

C Union

D Data Join

Data Filter is used to limit data, not to combine data sources.

Explain how you can use multiple data sources in Tableau to create a combined report.

Think about how you link data from different places.

Describe the difference between data join and data blend in Tableau.

Consider when and how the data is combined.