First Tableau visualization - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ visualization

intermediate

Identify the Correct Chart Type for Sales Over Time

You have sales data by month. Which chart type best shows sales trends over time?

A Bar chart with months on X-axis and sales on Y-axis

B Line chart with months on X-axis and sales on Y-axis

C Pie chart showing sales by month

D Scatter plot with sales on X-axis and months on Y-axis

💡 Hint

Think about how to show changes over time clearly.

A line chart connects points over time, making trends easy to see. Bar charts show amounts but don't connect points. Pie charts compare parts of a whole, not trends. Scatter plots show relationships, not time series.

❓ dax_lod_result

intermediate

Calculate Total Sales per Region Using LOD Expression

Given a sales dataset with fields Region and SalesAmount, which Tableau LOD expression correctly calculates total sales per region regardless of filters?

A { FIXED [Region] : SUM([SalesAmount]) }

B { INCLUDE [Region] : SUM([SalesAmount]) }

C { EXCLUDE [Region] : SUM([SalesAmount]) }

D SUM([SalesAmount])

💡 Hint

Which LOD expression fixes the calculation at the region level ignoring filters?

The FIXED LOD expression calculates the sum of sales per region regardless of other filters. INCLUDE and EXCLUDE adjust the level of detail differently. SUM alone respects filters.

🧠 Conceptual

advanced

Understanding Context Filters in Tableau

What is the main purpose of a context filter in Tableau?

A To permanently delete data from the source

B To format the visualization colors

C To change the data source connection

D To create a temporary table that other filters use as a base

💡 Hint

Think about how filters can affect other filters.

Context filters create a subset of data that other filters then apply to. This improves performance and controls filter order. They do not delete data or change connections.

❓ data_modeling

advanced

Choosing the Right Join Type for Combining Customer and Orders Data

You have two tables: Customers and Orders. You want to see all customers, including those without orders. Which join type should you use in Tableau?

A Inner join

B Full outer join

C Left join with Customers as left table

D Right join with Orders as left table

💡 Hint

Which join keeps all customers even if they have no orders?

A left join with Customers as the left table keeps all customers and adds matching orders. Inner join excludes customers without orders. Right join and full outer join behave differently.

🔧 Formula Fix

expert

Identify the Error in This Tableau Calculation

Review this Tableau calculated field:
IF SUM([Sales]) > 1000 THEN 'High' ELSEIF SUM([Sales]) > 500 THEN 'Medium' ELSE 'Low' END
What error will this cause?

Tableau

IF SUM([Sales]) > 1000 THEN 'High' ELSE IF SUM([Sales]) > 500 THEN 'Medium' ELSE 'Low' END

A Syntax error because ELSEIF should be ELSE IF

B No error; calculation works correctly

C Syntax error because END is missing

D Runtime error due to aggregation inside IF

💡 Hint

Check the correct syntax for multiple conditions in Tableau IF statements.

Tableau requires ELSE IF as two words, not ELSEIF. Using ELSEIF causes a syntax error. Aggregations inside IF are allowed. END is present.