Author Archives: Ian Diakov- Iasta

How to Accomplish a Pareto Analysis in Microsoft Excel

When examining spend, the most effective way to start is at the top. This method will expose categories with the most savings opportunity because more savings are reaped from higher spend. A lot of corporate spend falls into only a select few categories. For example, a company may have 80% of its spend going to Financial Services, IT, and Published Products. A good spend analysis product should display a Pareto Analysis within each category in its reporting suite. From there, … More