What is a Pareto chart?
Do you often wonder why only certain actions produce the majority of results? Or perhaps you struggle to identify the key areas that could significantly improve your company's efficiency? In this article, we will explore how the Pareto principle can help solve these problems, boosting the productivity and effectiveness of your business activities. Discover the methods and techniques that can transform your approach to time and resource management.
The Pareto Principle – what is it?
80/20 rule examples
How to apply the Pareto chart in practice?
How to create a Pareto chart?
Benefits of using the Pareto chart
The Pareto Principle – what is it?
A Pareto chart is a tool that enables the visualization and analysis of data. It was originally developed by Italian economist Vilfredo Pareto, with the aim of demonstrating that the majority of results in any given phenomenon stem from a small percentage of causes. Pareto observed that 80% of the wealth in Italy was held by 20% of the population. From this observation, a general principle was developed stating that in many phenomena, approximately 80% of effects come from 20% of causes. This is why the Pareto principle is also known as the 80/20 rule.
The Pareto chart, based on this principle, helps companies focus on the factors that have the greatest impact, leading to effective resource and time management.
This chart presents data in the form of bars arranged in descending order, allowing for the quick identification of the most important sources of problems.
Pareto's law has many applications, from quality management to process optimization. Using this principle makes it easier to focus on key areas, which is especially important in dynamic market conditions.
The Pareto method is widely used in management and business because it allows organizations to focus on the actions that yield the greatest results. This approach also finds application in problem-solving.
To better understand how this principle works in real life, here are a few examples:
Business and sales – In most companies, it is observed that 80% of revenue is generated by 20% of customers. Focusing on these key customers can bring about a significant increase in income.
Time management – Approximately 80% of work results often stem from 20% of the effort and time invested. It is worth identifying these key activities and concentrating your efforts on them in order to increase productivity.
Project management – In project management, 80% of problems and delays often arise from 20% of causes. By identifying these critical issues, you can effectively manage the project and minimize risk.
Software development – In programming and software development, 80% of bugs and defects may result from 20% of the code. Finding and fixing these critical sections can significantly improve the stability and quality of the product.
Logistics – In logistics and supply chain management, 80% of warehouse inventory often takes up 20% of available storage space. Optimizing the placement of these key products can improve operational efficiency and minimize costs.
Content marketing – In content marketing, the 80/20 rule can be observed in driving traffic to a website. Typically, 80% of a site's visitors come from 20% of published content. It is worth identifying those key articles, blog posts, or videos that generate the most traffic, in order to focus efforts on creating similar content.
Customer service – In most companies, 80% of complaints and returns come from 20% of customers. By analyzing these key complaints, companies can implement improvements that significantly enhance customer satisfaction and reduce the number of reported issues.
Education and learning – In science and education, 80% of students' knowledge or skills often comes from 20% of the time spent studying. By identifying the key methods and topics that yield the greatest results, teachers and students can increase the effectiveness of the learning process.
IT security – In IT security management, 80% of threats arise from 20% of security vulnerabilities. Focusing on identifying and fixing these critical vulnerabilities can significantly improve overall system security and minimize the risk of attacks.
As you might expect, these examples can be multiplied and applied to virtually every area of life. Since the Pareto principle is so relevant and present across all industries, it is worth exploring its use in business.
We have prepared a sample approach for implementing the Pareto chart, illustrated using the example of a manufacturing company.
Step 1: Identify the problem
First, you need to identify the area in which you want to apply the Pareto chart. For example, in a manufacturing company, this might be a desire to reduce product defects.
Step 2: Collect data
Begin by gathering data on the problems you want to analyze. For example, record the number of product defects occurring in the factory over the course of a month.
Step 3: Categorize the problems
Divide the collected data into categories. These could be various causes of defects, such as "improper materials," "operator errors," or "machine problems."
Step 4: Calculate frequency
- Count how many times each problem occurred during the given period. For example: – Improper materials: 40 cases – Operator errors: 30 cases – Machine problems: 20 cases – Other: 10 cases.
Step 5: Sort data in descending order
Arrange your categories from the most to the least frequently occurring problems. This will help identify the most important areas requiring immediate intervention.
Step 6: Calculate the cumulative percentage
Calculate what percentage of all problems each category accounts for, then compute the cumulative percentage. For example: – Improper materials: 40% (40 cases) – Operator errors: 70% (40 + 30 cases) – Machine problems: 90% (40 + 30 + 20 cases) – Other: 100% (40 + 30 + 20 + 10 cases)
Step 7: Create the Pareto chart
Place the problem categories on the horizontal axis and the number of cases on the vertical axis. Use bars to represent the frequency of each problem. Additionally, draw a cumulative percentage line starting from the point of the cumulative percentage.
Step 8: Analyze and take action
Analyze the chart to identify the key areas for improvement. For example, if "improper materials" and "operator errors" have the greatest impact on product quality, accounting for approximately 70% of all defects, then by focusing on these two categories, the company can effectively reduce the majority of defects and improve production quality.
To squeeze every last drop of value from this topic, let us look at an additional example of how the use of a Pareto chart might play out.
An electronics manufacturer wants to reduce the number of defective components in its devices. Applying the Pareto chart revealed that 40% of defects resulted from improper materials, 30% from operator errors, 20% from machine problems, and 10% from other causes. After creating the chart, the company focused on material suppliers and operator training, which led to significant reductions in defects and an improvement in product quality.
Using the Pareto chart helps companies better understand which problems are the most costly and require the most urgent intervention, and to plan improvement actions in those areas.
To provide a clearer illustration of the Pareto chart in practice, we would like to present an example of the Pareto chart applied to a summary of reported bugs in the Wizjer application.
We have already walked through the stages of creating a Pareto chart together, but we also want to satisfy your curiosity and answer the question: "Can I create such a chart in Excel?"
The answer is: YES!
Excel is a tool that is perfectly suited for creating Pareto charts. Its versatility and accessibility make it an ideal solution for many companies that want to implement Pareto principles in their processes without the need to invest in specialized software.
So how do you create a Pareto chart in Excel?
It is simpler than it might seem. All you need to do is collect data on the problems or factors you want to analyze, then create a table with the values. The next step is to sort the data from the largest to the smallest value and calculate the cumulative percentage of each value. Once these steps are complete, you can proceed to create the chart using Excel's graphing functions. It is also worth noting that there are many ready-made templates and tutorials available online that can make creating a Pareto chart in Excel easier. This means that even those who are not proficient in the program can take advantage of its capabilities.
Of course, beyond Excel, other programs can also be used to create a Pareto chart.
Google Sheets – Google Sheets offers many functions similar to those available in Excel. To create a Pareto chart: 1. Enter your data into the spreadsheet and sort it from the largest to the smallest value.
-
Calculate the cumulative percentage values for each category.
-
Select the data and insert a bar chart.
-
Add a line chart to represent the cumulative percentage values.
-
The combination of these two charts will create a Pareto chart.
Tableau – Tableau is an advanced data visualization tool. Creating a Pareto chart in Tableau involves several steps: 1. Import your data into Tableau.
-
Create a calculated field that computes the cumulative percentage.
-
Use the "Dual-axis" option to create a combo chart with bars and a line.
-
Adjust the labels and axes to obtain a clear Pareto chart.
QlikView – QlikView is another tool for advanced data analysis. To create a Pareto chart: 1. Load your data into QlikView.
-
Use the "Aggr" function to group data and calculate cumulative percentages.
-
Create a bar chart for the base data and a line chart for the cumulative percentages.
-
Combine both charts to obtain a complete Pareto chart.
Each of these tools has its own unique features and may be more suitable depending on the nature of the data and the user's level of expertise. The choice of the right tool depends on your needs and resources.
Using the Pareto chart in small and medium-sized enterprises brings many benefits that can significantly improve management and efficiency.
What are these benefits?
Focusing on key problems – the Pareto chart enables companies to identify those specific 20% of causes that generate 80% of problems. This allows the business to concentrate on resolving the most important issues, leading to the rapid achievement of significant results. This approach minimizes the waste of time and resources on less critical problems.
Increasing operational efficiency – by identifying the most significant problems, the Pareto chart helps optimize business processes. Improving key areas of operations leads to increased overall operational efficiency, which translates into better performance and higher quality products or services offered by the company.
Cost reduction – the Pareto chart allows efforts to be focused on eliminating the main sources of problems, which can lead to significant financial savings. Eliminating or minimizing key problems reduces operational costs, as well as the risk of costly errors and failures.
Facilitating decision-making processes – with clearly presented data and priorities, the Pareto chart supports managers in making more informed and accurate decisions. The easy-to-interpret analysis helps to more quickly understand what needs to be focused on, which is especially important given the limited resources available to SMEs.
Improving quality and customer satisfaction – focusing on key problems allows SMEs to more effectively address issues affecting the quality of products or services and customer satisfaction. This enables companies not only to improve their offerings, but also to build customer loyalty and trust, which translates into long-term growth and business stability.
Using the Pareto chart in SMEs brings numerous benefits, from operational optimization to quality improvement and cost reduction. This tool can be key to the success and growth of small and medium-sized enterprises, enabling them to manage resources and processes more effectively.
