Storytelling with data in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a basic bar chart showing sales by category.

Tableau

SUM([1])

Drag options to blanks, or click blank then click option'

AProfit

BCategory

CSales

DQuantity

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dimension like Category instead of a measure.

Using Profit or Quantity when the question asks for sales.

The SUM aggregation of the Sales field is used to show total sales in the bar chart.

2fill in blank

medium

Complete the code to filter the data to only include the year 2023.

Tableau

YEAR([Order Date]) = [1]

Drag options to blanks, or click blank then click option'

A2024

B2023

C2022

D2021

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a wrong year like 2022 or 2024.

Using the full date instead of just the year.

Filtering on YEAR([Order Date]) = 2023 restricts the data to orders made in 2023.

3fill in blank

hard

Fix the error in the calculated field to show profit ratio as a percentage.

Tableau

(SUM([Profit]) / [1]) * 100

Drag options to blanks, or click blank then click option'

ASUM([Sales])

BSUM([Quantity])

CAVG([Profit])

DCOUNT([Order ID])

Attempts:

3 left

💡 Hint

Common Mistakes

Using quantity or count instead of sales.

Using average profit instead of total sales.

The profit ratio is profit divided by sales, so the denominator should be SUM([Sales]).

4fill in blank

hard

Fill both blanks to create a filter that shows only categories with sales greater than 10000.

Tableau

IF SUM([Sales]) [1] [2] THEN 'Show' ELSE 'Hide' END

Drag options to blanks, or click blank then click option'

A>

B<

C10000

D5000

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' operator.

Using 5,000 instead of 10,000 as the threshold.

The condition SUM([Sales]) > 10000 filters categories with sales above 10,000.

5fill in blank

hard

Fill all three blanks to create a calculated field that returns the profit ratio only for the 'Technology' category.

Tableau

IF [Category] = [1] THEN SUM([3]) / SUM([2]) ELSE NULL END

Drag options to blanks, or click blank then click option'

A'Technology'

BSales

CProfit

D'Furniture'

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong category name or missing quotes.

Dividing profit by profit instead of sales.

The condition checks if the category is 'Technology'. Then it calculates profit ratio as SUM([Profit]) / SUM([Sales]). The else returns NULL.

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