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.

Practice

1. In Tableau, what is the main purpose of dragging a Dimension field to the Rows or Columns shelf?

easy

A. To perform calculations on numerical data

B. To filter out unwanted data from the view

C. To group or categorize data in the visualization

D. To change the color of the chart elements

Solution

1. Step 1: Understand Dimensions in Tableau

   Dimensions are fields that contain categorical data used to group or segment data.

2. Step 2: Role of Rows and Columns shelves

   Dragging a Dimension to Rows or Columns organizes data into groups along those axes.

3. Final Answer:

   To group or categorize data in the visualization -> Option C

4. Quick Check:

   Dimensions group data [OK]

Hint: Dimensions group data on axes, measures show numbers [OK]

Common Mistakes:

• Confusing dimensions with measures
• Thinking dimensions perform calculations
• Using dimensions to filter instead of group

2. Which of the following is the correct way to create a simple bar chart in Tableau?

easy

A. Drag a Measure to Filters and a Dimension to Tooltip

B. Drag a Measure to Rows and a Dimension to Columns

C. Drag a Dimension to Filters and a Measure to Color

D. Drag a Dimension to Pages and a Measure to Detail

Solution

1. Step 1: Identify bar chart basics

   A bar chart shows measure values grouped by dimension categories.

2. Step 2: Correct shelf placement

   Placing a Measure on Rows and a Dimension on Columns creates bars grouped by dimension.

3. Final Answer:

   Drag a Measure to Rows and a Dimension to Columns -> Option B

4. Quick Check:

   Measure on Rows + Dimension on Columns = Bar chart [OK]

Hint: Bar charts need measure on Rows and dimension on Columns [OK]

Common Mistakes:

• Putting measures on Filters instead of Rows or Columns
• Using Dimensions in Filters instead of Rows/Columns
• Confusing Color or Tooltip with main chart axes

3. Given a dataset with Category as a Dimension and Sales as a Measure, what will Tableau display if you drag Category to Columns and SUM(Sales) to Rows?

medium

A. A bar chart showing total sales for each category

B. A pie chart showing sales distribution by category

C. A table listing categories and sales values

D. A scatter plot with categories on X and sales on Y

Solution

1. Step 1: Understand shelf placement effect

   Category on Columns creates groups along horizontal axis; SUM(Sales) on Rows creates vertical bars.

2. Step 2: Default chart type for this setup

   Tableau defaults to bar chart when a dimension and aggregated measure are placed on Columns and Rows.

3. Final Answer:

   A bar chart showing total sales for each category -> Option A

4. Quick Check:

   Dimension + SUM(Measure) = Bar chart [OK]

Hint: Dimension on Columns + SUM(Measure) on Rows = bar chart [OK]

Common Mistakes:

• Expecting pie chart without selecting it
• Thinking Tableau shows table by default
• Confusing scatter plot with bar chart

4. You tried to create a bar chart by dragging Sales to Columns and Category to Rows, but Tableau shows a single bar instead of multiple bars. What is the likely issue?

medium

A. You dragged the Measure to Columns instead of Rows

B. The data source has no categories

C. You forgot to aggregate the Sales field

D. The Category field is treated as a Measure, not a Dimension

Solution

1. Step 1: Check field data types

   If Category is treated as a Measure, Tableau aggregates it, losing grouping.

2. Step 2: Effect on visualization

   Without Category as Dimension, Tableau shows one aggregated bar instead of multiple.

3. Final Answer:

   The Category field is treated as a Measure, not a Dimension -> Option D

4. Quick Check:

   Category must be Dimension for multiple bars [OK]

Hint: Ensure categories are Dimensions, not Measures [OK]

Common Mistakes:

• Assuming measure placement causes single bar
• Not checking field data type
• Ignoring data source structure

5. You want to create a stacked bar chart in Tableau showing Sales by Category and colored by Region. Which steps should you follow?

hard

A. Drag Category to Columns, SUM(Sales) to Rows, and Region to Color

B. Drag Region to Columns, Category to Rows, and Sales to Filters

C. Drag Sales to Columns, Region to Rows, and Category to Tooltip

D. Drag Category to Filters, Region to Color, and Sales to Detail

Solution

1. Step 1: Place Category and Sales for bar chart

   Category on Columns groups bars; SUM(Sales) on Rows sets bar height.

2. Step 2: Add Region to Color for stacking

   Dragging Region to Color splits bars by region colors, creating stacked bars.

3. Final Answer:

   Drag Category to Columns, SUM(Sales) to Rows, and Region to Color -> Option A

4. Quick Check:

   Category + SUM(Sales) + Region on Color = Stacked bar [OK]

Hint: Use Color shelf to stack bars by category [OK]

Common Mistakes:

• Putting Region on Rows or Filters instead of Color
• Not aggregating Sales
• Using Tooltip or Detail instead of Color for stacking