February 2019
Beginner to intermediate
442 pages
9h 38m
English
A Pareto analysis helps us to identify which groups of customers contribute to the first 80% of our sales. To create a Pareto analysis, we will use a combo chart.
The combo chart allows us to combine metrics with different shapes as bars, lines, and symbols. We will represent the data in two axes; the primary axis is found at the left-hand side of the chart, and the secondary axis is found at the right-hand side of the chart.
In our example, the chart has a bar for Sales $ in the primary axis, as well as two lines: one for the Cumulative % of sales, and the other as static, with 80% in the secondary axis.
In the following screenshot, you can see the highlighted customers contributing to ...