Why Lineage Matters
A business data answer is only credible if the relevant definition is clear.
Lineage should capture:
- Source tables or files
- Join path
- Calculation
- Filters and time windows
- Known exclusions
- Owner or reviewer when available
Measure Definitions
Define measures and terms for key business concepts such as revenue, churn, cost, margin, pipeline, support urgency, asset usage, and customer status.
Each measure should include:
- Business name
- SQL expression or calculation
- Grain
- Time field
- Approved filters
- Assumptions
Receipt Context
The receipt should reference the definition used for the answer. If the definition is incomplete or inferred, label that limitation clearly.