Pareto principle, developed by Vilfredo Pareto says - "80 percent of the losses come from 20 percent of the causes". Usually, Pareto principle or the 80/20 rule is applied on the significant few vs the trivial many. Graphically, a Pareto diagram simply displays a bar chart distribution of a metric by a dimension sorted in descending order of the value, overlaid with a line chart plotting the growing cumulative percentage. It helps to identify the significant few. Pareto chart can help in identifying top performers for a metric and their overall contribution across the categories.
This blog entry describes how to use the Pareto Custom Viz plugin for Oracle Analytics. That Custom Viz plugin can be downloaded for free from the Oracle Analytics Library. This brief video describes how to use this plugin within OAC :
Pareto Chart requires two mandatory input parameters : a Category dimension (X) and a Values object (Y axis). Color is an optional parameter. Values(Y-Axis) accepts a single measure. Category(X-Axis) accepts one or more attributes.
The plugin automatically sorts the metric value in descending order, by dimension members, and plots it as a bar chart for each member. The metric value is computed as a cumulative percentage and plotted as a line chart. The axis of cumulative percentage is placed on the right hand side. Here's an example of a pareto depicting Sales by City:
Adding a color parameter changes the bar chart to a stacked bar chart with each bar divided into different color categories. However, the line chart is not altered.
As you hover over the bars, you see a tool-tip with X-Axis and Y-Axis values. When you hover the mouse on the line chart, along with the tool-tip, you see two dotted lines each pointing towards X-Axis and Cumulative %. These lines are helpful in dividing the category with Cumulative %. You can see the stacked bar and the dividing lines in the pic below.
Pareto Chart Plugin can plot negative values as well. Here's an example of a Profit metric with positive and negative values.
The plugin also supports typical DV mouse right-click interactions like Keep/Remove Selected, Use as Filter, Brushing and so on.
Hope this write-up was informative! Thanks for reading.
This blog entry describes how to use the Pareto Custom Viz plugin for Oracle Analytics. That Custom Viz plugin can be downloaded for free from the Oracle Analytics Library. This brief video describes how to use this plugin within OAC :
Using the Pareto Custom Viz Plugin
Pareto Chart requires two mandatory input parameters : a Category dimension (X) and a Values object (Y axis). Color is an optional parameter. Values(Y-Axis) accepts a single measure. Category(X-Axis) accepts one or more attributes.
The plugin automatically sorts the metric value in descending order, by dimension members, and plots it as a bar chart for each member. The metric value is computed as a cumulative percentage and plotted as a line chart. The axis of cumulative percentage is placed on the right hand side. Here's an example of a pareto depicting Sales by City:
Adding a color parameter changes the bar chart to a stacked bar chart with each bar divided into different color categories. However, the line chart is not altered.
As you hover over the bars, you see a tool-tip with X-Axis and Y-Axis values. When you hover the mouse on the line chart, along with the tool-tip, you see two dotted lines each pointing towards X-Axis and Cumulative %. These lines are helpful in dividing the category with Cumulative %. You can see the stacked bar and the dividing lines in the pic below.
Pareto Chart Plugin can plot negative values as well. Here's an example of a Profit metric with positive and negative values.
The plugin also supports typical DV mouse right-click interactions like Keep/Remove Selected, Use as Filter, Brushing and so on.
Hope this write-up was informative! Thanks for reading.
Are you an Oracle Analytics customer
or user?
We want to hear your story!
Please voice your experience and provide feedback
with a quick product review for Oracle Analytics Cloud!
No comments:
Post a Comment