World's best practice Advanced KPI software

Blog

December 30, 2015

 

When to Use a Pareto Chart

The Pareto Chart is a variation of the bar chart and is very useful for providing insight into key performance indicators (KPIs).  It contains both bars and a line graph — the bars are displayed in descending order while the line represents the cumulative total.  The Y axis of the chart represents the frequency of occurrence while the X axis displays the categories being measured. 

 

The Pareto Chart was designed by Vilfredo Pareto, an Italian engineer who made a number of important contributions to economic theory.  The purpose of the chart is to highlight the most important factors in a data set.  The Pareto Chart is often used to improve quality control and can reduce project complexity by identifying the most important elements within a project. 

 

In a quality control context, these charts are often used to determine where the greatest frequency of product defects are coming from or what is the most common cause of customer complaints.  However, it can be used in many other contexts and is beneficial for tracking various KPIs including sales, customer feedback, productivity levels, search engine optimisation results and much more.

 

It is a very useful chart for KPI tracking software because it allows a user to easily understand the individual total of specific groups and the impact of those groups upon the overall total.  Pareto charts are also useful for answering questions like “Where is most of our revenue coming from?” because the user simply follows the cumulative total line to find the answer.

 

The Seven Basic Tools of Quality

The Pareto Chart is one of the tools included in the Seven Basic Tools of Quality.  The tools are graphical techniques that are useful for troubleshooting issues relating to quality.  A number of these tools are particularly useful for displaying key performance indicators on performance dashboards.  They include:

 

•        Pareto chart

•        Cause-and-effect diagram (Ishikawa diagram)

•        Check sheet

•        Control chart

•        Histogram

•        Scatter diagram

•        Stratification (flow chart or run chart)

 

The Project Management Institute references these tools as an important set of instruments for ensuring project quality.  The benefit of these graphical techniques is that they are capable of displaying complex statistics while remaining easy to understand and comprehensible for people without formal training in statistics.

 

Using a Pareto Chart

The process for creating a Pareto Chart is quite simple.  For example, if you were constructing a chart to represent customer complaints.

 

1.     Select the categories you would like to group the items into
What are people complaining about?  Slow delivery time, packaging issues, product quality, broken product, wrong product

2.     Determine the appropriate measurement for what you wish to communicate
What are you trying to convey with this graph?  Number of complaints per category, the cost of each complaint, the number of calls for each complaint type, time spent dealing with the complaint?

3.     Decide what period the chart covers
A financial quarter, a week, a year?

4.     Collect the data and format into bar chart and add cumulative total line
Most KPI Management Software will format the data for you

5.     Determine the appropriate scale for the chart
You may have some display options to make the graph easier to understand.

 

In this situation, the chart will help the user understand where most complaints are coming from and what proportion multiple types of complaints make up.  When there are many categories, it helps users immediately understand the overall significance of each group.

 

It is also possible to use stacked bar charts to further increase the information conveyed by a Pareto Chart. In the customer complaints example, you could also include geographical locations so a user understands where each type of complaint is primarily coming from.  They may realise that complaints about slow delivery speed come from a particular region.

 

Pareto Charts are available for the performance dashboards of most KPI tracking software packages.  The insight they can provide makes them a very useful too

Leave a Comment

Please enter the letters as they are shown in the image above.

-Letters are not case-sensitive.

 

Stop wasting time and money on issues that don't matter. Align manage

Enjoy Multiple Users With A Single Login

Start Your FREE Trial Now

With Your 30-Day Free Trial

 
CrowdReviews.com Logo
The crowd rates us 5.0 out of 5.0

Read all 3 Reviews / Write A Review