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.

Practice

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

easy

A. To create multiple dashboards separately

B. To combine data from different places into one view

C. To increase the size of a single data file

D. To export data to Excel automatically

Solution

1. Step 1: Understand the concept of multiple data sources

   Multiple data sources allow Tableau to bring together data from different origins.

2. Step 2: Identify the main benefit

   This lets users analyze combined data in one view without merging files physically.

3. Final Answer:

   To combine data from different places into one view -> Option B

4. Quick Check:

   Multiple data sources = Combine data [OK]

Hint: Multiple data sources combine data from different places [OK]

Common Mistakes:

• Thinking it only creates separate dashboards
• Believing it increases file size
• Confusing it with exporting data

2. Which of the following is the correct way to create a relationship between two data sources in Tableau?

easy

A. Drag a field from one source to a matching field in the other source

B. Use the Data menu to export both sources to CSV

C. Manually merge the data files outside Tableau

D. Create a calculated field with SUM() in both sources

Solution

1. Step 1: Identify how Tableau links data sources

   Tableau uses relationships by matching fields between sources to combine data logically.

2. Step 2: Recognize the correct method

   Dragging a field from one source to a matching field in another creates this relationship inside Tableau.

3. Final Answer:

   Drag a field from one source to a matching field in the other source -> Option A

4. Quick Check:

   Relationship creation = Drag matching fields [OK]

Hint: Drag matching fields to create relationships [OK]

Common Mistakes:

• Trying to export data to CSV for relationships
• Merging files outside Tableau instead of inside
• Using calculated fields incorrectly for relationships

3. Given two data sources: Sales and Targets, blended on 'Region', what will happen if a region exists in Sales but not in Targets when blending?

medium

A. The region will be excluded from the view entirely

B. Tableau will throw an error and stop loading data

C. Sales data for that region will show, but Target values will be null

D. Target values will be duplicated for that region

Solution

1. Step 1: Understand blending behavior with unmatched keys

   When blending, if a key exists in the primary source but not in the secondary, Tableau shows primary data but leaves secondary fields blank.

2. Step 2: Apply this to the region example

   Sales data for the unmatched region appears, but Targets show null because no matching region exists there.

3. Final Answer:

   Sales data for that region will show, but Target values will be null -> Option C

4. Quick Check:

   Blending unmatched keys = Primary shows, secondary null [OK]

Hint: Unmatched blend keys show primary data, secondary null [OK]

Common Mistakes:

• Assuming unmatched regions are excluded
• Expecting errors on unmatched keys
• Thinking secondary data duplicates

4. You created a blend between two data sources but notice the data is not matching correctly. What is the most likely cause?

medium

A. You used a calculated field instead of a dimension

B. You forgot to refresh the data extract

C. The dashboard has too many sheets

D. The linking fields have different data types or mismatched values

Solution

1. Step 1: Identify common blending issues

   Blending depends on matching fields; if data types or values differ, matches fail.

2. Step 2: Recognize the cause of mismatched data

   Different data types (e.g., string vs number) or inconsistent values prevent correct blending.

3. Final Answer:

   The linking fields have different data types or mismatched values -> Option D

4. Quick Check:

   Blending mismatch = Data type/value mismatch [OK]

Hint: Check data types and values of linking fields first [OK]

Common Mistakes:

• Blaming dashboard complexity
• Ignoring data refresh needs
• Confusing calculated fields with linking fields

5. You want to analyze sales data from two different databases: one with daily sales and another with monthly targets. How should you combine these in Tableau to compare performance effectively?

hard

A. Use relationships to link the data sources on the month field and blend the data

B. Join the two databases on the day field using an inner join

C. Export both datasets to Excel and merge manually before importing

D. Create separate dashboards for daily sales and monthly targets without linking

Solution

1. Step 1: Identify the best way to combine different granularity data

   Daily sales and monthly targets have different time levels, so joining on day would exclude unmatched data.

2. Step 2: Use relationships and blending on month field

   Linking on month lets Tableau combine data logically without losing unmatched days, enabling effective comparison.

3. Final Answer:

   Use relationships to link the data sources on the month field and blend the data -> Option A

4. Quick Check:

   Different granularity = Use relationships and blend [OK]

Hint: Link on common granularity (month) and blend data [OK]

Common Mistakes:

• Joining on day excludes unmatched data
• Merging outside Tableau wastes time
• Keeping dashboards separate loses combined insight