Blending data sources in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Primary and Secondary Data Sources in Tableau

In Tableau, when blending data from two sources, which statement correctly describes the role of the primary data source?

A The primary data source is only used to join tables before blending.

B The primary data source defines the view's structure and drives the filters and calculations.

C The primary data source is ignored if the secondary source has more records.

D The primary data source automatically duplicates all fields from the secondary source.

💡 Hint

Think about which data source controls the main visualization layout.

The primary data source in Tableau controls the view's structure, including filters and calculations. The secondary source provides additional data linked by common fields.

❓ dax_lod_result

intermediate

Result of a Tableau Data Blend with Different Granularity

Suppose you blend two data sources in Tableau: Source A has daily sales data, and Source B has monthly targets. If you create a view by day using Source A and blend Source B on month, what will happen to the target values?

A The monthly target value will be duplicated for each day in that month.

B The target value will be averaged across all days automatically.

C The target value will be null for all days except the first day of the month.

D The target value will be summed across all months.

💡 Hint

Consider how Tableau matches data when blending at different levels of detail.

When blending data at different granularities, Tableau duplicates the secondary source's value for each matching primary source row. Here, the monthly target repeats for each day.

❓ visualization

advanced

Choosing the Best Visualization for Blended Data

You have blended sales data from two sources: one with product details and another with regional targets. You want to show actual sales vs. target by region and product category. Which visualization best communicates this comparison clearly?

A A scatter plot with sales on X-axis and product category on Y-axis.

B A pie chart showing total sales by product category only.

C A line chart showing sales trends over time without target data.

D A stacked bar chart showing sales and target side by side for each region and category.

💡 Hint

Think about how to compare two related measures across categories and regions.

A stacked bar chart side by side for sales and target allows easy comparison across regions and categories, making differences clear.

🔧 Formula Fix

advanced

Troubleshooting Null Values in Blended Data

After blending two data sources in Tableau on the field 'Customer ID', you notice many null values in the secondary source fields. What is the most likely cause?

A The 'Customer ID' field has mismatched data types or formatting between the two sources.

B The primary data source has missing records for some customers.

C Tableau does not support blending on fields named 'Customer ID'.

D The secondary source is set as primary by mistake.

💡 Hint

Check how the linking field matches between sources.

Nulls often occur when the linking field values do not match exactly due to data type or formatting differences, causing no join match.

🎯 Scenario

expert

Designing a Data Blend for Performance and Accuracy

You need to blend a large transactional sales dataset with a smaller customer demographic dataset in Tableau. The sales data updates daily, and the demographic data updates monthly. How should you design the blend to optimize performance and ensure accurate reporting?

A Use the demographic data as primary source and blend sales data, filtering sales to last month only.

B Join both datasets outside Tableau before import to avoid blending.

C Use the sales data as primary source and blend the demographic data on Customer ID, filtering demographic data to latest month only.

D Blend both sources without filters and aggregate sales data at monthly level.

💡 Hint

Consider update frequency and data size when choosing primary source and filters.

Using the larger, frequently updated sales data as primary and filtering the smaller demographic data to the latest month reduces data volume and keeps reports accurate and performant.