A number that looks simple almost never is.

Reports and systems lose trust when they disagree about the same number. I enforced the rules and made them visible.

Average

Averaged across what? dayweekmonth
Can two stores be added up?

order

Does an exchange make a second one?
Does a zero dollar order count?
Does a discounted order count?

value

Do returns come out of this?
Which register sent it?

avg_order_value = revenue_taken / orders_paid

The five data sets the company runs on.

Each one has its own vocabulary.

Hover any definition. Click to pin it open.

And each one arrives from more than one place.

Define the rules and pipeline, then make it visible.

The Data Warehouse

Sales Labor Traffic Reviews Inventory

The Metrics Registry.

Anyone can open it and see how a number is made.

Open a row. That is the definition every other tool is required to use.

This is an executable contract that every dashboard, query and system reads from. Anyone can audit it here. If it's in the data warehouse, it's here.

All shown