---
title: Waterfall Analysis and Pareto Analysis – Price Analytics that Drive Decision Making
description: Waterfall Analysis and Pareto Analysis – Price Analytics that Drive Decision Making
---
[](https://www.holdenadvisors.com/)
- About
- [Overview](https://www.holdenadvisors.com/about/overview/)
- [Core Values](https://www.holdenadvisors.com/about/core-values/)
- [Leadership](https://www.holdenadvisors.com/about/leadership/)
- [Partners](https://www.holdenadvisors.com/about/partners/)
- [Careers](https://www.holdenadvisors.com/about/careers/)
- [Solutions](https://www.holdenadvisors.com/about/overview/#)
- [Sales](https://www.holdenadvisors.com/about/overview/#)
- [Overview](https://go.holdenadvisors.com/solutions/sales/improve-sales-performance)
- [Negotiating With Backbone](https://www.holdenadvisors.com/solutions/sales/negotiating-with-backbone/)
- [Selling With Backbone](https://www.holdenadvisors.com/solutions/sales/selling-with-backbone/)
- [Coaching](https://www.holdenadvisors.com/solutions/sales/coaching/)
- [Pricing](https://www.holdenadvisors.com/about/overview/#)
- [Overview](https://go.holdenadvisors.com/solutions/improve-pricing-performance)
- [Audit](https://www.holdenadvisors.com/solutions/pricing/audit/)
- [Analytics](https://www.holdenadvisors.com/solutions/pricing/analytics/)
- [Value-Based Pricing](https://www.holdenadvisors.com/solutions/pricing/value-based-pricing/)
- [Insights](https://www.holdenadvisors.com/about/overview/#)
- [Blog](https://www.holdenadvisors.com/blog/)
- [Video Series](https://www.holdenadvisors.com/about/overview/#)
- [Pricing with Confidence](https://go.holdenadvisors.com/pricing-with-confidence)
- [Publications](https://www.holdenadvisors.com/about/overview/#)
- [Books](https://www.holdenadvisors.com/insights/publications/books/)
- [White Papers](https://www.holdenadvisors.com/papers)
- [Newsletter](https://blog.holdenadvisors.com/tag/newsletter)
- [Case Studies](https://www.holdenadvisors.com/studies)
- [Events, Webinars & Podcasts](https://www.holdenadvisors.com/insights/events-webinars-podcasts/)
- [Reed’s Bookshelf](https://www.holdenadvisors.com/bookshelf)
- [Contact](https://www.holdenadvisors.com/contact-us/)
- About
- [Overview](https://www.holdenadvisors.com/about/overview/)
- [Core Values](https://www.holdenadvisors.com/about/core-values/)
- [Leadership](https://www.holdenadvisors.com/about/leadership/)
- [Partners](https://www.holdenadvisors.com/about/partners/)
- [Careers](https://www.holdenadvisors.com/about/careers/)
- [Solutions](https://www.holdenadvisors.com/about/overview/#)
- [Sales](https://www.holdenadvisors.com/about/overview/#)
- [Overview](https://go.holdenadvisors.com/solutions/sales/improve-sales-performance)
- [Negotiating With Backbone](https://www.holdenadvisors.com/solutions/sales/negotiating-with-backbone/)
- [Selling With Backbone](https://www.holdenadvisors.com/solutions/sales/selling-with-backbone/)
- [Coaching](https://www.holdenadvisors.com/solutions/sales/coaching/)
- [Pricing](https://www.holdenadvisors.com/about/overview/#)
- [Overview](https://go.holdenadvisors.com/solutions/improve-pricing-performance)
- [Audit](https://www.holdenadvisors.com/solutions/pricing/audit/)
- [Analytics](https://www.holdenadvisors.com/solutions/pricing/analytics/)
- [Value-Based Pricing](https://www.holdenadvisors.com/solutions/pricing/value-based-pricing/)
- [Insights](https://www.holdenadvisors.com/about/overview/#)
- [Blog](https://www.holdenadvisors.com/blog/)
- [Video Series](https://www.holdenadvisors.com/about/overview/#)
- [Pricing with Confidence](https://go.holdenadvisors.com/pricing-with-confidence)
- [Publications](https://www.holdenadvisors.com/about/overview/#)
- [Books](https://www.holdenadvisors.com/insights/publications/books/)
- [White Papers](https://www.holdenadvisors.com/papers)
- [Newsletter](https://blog.holdenadvisors.com/tag/newsletter)
- [Case Studies](https://www.holdenadvisors.com/studies)
- [Events, Webinars & Podcasts](https://www.holdenadvisors.com/insights/events-webinars-podcasts/)
- [Reed’s Bookshelf](https://www.holdenadvisors.com/bookshelf)
- [Contact](https://www.holdenadvisors.com/contact-us/)
# Holden Advisors Blog
# Waterfall Analysis and Pareto Analysis – Price Analytics that Drive Decision Making
Posted by [Mayuresh Saravanakumar](https://blog.holdenadvisors.com/author/mayuresh-saravanakumar) on Jan 21, 2017 7:00:41 AM
Find me on:
[LinkedIn](https://www.linkedin.com/in/smayuresh/)
- [Tweet](https://twitter.com/share)
In the previous three articles in the series [*What* *Gets Measured Gets Done*](http://www.holdenadvisors.com/what-gets-measured-gets-done/), we discussed some basic reporting that every pricing and/or sales operations team should use to drive improved profits for the business. In this last article of the series, we are going to talk about uncovering the drivers of discounting and the effectiveness of an organization's profit improvement initiatives using a combination of waterfall analysis and Pareto analysis.
Once we understand the overall trend of the company using the price plot ([*Discounting Control Tool of Choice – The Price Plot*](http://www.holdenadvisors.com/discounting-control-tool-of-choice-the-price-plot/)), and the high-level pricing and revenue trends using the dashboards ([*Pricing and Revenue Dashboards: Keys to Profit* *Improvement*](http://www.holdenadvisors.com/pricing-revenue-dashboards-keys-to-profit-improvement/)), the next step is understanding at a high level where discounting is occurring and compare it to best practices. Waterfall analysis and Pareto analysis are great tools to uncover why and where discounting is occurring and where to focus an organization’s limited resources.
We will be using the familiar tool – waterfall analysis, but in a different tact to understand how discounting has changed in a year and what were the contributors to the net change. An example of a waterfall analysis is shown below. The X axis is the customer category and the Y axis is the revenue lost.
The graph depicts revenue lost due to discounting went from $612K to $378K (which is a good thing!). In this case, revenue improved by $365K due toimproved discounting controls in 123 customers. Unfortunately, at the same time, discounting increased with 56 customers leading to an increase in revenue lost $126K for that customer set. Also, we see that with new customers discounting is leading to a revenue loss of $7K. The waterfall analysis shows how effective our discounting controls have been, whether they had an impact a specific set of customers or in a channel, and how our discounting habits may continue in some areas of the business – like the acquisition of a new customer in this example.
Next, to understand which customers contribute to revenue lost due to discounting, we do a Pareto analysis. A Pareto analysis for the customers whose discounting has increased is shown below
The above analysis shows that the top 10 customers (20%) from customer A to customer H, contributed to 80% of the increase in discounting. The Pareto principle, which states that 20% of your customers cause 80% of revenue lost, is the truth in most of the cases. This means we can focus our attention on a limited set of customers to investigate root cause and make specific account plans with sales to address the discounting.
The combination of waterfall analysis and Pareto analysis can uncover a wealth of information. Major insights include:
1. Understanding the change in the discounting trend
2. Uncovering best practices inside the sales organization to share with others in the team (By performing Pareto analysis on customers whose discounting decreased)
3. Measuring pricing and profit improvement initiatives
4. Highlighting the top customers where focus in required to improve account profitability
Clearly there are many, many other tools available to analyze pricing and profitability. It can be overwhelming. Start small and simple. Get your arms around the highlevel of discounting controls, and over time, add more analytics to gain more and more insights. The key is to *get started *in measuring. What gets measured, gets done.
Topics: [Pricing with Confidence](https://blog.holdenadvisors.com/tag/pricing-with-confidence)
### **Search the Holden Advisors Blog:**
This is a search field with an auto-suggest feature attached.
- There are no suggestions because the search field is empty.
### Subscribe Below:
### Recent Posts
### Posts by Tag
- [Pricing with Confidence (68)](https://blog.holdenadvisors.com/tag/pricing-with-confidence)
- [Negotiating with Backbone (63)](https://blog.holdenadvisors.com/tag/negotiating-with-backbone)
- [Selling with Confidence (43)](https://blog.holdenadvisors.com/tag/selling-with-confidence)
- [Newsletter (41)](https://blog.holdenadvisors.com/tag/newsletter)
- [Uncovering your Value (26)](https://blog.holdenadvisors.com/tag/uncovering-your-value)
- [Celebrating 10 Years of Pricing with Confidence (12)](https://blog.holdenadvisors.com/tag/celebrating-10-years-of-pricing-with-confidence)
- [value selling (9)](https://blog.holdenadvisors.com/tag/value-selling)
- [Selling with Backbone (8)](https://blog.holdenadvisors.com/tag/selling-with-backbone)
- [value (8)](https://blog.holdenadvisors.com/tag/value)
- [pricing (6)](https://blog.holdenadvisors.com/tag/pricing)
- [Commercial Transformation (5)](https://blog.holdenadvisors.com/tag/commercial-transformation)
- [Setting Price (4)](https://blog.holdenadvisors.com/tag/setting-price)
- [customer experience (4)](https://blog.holdenadvisors.com/tag/customer-experience)
- [actionable insights (3)](https://blog.holdenadvisors.com/tag/actionable-insights)
- [procurement (3)](https://blog.holdenadvisors.com/tag/procurement)
- [sales (3)](https://blog.holdenadvisors.com/tag/sales)
- [Pricing Strategy (2)](https://blog.holdenadvisors.com/tag/pricing-strategy)
- [big data (2)](https://blog.holdenadvisors.com/tag/big-data)
- [buying center (2)](https://blog.holdenadvisors.com/tag/buying-center)
- [customer loyalty (2)](https://blog.holdenadvisors.com/tag/customer-loyalty)
- [pricing metrics (2)](https://blog.holdenadvisors.com/tag/pricing-metrics)
- [winning proposal (2)](https://blog.holdenadvisors.com/tag/winning-proposal)
- [Driving Accountability (1)](https://blog.holdenadvisors.com/tag/driving-accountability)
- [Silos (1)](https://blog.holdenadvisors.com/tag/silos)
- [b2b pricing (1)](https://blog.holdenadvisors.com/tag/b2b-pricing)
- [bundling (1)](https://blog.holdenadvisors.com/tag/bundling)
- [gatekeeper (1)](https://blog.holdenadvisors.com/tag/gatekeeper)
- [jump the shark (1)](https://blog.holdenadvisors.com/tag/jump-the-shark)
- [on demand (1)](https://blog.holdenadvisors.com/tag/on-demand)
- [peloton (1)](https://blog.holdenadvisors.com/tag/peloton)
- [pricing models (1)](https://blog.holdenadvisors.com/tag/pricing-models)
- [product portfolio (1)](https://blog.holdenadvisors.com/tag/product-portfolio)
- [rabbit (1)](https://blog.holdenadvisors.com/tag/rabbit)
- [revenue (1)](https://blog.holdenadvisors.com/tag/revenue)
- [rolling stone (1)](https://blog.holdenadvisors.com/tag/rolling-stone)
- [subscription (1)](https://blog.holdenadvisors.com/tag/subscription)
- [tidying up (1)](https://blog.holdenadvisors.com/tag/tidying-up)
See all
### Newsletter and Blog
### About Us
Holden Advisors are experts in the pricing and sales performance development space. We help our clients take control of their differential value and use it to transform their business.
## [Learn More](https://www.holdenadvisors.com/negotiation-value-pricing-consultants/)
- Quick Links
- [Contact](https://www.holdenadvisors.com/contact-us/)
- [About](https://www.holdenadvisors.com/about/overview/)
- [Blog](https://www.holdenadvisors.com/blog/)
- [Books](https://www.holdenadvisors.com/insights/publications/books/)
- [Case Studies](https://www.holdenadvisors.com/studies)
- [Negotiating With Backbone](https://www.holdenadvisors.com/solutions/sales/negotiating-with-backbone/)
- [Value-Based Pricing](https://www.holdenadvisors.com/solutions/pricing/value-based-pricing/)
- [Privacy Policy](https://www.holdenadvisors.com/privacy-policy/)
- [Home](https://www.holdenadvisors.com/)
Copyright © 2018 Holden Advisors. All Rights Reserved.