Pie charts in Tableau - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants to understand the sales distribution by product category for the last quarter. They asked you to create a pie chart to visualize the proportion of total sales each category contributes.

📊 Data: You have sales data with columns: Order ID, Product Category, Sales Amount, and Order Date. The data covers multiple product categories and sales transactions over several months.

🎯 Deliverable: Create a pie chart in Tableau showing the percentage of total sales for each product category for the last quarter.

Sample Data

Order ID	Product Category	Sales Amount	Order Date
1001	Electronics	1200	2024-01-15
1002	Furniture	850	2024-01-20
1003	Clothing	400	2024-02-05
1004	Electronics	700	2024-02-18
1005	Clothing	600	2024-03-10
1006	Furniture	950	2024-03-15
1007	Electronics	1300	2024-03-20
1008	Clothing	300	2024-03-25

1

Step 1: Connect your Tableau workbook to the sales data source containing Order ID, Product Category, Sales Amount, and Order Date.

No formula needed; just connect the data source.

Expected Result

Data source is connected and visible in Tableau.

2

Step 2: Filter the data to include only sales from the last quarter (January 1, 2024 to March 31, 2024).

Create a filter on Order Date: Order Date >= '2024-01-01' AND Order Date <= '2024-03-31'.

Expected Result

Only sales records from the first quarter of 2024 are included.

3

Step 3: Create a new worksheet for the pie chart.

No formula; just open a new worksheet.

Expected Result

A blank worksheet is ready for building the pie chart.

4

Step 4: Drag 'Product Category' to the Color shelf to assign different colors to each category.

Drag 'Product Category' dimension to Color on Marks card.

Expected Result

Marks card colors are assigned by product category.

5

Step 5: Drag 'Sales Amount' to Angle on the Marks card to size slices by sales.

Drag 'Sales Amount' measure to Angle on Marks card.

Expected Result

Pie slices are sized proportionally to sales amount.

6

Step 6: Change the Marks type from Automatic to Pie.

Select Pie from the Marks type dropdown.

Expected Result

The chart changes to a pie chart.

7

Step 7: Drag 'Sales Amount' to Label on the Marks card to show sales values on slices.

Drag 'Sales Amount' to Label.

Expected Result

Sales amounts appear as labels on each pie slice.

8

Step 8: Right-click the Sales Amount label, select 'Format', and set number format to Currency with no decimals.

Format labels as currency, e.g., $1,200.

Expected Result

Sales labels display as currency values without decimals.

9

Step 9: Add a title to the worksheet: 'Sales Distribution by Product Category - Q1 2024'.

Use the worksheet title option to add the text.

Expected Result

The chart has a clear, descriptive title.

10

Step 10: Adjust colors if needed for better contrast and accessibility.

Use Color legend to pick distinct, colorblind-friendly colors.

Expected Result

Pie chart colors are distinct and easy to differentiate.

Final Result

Pie Chart: Sales Distribution by Product Category - Q1 2024

  Electronics  ██████████████  $3,200
  Furniture    █████████      $1,800
  Clothing     ██████         $1,300

(Each slice sized by sales amount, colored by category, with labels showing sales in dollars.)

✓Electronics is the largest contributor to sales with $3,200 in Q1 2024.

✓Furniture sales are the second largest at $1,800.

✓Clothing sales are the smallest among the three categories at $1,300.

✓The pie chart clearly shows the proportion of sales each category contributes.

Bonus Challenge

Create a dashboard that includes this pie chart alongside a bar chart showing monthly sales trends for each product category in Q1 2024.

Show Hint

Use a filter for Q1 2024 on both charts and synchronize colors for categories to make the dashboard cohesive.

Practice

1. What is the main purpose of a pie chart in Tableau?

easy

A. To display trends over time

B. To show parts of a whole using slices

C. To compare two numerical variables

D. To list detailed data records

Solution

1. Step 1: Understand pie chart basics

   A pie chart divides a circle into slices representing parts of a whole.

2. Step 2: Identify correct visualization purpose

   Pie charts are not for trends, comparisons, or detailed lists but for showing proportions.

3. Final Answer:

   To show parts of a whole using slices -> Option B

4. Quick Check:

   Pie chart = parts of whole [OK]

Hint: Pie charts always show parts of a whole [OK]

Common Mistakes:

• Confusing pie charts with line charts
• Using pie charts for detailed data
• Thinking pie charts show trends

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

easy

A. Drag a dimension to Filters and a measure to Tooltip

B. Drag a dimension to Columns and a measure to Rows, then select Bar chart

C. Drag two measures to Rows and Columns, then select Line chart

D. Drag a measure to Rows and a dimension to Color, then select Pie chart

Solution

1. Step 1: Identify pie chart creation steps

   In Tableau, to create a pie chart, you drag a measure to Rows and a dimension to Color.

2. Step 2: Confirm chart type selection

   After placing fields, you select the Pie chart type from the Show Me panel.

3. Final Answer:

   Drag a measure to Rows and a dimension to Color, then select Pie chart -> Option D

4. Quick Check:

   Measure + dimension + Pie chart = correct [OK]

Hint: Measure controls size, dimension controls slices [OK]

Common Mistakes:

• Choosing Bar or Line chart instead of Pie
• Swapping dimension and measure roles
• Not selecting Pie chart type

3. Given a pie chart with 'Category' as dimension and 'Sales' as measure, what will happen if you add 'Region' to Color instead of 'Category'?

medium

A. The pie slices will represent sales by Region instead of Category

B. The pie chart will show total sales without slices

C. The chart will become a bar chart automatically

D. Tableau will show an error and not create the chart

Solution

1. Step 1: Understand dimension role in pie charts

   The dimension assigned to Color defines the slices of the pie chart.

2. Step 2: Effect of changing dimension to 'Region'

   Replacing 'Category' with 'Region' changes slices to represent sales by Region.

3. Final Answer:

   The pie slices will represent sales by Region instead of Category -> Option A

4. Quick Check:

   Dimension on Color = slice categories [OK]

Hint: Color dimension controls pie slices [OK]

Common Mistakes:

• Thinking slices disappear without Category
• Assuming chart type changes automatically
• Expecting an error from changing dimension

4. You created a pie chart but all slices appear the same size despite different sales values. What is the most likely cause?

medium

A. You forgot to add a dimension to Color

B. You selected the wrong chart type

C. You used a dimension instead of a measure for slice size

D. Your data source has no sales values

Solution

1. Step 1: Check what controls slice size

   Slice size in pie charts depends on a measure, like Sales, not a dimension.

2. Step 2: Identify cause of equal slice sizes

   If a dimension is used for size, Tableau treats all slices equally, causing same size slices.

3. Final Answer:

   You used a dimension instead of a measure for slice size -> Option C

4. Quick Check:

   Measure controls size, dimension controls slices [OK]

Hint: Use measure for size, dimension for slices [OK]

Common Mistakes:

• Using dimension for slice size
• Not assigning any dimension to Color
• Assuming chart type is wrong

5. You want to create a pie chart showing sales distribution by product category but your data has 20 categories. What is the best practice to improve the pie chart's readability?

hard

A. Group smaller categories into an 'Others' slice and limit colors

B. Use all 20 categories with different bright colors

C. Remove the dimension and show total sales only

D. Switch to a line chart to show all categories

Solution

1. Step 1: Understand pie chart readability limits

   Pie charts work best with few slices; too many slices clutter the chart.

2. Step 2: Apply grouping for clarity

   Grouping small categories into 'Others' reduces slice count and improves clarity.

3. Step 3: Limit colors for clear distinction

   Using fewer distinct colors helps viewers easily differentiate slices.

4. Final Answer:

   Group smaller categories into an 'Others' slice and limit colors -> Option A

5. Quick Check:

   Few slices + clear colors = better pie chart [OK]

Hint: Group small slices to keep pie clear [OK]

Common Mistakes:

• Using too many slices with many colors
• Removing dimension loses slice info
• Switching to wrong chart type