Pareto analysis in Tableau - Step-by-Step Guide

Introduction

Pareto analysis helps you find the most important factors in your data. It shows which few items cause most of the effect, like 20% of products making 80% of sales. This helps focus on what matters most.

When you want to see which products bring most of your sales revenue.

When you need to identify the few customers who generate most of your profit.

When you want to find the main causes of defects in a manufacturing process.

When you want to prioritize issues that have the biggest impact on your business.

When you want to show a clear visual of the 80/20 rule in your data.

Steps

Step 1: Connect

- Tableau Data Source pane

Your data loads and appears in the Data pane on the left side.

Step 2: Drag

- Dimension (e.g., Product) to Rows shelf

Rows show each product listed vertically.

Step 3: Drag

- Measure (e.g., Sales) to Columns shelf

A bar chart appears showing sales by product.

Step 4: Sort

- Right-click the Product field on Rows shelf → Sort

Products reorder from highest to lowest sales.

Step 5: Create

- Calculated Field named 'Running Total' with formula: RUNNING_SUM(SUM([Sales]))

A new field calculates cumulative sales.

Step 6: Create

- Calculated Field named 'Percent of Total' with formula: [Running Total] / TOTAL(SUM([Sales]))

A new field calculates cumulative percent of total sales.

Step 7: Drag

- 'Percent of Total' to Columns shelf next to Sales

A dual-axis chart appears showing sales and cumulative percent.

Step 8: Right-click

- Second axis (Percent of Total) → Dual Axis

Both charts overlay on the same axis.

Step 9: Synchronize

- Right-click second axis → Synchronize Axis

Both axes align for easy comparison.

Step 10: Change

- Marks card for Percent of Total → Change mark type to Line

A line shows cumulative percent over bars.

Step 11: Add

- Reference Line on Percent of Total axis at 0.8 (80%)

A line appears showing the 80% cumulative sales point.

Before vs After

Before

Bar chart shows sales by product in no particular order, no cumulative percent line.

After

Bar chart sorted by sales descending with a line showing cumulative percent of total sales and a reference line at 80%.

Settings Reference

Sort Order

📍 Right-click Dimension on Rows shelf → Sort

To order items from highest to lowest sales for Pareto analysis.

Default: Manual

Dual Axis

📍 Right-click second measure axis → Dual Axis

To overlay sales bars and cumulative percent line on the same chart.

Default: Single Axis

Synchronize Axis

📍 Right-click second axis → Synchronize Axis

To align scales of sales and percent for accurate visual comparison.

Default: Do not synchronize

Reference Line

📍 Analytics pane → Drag Reference Line to Percent of Total axis

To mark key thresholds like 80% cumulative sales.

Default: None

Common Mistakes

Not sorting the dimension by sales before creating running total.

Running total will not accumulate correctly if items are unordered, breaking the Pareto principle visualization.

Always sort the dimension descending by sales before calculating running total.

Not synchronizing axes after creating dual axis.

Axes scales differ, making the cumulative percent line misleading or hard to read.

Right-click the second axis and choose Synchronize Axis for proper alignment.

Summary

Pareto analysis in Tableau shows which few items contribute most to a total.

Sort your data descending by measure before calculating running totals.

Use dual axis and synchronize axes to combine bars and cumulative percent line.

Practice

1. What is the main purpose of Pareto analysis in Tableau?

easy

A. To identify the few key items that cause most of the effect

B. To create detailed pie charts for all categories

C. To calculate averages of all data points

D. To filter out all data except the top item

Solution

1. Step 1: Understand Pareto analysis concept

   Pareto analysis focuses on the vital few items that contribute most to an outcome, often called the 80/20 rule.

2. Step 2: Relate to Tableau usage

   In Tableau, Pareto analysis helps highlight these key items by sorting and showing cumulative impact visually.

3. Final Answer:

   To identify the few key items that cause most of the effect -> Option A

4. Quick Check:

   Pareto analysis = Identify key items [OK]

Hint: Remember 80/20 rule means few items cause most effect [OK]

Common Mistakes:

• Thinking it calculates averages
• Assuming it filters to only one item
• Confusing it with pie chart creation

2. Which Tableau calculation is essential to create a Pareto chart showing cumulative impact?

easy

A. RANK(SUM([Quantity]))

B. SUM([Sales]) / COUNT([Orders])

C. AVG([Profit])

D. RUNNING_SUM(SUM([Sales]))

Solution

1. Step 1: Identify calculation for running total

   RUNNING_SUM(SUM([Sales])) computes a running total across sorted data, key for cumulative impact.

2. Step 2: Compare other options

   Other options calculate averages, ranks, or ratios, not cumulative sums needed for Pareto.

3. Final Answer:

   RUNNING_SUM(SUM([Sales])) -> Option D

4. Quick Check:

   Running total = RUNNING_SUM(SUM([Sales])) [OK]

Hint: Use RUNNING_SUM for running totals in Tableau [OK]

Common Mistakes:

• Using AVG instead of running sum
• Confusing rank with cumulative sum
• Dividing sums incorrectly

3. Given this Tableau calculation for cumulative percentage:
RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales]))
What is the output for the first sorted item with Sales = 100 and total Sales = 500?

medium

A. 100

B. 0.2

C. 1.0

D. 0.5

Solution

1. Step 1: Calculate running sum for first item

   Running sum for first item is SUM([Sales]) = 100.

2. Step 2: Calculate total sum and divide

   Total sum is 500, so cumulative percentage = 100 / 500 = 0.2 (20%).

3. Final Answer:

   0.2 -> Option B

4. Quick Check:

   100/500 = 0.2 [OK]

Hint: Divide running sum by total sum for cumulative percent [OK]

Common Mistakes:

• Using total sum as numerator
• Confusing running sum with total sum
• Not converting to percentage

4. You created a Pareto chart but the cumulative percentage line is not showing correctly. Which fix is most likely needed?

medium

A. Remove sorting on the dimension and use default order

B. Replace RUNNING_SUM with SUM([Sales]) only

C. Change calculation to use RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales])) and set table calculation to compute along sorted dimension

D. Use AVG([Sales]) instead of SUM([Sales]) in calculation

Solution

1. Step 1: Identify correct cumulative percentage formula

   RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales])) is the correct formula for cumulative percent.

2. Step 2: Ensure table calculation computes along sorted dimension

   Sorting is essential so running sum accumulates in correct order; setting compute using sorted dimension fixes line.

3. Final Answer:

   Change calculation to use RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales])) and set table calculation to compute along sorted dimension -> Option C

4. Quick Check:

   Correct formula + sorting = proper Pareto line [OK]

Hint: Always set table calc direction along sorted dimension [OK]

Common Mistakes:

• Using SUM instead of RUNNING_SUM
• Ignoring sorting order
• Using average instead of sum

5. You want to create a Pareto chart in Tableau showing top products contributing to 80% of sales. Which steps should you follow?

hard

A. Sort products by sales descending, calculate running sum of sales, compute cumulative percent, then combine bar and line charts

B. Filter top 80% products by sales, then create a pie chart of sales

C. Calculate average sales per product and highlight those above average

D. Sort products alphabetically, then plot sales as bars without cumulative calculations

Solution

1. Step 1: Sort products by descending sales

   Sorting ensures the largest contributors appear first for cumulative calculation.

2. Step 2: Calculate running sum and cumulative percent

   Use RUNNING_SUM(SUM([Sales])) and divide by TOTAL(SUM([Sales])) to get cumulative percent.

3. Step 3: Combine bar chart for sales and line chart for cumulative percent

   This visual combination clearly shows which products contribute to 80% of sales.

4. Final Answer:

   Sort products by sales descending, calculate running sum of sales, compute cumulative percent, then combine bar and line charts -> Option A

5. Quick Check:

   Sort + running sum + combo chart = Pareto analysis [OK]

Hint: Sort descending, running sum, cumulative %, then combo chart [OK]

Common Mistakes:

• Filtering before calculating cumulative percent
• Using average instead of cumulative sum
• Not combining bar and line charts