"?אם אתה לא יודע לאן אתה הולך, איך תדע שהגעת"
רובין שארמה, מחבר הספר הנזיר שמכר את הפרארי שלו
The ultimate Pareto analysis utility within Excel
The Pareto principle (also known as the 80–20 rule, the law of the vital few, and the principle of factor scarcity) states that, for many events, roughly 80% of the effects come from 20% of the causes.
Therefore, many businesses have easy access to dramatic improvements in profitability by focusing on the most effective areas and eliminating, ignoring, automating, delegating, or retraining the rest, as appropriate.
What makes Pareto-Ultimate© apart is that it works directly on the raw database and not like some other add-ons, on summarized data. As it focuses on Pareto and is not a marginal feature of some more sophisticated software, It takes the 20/80 analysis to a completely new level.
It features a wealth of features, some of them proprietary ones such as the Pareto Strength Index© which indicates at a glance the degree to which the data fit the Pareto paradigm.
Makes the analysis directly from the raw database which may consist of thousands of observations
Can breakdown the analysis by a secondary variable with a complete drill-down capability
May refer to a 3rd continuous variable to make the analysis refer to the sum or other stats, rather than the number of occurrences
Performs a full ABC analysis
Features a very powerful crosstabulation module making it even more potent than Excel Pivot table
Enables complete control of the categories to include in the analysis
Allows to export the analysis to Excel both in tabular and graphical format
The analysis may be performed on a subset of the whole data