cancel
Showing results for 
Search instead for 
Did you mean: 
Community_Admin
Community Team Member
Community Team Member

Analytical Need 

Pareto analysis is a technique based on the Pareto Principle which states that 80 percent of problems or effects are produced by 20 percent of causes. This type of analysis can be useful in the stage of decision making, to identify the root causes (or attributes) of the problem you are trying to address.

Modeling Challenge

How can we identify the customers that are responsible for 80% of total sales?

We can answer this business question flexibly in the dashboard.

Solution

To answer this question we will need to use a column chart with the relevant category we would like to analyze (customers) and add more values (running contribution and sales ) to it, to better visualize the answer to our question.

Community_Admin_2-1634210146655.png

Next, add the calculation of the value that needs to be measured. We will use total sales for this scenario:

Community_Admin_3-1634210146760.png

Our next step will be to add a value which will contain the running contribution of the total sales formula we previously created, wrapped by a running sum function, to sum up the percentage of sales per customer:

Community_Admin_4-1634210146661.png

Finally, we add a value line to represent the 80%:

Community_Admin_5-1634210146674.png

Our final result will present a column chart of total sales by customer, along with a running sum and 80% values to visualize the Pareto analysis. This enables us to quickly identify the point where the contribution and running sum values overlap, to create the 80%:

Community_Admin_6-1634210146796.png

 

Version history
Last update:
‎10-14-2021 04:16 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Need additional support?:

Community Support Request