Storytelling with data in Tableau - Dashboard Guide

Dashboard Mode - Storytelling with data

Business Question

How can we tell a clear story about our sales performance across regions and product categories to help managers make better decisions?

Sample Data

Region	Product Category	Sales	Profit	Month
East	Furniture	1000	200	January
East	Technology	1500	300	January
West	Furniture	1200	250	January
West	Office Supplies	800	100	January
East	Office Supplies	700	150	January
West	Technology	1600	400	January
East	Furniture	1100	220	February
West	Furniture	1300	270	February

Dashboard Components

• KPI Card: Total Sales
  Formula: SUM([Sales])
  Result: 9200
  Description: Shows total sales across all regions and categories.
• KPI Card: Total Profit
  Formula: SUM([Profit])
  Result: 1890
  Description: Shows total profit across all data.
• Bar Chart: Sales by Region
  Formula: SUM([Sales]) grouped by [Region]
  Result: East = 4300, West = 4900
  Description: Compares sales between East and West regions.
• Stacked Bar Chart: Sales by Product Category and Region
  Formula: SUM([Sales]) grouped by [Product Category] and [Region]
  Description: Shows sales distribution by product category within each region.
• Line Chart: Sales Over Time
  Formula: SUM([Sales]) grouped by [Month]
  Description: Displays sales trend for January and February.
• Data Table: Detailed Sales Data
  Shows all columns from sample data for detailed view.

Dashboard Layout

+----------------------+----------------------+
|   KPI: Total Sales   |   KPI: Total Profit   |
+----------------------+----------------------+
|      Bar Chart: Sales by Region           |
+-------------------------------------------+
| Stacked Bar Chart: Sales by Category & Region |
+-------------------------------------------+
|        Line Chart: Sales Over Time         |
+-------------------------------------------+
|          Data Table: Detailed Sales        |
+-------------------------------------------+

Interactivity

A filter for Region allows users to select East, West, or both. When a region is selected, all components update to show data only for that region. For example, selecting 'East' updates KPIs, charts, and table to reflect East region sales and profit.

A filter for Month lets users choose January, February, or both, updating the line chart and other components accordingly.

Self Check

If you add a filter for Product Category = Furniture, which components update?

• Both KPI cards update to show total sales and profit for Furniture only.
• Bar Chart updates to show sales by region for Furniture.
• Stacked Bar Chart updates to show only Furniture sales (effectively a single color stack).
• Line Chart updates to show sales over time for Furniture.
• Data Table filters to show only Furniture rows.

Key Result

A sales dashboard telling the story of total sales, profit, and trends by region, product category, and time.

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