Storytelling with data in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ visualization

intermediate

Choosing the Best Chart for Comparing Sales Over Time

You have monthly sales data for three product categories over one year. Which chart type best helps tell the story of trends and comparisons across categories?

A A line chart with separate lines for each product category over the months

B A stacked bar chart showing total sales per month with segments for each category

C A pie chart for each month showing category sales proportions

D A scatter plot with months on the x-axis and sales on the y-axis, colored by category

💡 Hint

Think about how to show trends over time and compare categories clearly.

A line chart with separate lines for each category clearly shows trends over time and allows easy comparison between categories. Stacked bars can hide individual category trends, pie charts are hard to compare across months, and scatter plots are less intuitive for time series.

🧠 Conceptual

intermediate

Understanding the Role of Color in Storytelling

When designing a dashboard to tell a story about sales performance, what is the best practice for using color?

A Use color only to highlight important data points or differences, keeping the rest neutral

B Use many bright colors to make the dashboard look lively and attract attention

C Use red for all positive values and green for all negative values to keep it consistent

D Use random colors for each chart to make them distinct and avoid confusion

💡 Hint

Think about how color guides the viewer's focus and supports understanding.

Using color sparingly to highlight important data or differences helps viewers focus on key insights. Too many colors can distract or confuse. Also, red usually signals negative and green positive, so option A is misleading.

❓ dax_lod_result

advanced

Calculating Total Sales for Top 3 Customers Using LOD Expression

Given a sales dataset with Customer and Sales Amount, which Tableau LOD expression correctly calculates the total sales for the top 3 customers by sales?

A { FIXED [Customer] : SUM([Sales Amount]) }

B { FIXED : SUM( IF RANK(SUM([Sales Amount])) <= 3 THEN [Sales Amount] ELSE 0 END ) }

C SUM( IF RANK(SUM([Sales Amount])) <= 3 THEN [Sales Amount] ELSE 0 END )

D { FIXED [Customer] : IF RANK(SUM([Sales Amount])) <= 3 THEN SUM([Sales Amount]) ELSE 0 END }

💡 Hint

Remember that LOD expressions fix the level of detail and ranking functions must be used carefully.

Option D uses FIXED [Customer] LOD to compute rank per customer and sum sales only for top 3 customers. When aggregated, it gives total for top 3. Option D calculates sales per customer but does not filter top 3. Option D uses FIXED without dimension, incorrectly computing at table level without customer partitioning. Option D is a regular table calculation without LOD.

🔧 Formula Fix

advanced

Identifying the Cause of Misleading Dashboard Insight

A dashboard shows total sales by region using a pie chart. The slices look almost equal, but the actual sales numbers differ greatly. What is the most likely cause?

A The dashboard filters are set to show only one region

B The data source has missing sales values causing incorrect totals

C The pie chart is using count of orders instead of sum of sales

D The pie chart colors are too similar, making slices hard to distinguish

💡 Hint

Check what measure the pie chart is actually summarizing.

If the pie chart uses count of orders instead of sum of sales, the slices will reflect order counts, not sales amounts, causing misleading visuals. Missing data or filters would cause different issues. Color similarity affects perception but not slice size.

🎯 Scenario

expert

Designing a Dashboard to Tell a Clear Story for Executive Review

You need to create a dashboard for executives to review quarterly sales performance. They want to quickly understand overall performance, key drivers, and areas needing attention. Which combination of elements best supports this storytelling goal?

A A dashboard with multiple detailed tables, a complex scatter plot, and a map showing all sales locations

B A dashboard with a KPI summary, a trend line chart for sales over time, and a bar chart highlighting top underperforming regions

C A dashboard with colorful pie charts for each product category and a detailed sales transaction list

D A dashboard with only a large sales total number and a table of all sales reps

💡 Hint

Think about clarity, focus, and actionable insights for busy executives.

Option B provides a clear KPI summary for quick understanding, a trend line to see performance over time, and a bar chart to highlight problem areas, supporting effective storytelling. Other options are either too detailed, cluttered, or lack focus.