Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Pareto Analysis

Avatar

Avatar
Boost 3
Employee
marisab86593973
Employee

Likes

3 likes

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Boost 3
Boost 1
View profile

Avatar
Boost 3
Employee
marisab86593973
Employee

Likes

3 likes

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Boost 3
Boost 1
View profile
marisab86593973
Employee

02-06-2016

Hi there

 

I was working with Adobe Analytics Workspace and wanted to create a pareto analysis for a customer. The business question was, which top-products generate more than 80% of total revenue.

When I tried to build this Report, I used the advanced function "cumulative" for calculated metrics. But the result was not what I expected, because it summarizes the values of the revenue in a random order. Also there is no visualisation of the data that combines a line (for the cumulative % of total revenue) and a bar graph  (for the revenue of each product) and actually perhaps also a manually settable line (see red lines in the picture), so the user can set the line for example at 80% and knows which products generate more than 80% of the revenue or to set the line after the first x products and sees then how many of the revenue these products generate. 

 

Screen Shot 2016-06-03 at 09.52.06.png

 

There are also a lot of other questions that could be answered with a pareto analysis: 

- which customers / browsers / regions generate 80% of revenue? 

- which errors cause 80% of problems? 

 

Thank you for considering this. 

Marisa

1 Comment

Avatar

Avatar
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile

Avatar
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile
benjamingaines2
Level 8

07-06-2016

Very interesting idea, and I can honestly say this isn't something we have heard before. Definitely worth considering as a new visualization type.