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.

Practice

1. What is the main purpose of storytelling with data in Tableau?

easy

A. To make data easy to understand and engaging for the audience

B. To create complex formulas for data analysis

C. To store large amounts of data efficiently

D. To write code for automating data refresh

Solution

1. Step 1: Understand storytelling with data

   Storytelling with data means presenting data in a way that is easy to understand and engaging.

2. Step 2: Identify Tableau's role

   Tableau helps create visuals and stories that guide the audience through the data clearly.

3. Final Answer:

   To make data easy to understand and engaging for the audience -> Option A

4. Quick Check:

   Storytelling = Clear, engaging data [OK]

Hint: Storytelling means making data simple and interesting [OK]

Common Mistakes:

• Confusing storytelling with data storage
• Thinking storytelling is about coding
• Believing it is only about formulas

2. Which Tableau feature is specifically designed to create a guided narrative through data?

easy

A. Data Source

B. Calculated Fields

C. Filters

D. Story Points

Solution

1. Step 1: Identify Tableau features for storytelling

   Story Points in Tableau allow you to create a sequence of visualizations that tell a story.

2. Step 2: Compare with other features

   Data Source is for connecting data, Calculated Fields create new data, Filters limit data shown, but only Story Points guide a narrative.

3. Final Answer:

   Story Points -> Option D

4. Quick Check:

   Guided narrative = Story Points [OK]

Hint: Story Points = step-by-step story in Tableau [OK]

Common Mistakes:

• Choosing Data Source as storytelling tool
• Confusing Calculated Fields with story creation
• Thinking Filters create stories

3. Consider a Tableau dashboard with sales data and a text box explaining trends. What is the main benefit of combining visuals with text in storytelling?

medium

A. It makes the dashboard load faster

B. It helps users understand the data story clearly

C. It reduces the amount of data needed

D. It automatically updates data sources

Solution

1. Step 1: Understand combining visuals and text

   Visuals show data patterns; text explains and guides the audience through the story.

2. Step 2: Identify the benefit

   Combining both helps users grasp the meaning behind numbers easily and clearly.

3. Final Answer:

   It helps users understand the data story clearly -> Option B

4. Quick Check:

   Visuals + text = clear understanding [OK]

Hint: Text explains visuals for clear stories [OK]

Common Mistakes:

• Thinking it improves performance
• Believing it reduces data size
• Assuming it updates data automatically

4. You created a Tableau story but the audience finds it confusing. Which of these is the most likely error?

medium

A. Adding calculated fields

B. Connecting to the wrong data source

C. Using too many story points without clear transitions

D. Using filters on the dashboard

Solution

1. Step 1: Analyze storytelling clarity

   Too many story points without clear flow can confuse the audience.

2. Step 2: Evaluate other options

   Wrong data source, filters, or calculated fields may cause issues but usually not confusion in story flow.

3. Final Answer:

   Using too many story points without clear transitions -> Option C

4. Quick Check:

   Confusing story = unclear story points [OK]

Hint: Keep story points clear and few [OK]

Common Mistakes:

• Blaming filters for confusion
• Thinking calculated fields cause confusion
• Assuming data source errors cause story confusion

5. You want to create a Tableau story that highlights quarterly sales trends and explains reasons behind changes. Which combination best supports effective storytelling?

hard

A. Create story points with visuals and add descriptive captions for each point

B. Use a dashboard with charts only, no text or story points

C. Use only text boxes with detailed explanations, no visuals

D. Build multiple dashboards without linking them in a story

Solution

1. Step 1: Identify storytelling elements

   Effective storytelling combines visuals and text to explain data clearly.

2. Step 2: Evaluate options for highlighting trends and explanations

   Story points with visuals and captions guide the audience step-by-step, making the story clear and engaging.

3. Final Answer:

   Create story points with visuals and add descriptive captions for each point -> Option A

4. Quick Check:

   Visuals + captions + story points = best storytelling [OK]

Hint: Combine visuals and captions in story points [OK]

Common Mistakes:

• Using visuals without explanation
• Using text only without visuals
• Not linking dashboards in a story