Learn
What is Data Lineage?
The ability to trace any number on a dashboard or report all the way back to its original source – knowing exactly where it came from, what changed it, and when.
What it is
Data lineage is the audit trail for your data. It answers questions like: "Where did this revenue number come from? Which system? Which calculation? Who changed the formula last quarter?" Think of it like the traceability system in food manufacturing. When a product is recalled, the manufacturer can trace every ingredient back to the farm, the batch, and the delivery date. Data lineage does the same for your business numbers – every metric can be traced back through transformations to its raw source. Without lineage, when the CFO asks "why does this number look wrong?" the answer is usually "let me dig into that and get back to you in a few days."
Why it matters for your business
Trust in data comes from transparency. When your board questions a revenue figure, being able to show exactly where it came from – "this pulls from Xero invoice data, filtered by settlement date, converted at the month-end exchange rate" – builds confidence. When you cannot do that, people fall back to spreadsheets they built themselves. A mid-market financial services firm we worked with spent $45,000 on a regulatory response because they could not demonstrate how their reported figures were calculated. After implementing lineage tracking, the same type of query takes 15 minutes to answer with a complete audit trail.
How we approach it
We use tools like dbt that automatically generate lineage graphs – visual maps showing how data flows from source tables through transformations to final business metrics. Every transformation is documented with its business logic, so anyone can follow the chain from dashboard to source. We also set up impact analysis: before changing a calculation, you can see exactly which reports and dashboards are affected, preventing surprises.
Related Services
Key Takeaways
- •Lineage lets you trace any number from a dashboard back to its raw source – building trust and speeding up investigations.
- •Without lineage, "why does this number look wrong?" becomes a multi-day investigation instead of a 15-minute lookup.
- •Regulatory and audit requirements increasingly demand demonstrable data provenance – lineage is not optional for regulated industries.
- •Modern tools like dbt generate lineage graphs automatically as part of your data transformation workflow.