Statistical summary card in Tableau - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants a quick overview of key sales statistics for the last quarter to share in the executive meeting.

📊 Data: You have sales transaction data including Date, Region, Product Category, Sales Amount, and Quantity Sold.

🎯 Deliverable: Create a statistical summary card dashboard showing total sales, average sales per transaction, maximum single sale, and total quantity sold for the last quarter.

Sample Data

Date	Region	Product Category	Sales Amount	Quantity Sold
2024-01-05	North	Electronics	1200	3
2024-01-15	South	Furniture	850	2
2024-02-10	East	Electronics	600	1
2024-02-20	West	Clothing	400	5
2024-03-05	North	Furniture	1500	4
2024-03-15	South	Clothing	300	3
2024-03-25	East	Electronics	700	2
2024-03-30	West	Furniture	950	1

1

Step 1: Connect Tableau to the sales transaction data source containing Date, Region, Product Category, Sales Amount, and Quantity Sold columns.

Use Tableau's data connection wizard to import the data.

Expected Result

Data is loaded and visible in Tableau's data pane.

2

Step 2: Create a filter to include only sales from the last quarter (January to March 2024).

Drag the Date field to Filters, select Range of Dates, and set from 2024-01-01 to 2024-03-31.

Expected Result

Only sales data from the first quarter of 2024 is included.

3

Step 3: Create a calculated field for Total Sales by summing Sales Amount.

Create calculated field named 'Total Sales' with formula: SUM([Sales Amount])

Expected Result

Total Sales calculated as 6000.

4

Step 4: Create a calculated field for Average Sales per Transaction.

Create calculated field named 'Average Sales' with formula: AVG([Sales Amount])

Expected Result

Average Sales calculated as 750.

5

Step 5: Create a calculated field for Maximum Single Sale.

Create calculated field named 'Max Sale' with formula: MAX([Sales Amount])

Expected Result

Maximum Single Sale calculated as 1500.

6

Step 6: Create a calculated field for Total Quantity Sold by summing Quantity Sold.

Create calculated field named 'Total Quantity' with formula: SUM([Quantity Sold])

Expected Result

Total Quantity Sold calculated as 21.

7

Step 7: Build a dashboard with four summary cards showing Total Sales, Average Sales, Max Sale, and Total Quantity.

Use Text objects or KPI cards in Tableau dashboard, each showing one calculated field with clear labels.

Expected Result

Dashboard displays four cards with values: Total Sales = 6000, Average Sales = 750, Max Sale = 1500, Total Quantity = 21.

8

Step 8: Format the dashboard for clarity: use large fonts, contrasting colors, and arrange cards horizontally for easy reading.

Adjust font size to at least 18pt, use dark text on light background, and align cards side by side.

Expected Result

Dashboard is visually clear and easy to read at a glance.

Final Result

---------------------------------------------
| Total Sales   | Average Sales | Max Sale  | Total Quantity |
|   $6,000      |    $750.00    |  $1,500   |      21       |
---------------------------------------------

✓Total sales for the last quarter were $6,000.

✓On average, each sale was $750.

✓The highest single sale was $1,500.

✓A total of 21 items were sold in the quarter.

Bonus Challenge

Add a trend line chart below the summary cards showing total sales by month for the last quarter.

Show Hint

Use the Date field to create a month-level aggregation and plot SUM(Sales Amount) over time.

Practice

1.

What is the main purpose of a statistical summary card in Tableau dashboards?

easy

A. To design interactive maps

B. To display detailed raw data tables

C. To create complex data models

D. To show key numbers clearly and simply

Solution

1. Step 1: Understand the role of summary cards

   Summary cards highlight important numbers like totals or averages for quick insight.

2. Step 2: Compare options with this purpose

   Only To show key numbers clearly and simply matches the purpose of showing key numbers simply and clearly.

3. Final Answer:

   To show key numbers clearly and simply -> Option D

4. Quick Check:

   Summary card = clear key numbers [OK]

Hint: Summary cards highlight main numbers quickly [OK]

Common Mistakes:

• Confusing summary cards with detailed tables
• Thinking summary cards create data models
• Assuming summary cards are for maps

2.

Which of the following is the correct way to create a SUM aggregation for a measure named Sales in Tableau?

easy

A. SUM([Sales])

B. SUM(Sales)

C. SUM{Sales}

D. SUM: Sales

Solution

1. Step 1: Recall Tableau aggregation syntax

   Tableau uses square brackets for field names inside aggregation functions.

2. Step 2: Check each option

   Only SUM([Sales]) uses correct syntax with brackets and parentheses.

3. Final Answer:

   SUM([Sales]) -> Option A

4. Quick Check:

   SUM with brackets = SUM([Sales]) [OK]

Hint: Use square brackets for fields inside functions [OK]

Common Mistakes:

• Omitting square brackets around field names
• Using curly braces instead of parentheses
• Using colon instead of parentheses

3.

Given a dataset with Sales values: 100, 200, 300, what will the AVG([Sales]) aggregation show on a summary card?

medium

A. 600

B. 200

C. 300

D. 100

Solution

1. Step 1: Calculate the average of Sales values

   Sum is 100 + 200 + 300 = 600; count is 3.

2. Step 2: Compute average

   Average = 600 / 3 = 200.

3. Final Answer:

   200 -> Option B

4. Quick Check:

   AVG = sum/count = 200 [OK]

Hint: Average = total sum divided by count [OK]

Common Mistakes:

• Choosing sum instead of average
• Picking a single value instead of average
• Confusing average with maximum

4.

Which of the following formulas will cause an error when used in a Tableau summary card?

IF SUM([Sales]) > 100 THEN 'High' ELSE 'Low' END

medium

A. IF SUM([Sales]) > 100 THEN 'High' ELSE 'Low' END

B. >edoc/edoc<

C. IF SUM([Sales]) > 100 THEN 'High' ELSE 'Low'

D. code>IF SUM([Sales]) > 100 THEN 'High' ELSE 'Low' END

Solution

1. Step 1: Understand Tableau IF statement syntax

   Tableau IF statements must end with END keyword.

2. Step 2: Check each option for missing END

   IF SUM([Sales]) > 100 THEN 'High' ELSE 'Low' is missing END, causing syntax error.

3. Final Answer:

   IF SUM([Sales]) > 100 THEN 'High' ELSE 'Low' -> Option C

4. Quick Check:

   Missing END causes error [OK]

Hint: Always end IF statements with END in Tableau [OK]

Common Mistakes:

• Forgetting END keyword in IF statements
• Using wrong comparison operators
• Misplacing THEN or ELSE keywords

5.

You want to create a summary card showing the COUNT of unique customers who made purchases over $500. Which Tableau calculation should you use?

hard

A. COUNTD(IF [Sales] > 500 THEN [Customer ID] END)

B. COUNT(IF [Sales] > 500 THEN [Customer ID] END)

C. SUM(IF [Sales] > 500 THEN 1 ELSE 0 END)

D. AVG(IF [Sales] > 500 THEN [Customer ID] END)

Solution

1. Step 1: Identify requirement for unique count of customers

   Use COUNTD to count distinct customer IDs.

2. Step 2: Filter customers with sales over $500

   Use IF to include only customers where [Sales] > 500.

3. Step 3: Combine into calculation

   COUNTD(IF [Sales] > 500 THEN [Customer ID] END) counts unique customers meeting condition.

4. Final Answer:

   COUNTD(IF [Sales] > 500 THEN [Customer ID] END) -> Option A

5. Quick Check:

   Unique count with condition = COUNTD(IF...) [OK]

Hint: Use COUNTD with IF for unique conditional counts [OK]

Common Mistakes:

• Using COUNT instead of COUNTD for unique counts
• Using SUM or AVG instead of count functions
• Not filtering with IF condition properly