Multiple data sources in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Data Blending in Tableau

In Tableau, when you blend data from two different sources, what happens if the linking field has mismatched data types between the primary and secondary sources?

A The blend works but may produce incorrect or incomplete results due to mismatched data types.

B Tableau automatically converts the data types to match and blends the data without errors.

C Tableau shows a warning and does not blend the data until the data types match.

D The blend fails silently and returns no data for the secondary source.

💡 Hint

Think about how data type mismatches affect matching keys in joins or blends.

Tableau does not automatically convert data types during blending. If the linking fields have different data types, the blend may still run but produce incomplete or incorrect results because the keys do not match properly.

❓ dax_lod_result

intermediate

Calculating Total Sales from Multiple Sources

You have two data sources in Tableau: Sales_US and Sales_EU. Both have a SalesAmount field. You want to create a calculated field that sums sales from both sources. Which Tableau calculation correctly sums these amounts assuming data blending with Sales_US as primary?

A SUM([Sales_US].[SalesAmount]) + SUM([Sales_EU].[SalesAmount]) WITHOUT DATA BLENDING

B SUM([SalesAmount])

C SUM([Sales_US].[SalesAmount]) + SUM([Sales_EU].[SalesAmount])

D SUM([Sales_US].[SalesAmount]) + SUM([Sales_EU].[SalesAmount]) using data blending with secondary source aggregation

💡 Hint

Remember how Tableau aggregates data from secondary sources in blends.

In Tableau, when blending data, the secondary source aggregates at the level of detail of the primary source. You must ensure the calculation sums the primary source and the aggregated secondary source correctly.

❓ visualization

advanced

Designing a Dashboard with Multiple Data Sources

You have two data sources: one with customer demographics and another with sales transactions. You want to create a dashboard that filters sales by customer age group. What is the best practice to ensure the filter works correctly across both data sources?

A Join the two data sources into one before building the dashboard to enable filtering.

B Use a global filter on the customer age group field from the primary data source only.

C Blend the two data sources on customer ID and use a filter on the age group field from the primary source.

D Create a parameter for age group and use it to filter both data sources separately.

💡 Hint

Think about how filters behave with blends versus joins.

Filters on blended data sources apply only to the primary source. To filter across both sources seamlessly, joining the data into one source is best practice.

🔧 Formula Fix

advanced

Troubleshooting Data Source Refresh Issues

After blending two data sources in Tableau, you notice that the secondary source data does not update when you refresh the workbook. What is the most likely cause?

A The secondary data source is set to live connection but the primary is extract.

B The secondary data source is an extract and was not refreshed before opening the workbook.

C The linking fields have different names causing the blend to fail.

D The workbook is set to manual refresh mode for all data sources.

💡 Hint

Consider how Tableau handles extracts and live connections.

If the secondary source is an extract and was not refreshed, it will show stale data even after refreshing the workbook.

🎯 Scenario

expert

Optimizing Performance with Multiple Data Sources

You have a Tableau dashboard using three large data sources blended together. Users report slow load times. Which approach will most effectively improve performance without losing data accuracy?

A Convert all data sources to live connections to avoid extract refresh delays.

B Remove blending and use separate worksheets for each data source without combining data.

C Create a single combined extract by joining the data sources outside Tableau and connect Tableau to this extract.

D Use data blending but limit the number of fields used from secondary sources.

💡 Hint

Think about how data blending affects query performance and how extracts can help.

Joining data sources outside Tableau into one extract reduces the complexity of blending and improves performance while maintaining data accuracy.