Traditional reports show categories and regions separately and leave you guessing where the growth came from. FactorPrism® finds the right level—including the one specific intersection that mattered—and the drivers tie out to the total exactly.
Q2 sales came in 18% above Q1. The leadership team needed to understand why before planning Q3 inventory and marketing. Was it a specific product category? Certain regions? Or something more specific?
This is a hierarchy problem across multiple dimensions. The answer might be at the category level, the region level, or—crucially—at the intersection of both.
The team pulled their standard BI reports, which showed each dimension separately:
These reports show impact at the category level and the region level separately. But what if the real driver is at the intersection level—a specific category in a specific region?
Looking at these reports, a reasonable conclusion would be "Jewelry is hot—invest in Jewelry company-wide" or "The South is strong—expand in the South across all categories." Both conclusions allocate to a single dimension, potentially missing the real story.
FactorPrism® analyzed all hierarchy levels simultaneously and found the simplest explanation:
The biggest driver wasn't "Jewelry" (category level) or "South" (region level)—it was "South + Jewelry" specifically (intersection level). This single combination drove 9% of the 18% total growth.
Meanwhile, West's growth was truly broad-based (correctly attributed at region level), and there was a segment-wide baseline lift (correctly attributed at company-wide level). Each effect is attributed to its correct level in the hierarchy.
Add the drivers back up: +9% + 5% + 5% − 1% = your 18%, exactly. Every point of the change is accounted for, once—like good accounting, not a pile of percentages that don't reconcile. And notice the −1%: FactorPrism® surfaces what's declining (Northeast + Apparel) right beside what's growing, so offsetting stories never hide.
With the true hierarchy revealed, the team made targeted decisions:
Traditional BI shows dimensions separately—category growth and regional growth as independent reports. FactorPrism® considers all hierarchy levels simultaneously: company-wide, category-specific, region-specific, and intersection-specific. It finds the simplest explanation, attributing each effect to its correct level. When the real driver is an intersection, only multi-dimensional hierarchy analysis reveals it.
Connect your Snowflake data and see which combinations are driving your business.
Get it on Snowflake Marketplace