The revenue bridge that ties out to the dollar.
Every quarter someone builds the bridge by hand: a waterfall from last period's revenue to this period's, with a bar for every explanation. FactorPrism® builds it automatically, inside Snowflake — and every bar is found by the engine, with the bars always summing to exactly the change.
Ready for your own data? Install from Snowflake Marketplace
"Revenue is up 8%. The board wants the bridge."
The question sounds simple and never is. Growth could be a broad-based lift across the whole business, one region's pricing action, a channel mix shift — or all three overlapping. The bridge has to allocate the 8% among causes, and defend every bar.
The problemHand-built bridges allocate. They don't locate.
The standard approach: pick a few suspects, compute each one's delta, allocate the remainder to "mix/other." Three failure modes:
The bars overlap
Region deltas and product deltas double-count the same dollars; the bridge only "ties" because someone forced a plug.
Broad-based forces get smeared
A market-wide lift shows up as small positives in every region row, so the bridge says "everything grew a little" when the true story is one force acting everywhere.
It takes days
And next quarter it's days again.
Causes, located and reconciled
Grant read-only access to your revenue table, pick the period, and the engine searches every level of your hierarchy — total, region, product line, individual segment — for the places where causes actually act.
Broad-based factors reported once, at the top
A force lifting the whole business isn't smeared across every region row.
Localized factors pinned to the segment where they live
"Step change in Northeast Outerwear beginning March 12" — with its exact contribution.
The waterfall reconciles exactly
Factors sum to exactly the change — zero unexplained residual, no fudge factor.
Market-wide vs yours, on every result
Each analysis splits what's broad-based from what's specific to a segment — what to ride vs what to act on — with plain-language narrative via Snowflake Cortex.
What about price-volume-mix?
PVM, generalized
Price-volume-mix analysis splits a revenue change into price, volume, and mix effects between two snapshots. FactorPrism® answers the question PVM is usually reaching for — where is the change coming from and why — across every dimension you track, not just price and volume, and across the full shape of the period, not just two endpoints. If you track price and volume as separate metrics, analyze each: you get a located, reconciled bridge for both.
Related: Budget vs actual · Margin bridge · Churn & net-adds movement · vs Snowflake's built-in functions
Bring the number your team is still debating.
We will walk through one real question with you, on a sample or a source you choose.