Financial & Valuation

De-averaging

Quick Definition

De-averaging refers to the practice of breaking down aggregate data into more granular segments to uncover hidden insights, disparities, and strategic opportunities. It is a foundational analytical technique used by consultants and strategists to look beneath surface-level metrics.

The Core Concept

De-averaging as a formal strategic concept was popularized by management consulting firms, particularly McKinsey & Company, during the 1980s and 1990s. The core insight is deceptively simple: averages lie. When data is aggregated across products, customers, geographies, or time periods, the resulting averages can mask dramatic differences that have profound strategic implications. A business that appears moderately profitable on average may actually consist of a highly profitable core subsidizing a deeply unprofitable periphery. Without de-averaging, management makes decisions based on a misleading composite picture.

The strategic power of de-averaging lies in its ability to redirect resources toward their highest-value uses. One of the most common applications is customer profitability analysis. Research by Bain & Company and others has consistently shown that in most businesses, the top 20% of customers generate 150-300% of total profits, while the bottom 20% actually destroy value. This pattern, far more extreme than the simple Pareto principle suggests, only becomes visible when you de-average customer-level data. Without this granularity, companies invest equally in all customers, over-serving unprofitable ones and under-serving their most valuable accounts.

McKinsey's work on corporate portfolio strategy provides a powerful example of de-averaging at scale. In their research on thousands of companies, McKinsey consultants found that the average large corporation's overall return on invested capital masked enormous variation across business units. Some units generated returns far above the cost of capital while others destroyed value for years. The insight was that capital allocation based on aggregate corporate performance led to systematic misallocation, with profitable units starved of investment while underperforming units received ongoing funding based on historical allocations rather than forward-looking returns.

In retail, Walmart's success has been partly attributed to its sophisticated de-averaging of store-level and product-level data. Rather than managing categories based on chain-wide averages, Walmart analyzes performance at the individual store level, adjusting assortment, pricing, and inventory to local demand patterns. This granular approach, enabled by its pioneering investment in data systems starting in the 1980s, allowed Walmart to outperform competitors who managed their businesses based on regional or national averages.

Practitioners should apply de-averaging across multiple dimensions simultaneously for maximum insight. A product that appears average in profitability might be highly profitable in one region and deeply unprofitable in another. A customer segment that appears average in retention might contain one cohort with 95% retention and another with 50%. The key is to disaggregate along the dimensions most relevant to strategic decision-making: customer segments, product lines, geographies, channels, and time periods. The more granular the analysis, the more actionable the insights, though diminishing returns eventually set in as data becomes too sparse for reliable conclusions.

Key Distinctions

De-averaging

Benchmarking

De-averaging disaggregates a company's own data to find internal variation and hidden insights, while benchmarking compares a company's performance against external peers or industry standards. De-averaging reveals what is happening within your business; benchmarking reveals how you compare to others.

📌

Classic Example McKinsey & Company

McKinsey's research on corporate capital allocation found that large companies' aggregate return on invested capital masked enormous variation across business units. Many corporations were systematically misallocating capital by using blended corporate averages rather than unit-level returns.

Outcome: Companies that adopted de-averaged capital allocation, redirecting investment from low-return to high-return units, achieved significantly higher total shareholder returns over subsequent five-year periods.

📌

Modern Application Walmart

Walmart de-averages performance data at the individual store and product level rather than managing categories based on chain-wide averages. Its data systems, pioneered since the 1980s with technologies like the Retail Link platform, enable granular local optimization.

Outcome: Store-level assortment and pricing optimization has been a key driver of Walmart's ability to outperform competitors in same-store sales and inventory turnover across its 4,700+ U.S. locations.

💡

Did You Know?

Research by Bain & Company found that in many B2B companies, the top 20% of customers generate 150-300% of total profits, while the bottom 20% actually destroy 50-200% of that value. The middle 60% roughly break even. This extreme dispersion is invisible in averaged customer data.

🔎

Strategic Insight

The most powerful de-averaging reveals cross-subsidization: where profitable segments are unknowingly subsidizing unprofitable ones. This creates a strategic vulnerability because a focused competitor can target your profitable segments with better offerings while you remain burdened by the unprofitable segments you do not realize are dragging you down.

Strategic Implications

Do

  • De-average across multiple dimensions simultaneously: customer, product, geography, and channel
  • Look specifically for cross-subsidization where profitable segments mask unprofitable ones
  • Use de-averaged data to drive resource allocation, pricing, and investment decisions
  • Start with the Pareto principle as a hypothesis and then test whether the actual distribution is even more skewed

Don't

  • Don't make strategic decisions based on averaged data without checking for underlying variation
  • Don't de-average to such a granular level that sample sizes become too small for reliable conclusions
  • Don't assume that aggregate trends apply uniformly to all sub-segments
  • Don't present de-averaged findings without also communicating the strategic implications and recommended actions

Frequently Asked Questions

Sources & Further Reading

  • Chris Bradley, Martin Hirt, and Sven Smit (2018). Strategy Beyond the Hockey Stick: People, Probabilities, and Big Moves to Beat the Odds. John Wiley & Sons.
  • Michael J. Mauboussin (2012). The Success Equation: Untangling Skill and Luck in Business, Sports, and Investing. Harvard Business Review Press.

Apply De-averaging in practice

Generate a professional strategy deck that incorporates this concept — in under a minute.

Create Your Deck