Wednesday, March 20, 2013

Pareto Chart with PowerPivot

A Pareto Chart can be a powerful visualization to help you apply the 80/20 rule.  This viz focuses attention on the ~20% of the universe (customers, products, etc.) that often contributes 80% of the desired outcomes (sales, conversions, etc.).  Allowing you to focus your efforts on the ones that deliver the most important results (the items that are even with and to the left of where the running total crosses the target 80%).

Building a viz like this is insanely easy in Excel with PowerPivot.  Especially in Excel2013.