START WITH A PROBLEM
Every team has its own numbers
Sales and finance bring different totals to the same meeting, and the meeting is spent on which one is right. The numbers are not wrong. The definitions are.
- Salestheir spreadsheet
- "Orders"incl. cancelled
- Financetheir export
- "Orders"invoiced only
- Opstheir report
- "Orders"shipped only
- Indexed dataone copy
- One definition"order" = confirmed, not cancelled
- Shared dashboardsales · finance · ops
The symptom
The monthly review opens with two slides that disagree. Sales has one orders total, finance has another, operations a third, and the first twenty minutes go on reconciling them instead of deciding anything. Each team pulled its own export, in its own tool, at its own time. Each total is correct for what it counted. None of them is the number.
It gets worse between meetings. A manager quotes one figure to a customer, a colleague quotes another to the board, and the organization slowly stops trusting any dashboard it did not build itself.
Why it happens
"Orders" is not one thing. Sales counts confirmed orders including the ones later cancelled, because that is what the pipeline looked like. Finance counts invoiced orders, because that is what the books say. Operations counts shipped orders, because that is what left the warehouse. Add a timing difference - one export at 9am, one at 3pm - and three honest people produce three honest totals.
The deeper cause is that each team is building its own copy of the data. Every spreadsheet is a private index with a private definition, refreshed by hand, shared by email. The disagreement is not a people problem. It is what happens when the definition lives in the export instead of in the data.
What changes with an indexed layer
One indexed copy of the orders, refreshed on a schedule from the system of record, with the definition applied once: an order is confirmed and not cancelled, and the dashboard says so. Every team opens the same dashboard and sees the same count - 952 orders across four regions, North 395 · West 247 · East 168 · South 142 - filtered to their own scope if they need it, but counted the same way. The KPI tiles beside it carry the same definitions: 14 urgent, 36 rejected.
When a team needs a different cut, it is a different widget with a visible label, not a different spreadsheet with a hidden rule. And when someone asks a question the dashboard does not answer, an assistant over the same indexed copy gives an answer that agrees with the dashboard, because it counted the same records. The meeting goes back to being about what to do.