Traditional analysis smears growth proportionally across regions and hides the one that's actually dragging. FactorPrism® finds the right level—what's company-wide vs. what's truly regional—and the drivers tie out to the total exactly.
A retail company's quarterly report showed revenue up 12% year-over-year. The executive team asked the obvious question: "Which regions drove this growth?"
This seems simple, but it's actually a hierarchy problem. Was it a rising tide lifting all boats? Or did specific regions outperform? The answer determines where to invest next quarter.
The finance team did what most companies do: allocate the 12% growth proportionally based on revenue share.
This approach allocates everything at the individual region level, assuming each region contributed proportionally to its size. But growth doesn't work that way. Some of it might be company-wide (affecting all regions equally), and some regions might be outperforming or underperforming that baseline.
By forcing all impact to the region level, traditional analysis can't see either the company-wide trend or the regional deviations from it.
FactorPrism® decomposed the 12% growth into its true hierarchy:
Half the growth (6%) came from a company-wide lift—perhaps market conditions, a successful brand campaign, or seasonal factors affecting everyone equally. This is a segment-wide effect, not a regional one.
The other half came from regional deviations: South and West outperforming that baseline, while Northeast was actually underperforming. Traditional analysis said Northeast contributed +4.2%. Reality: it was dragging by -3.0%, completely hidden by the segment-wide lift.
Add the drivers back up: +6% + 5% + 4% − 3% = your 12%, exactly. Every point of the change is attributed once and reconciles to the total like good accounting—no proportional smearing, no plug. That's how a real −3% drag hides inside a +12% headline until FactorPrism® separates the levels.
With the true hierarchy revealed, leadership made targeted decisions:
Traditional analysis forces all impact to one level (proportional regional allocation). FactorPrism® finds the right level for each effect—separating what's truly company-wide from what's regional outperformance or underperformance. When a struggling region hides behind a rising tide, only proper hierarchy decomposition reveals the truth.
Connect your read-only Snowflake data and get the breakdown on demand—your data never leaves your account.
Get it on Snowflake Marketplace