Data lineage
Data lineage is the documented path a piece of data takes from where it is first recorded, through each step of copying or calculation, to the report where it is used.
What it means
When a profit figure looks wrong, lineage lets you trace it back: the report, the sheet it came from, the formula, and the source entry. For a small business, lineage can be a note stating which register feeds which sheet and who updates it.
Example
A factory's monthly rejection figure of 4.8 percent comes from a summary sheet. The sheet adds three shift registers, each filled by a supervisor from inspection slips. When the owner questions the number, the team traces it to slips and finds one shift counted twice.
Records and checks
- Record the source of each report figure, each transfer step, the formula and the person responsible.
- Verify lineage by tracing a sample figure back to the original document.
- The report owner keeps the map, and the finance head reviews it when a report format changes.
Common mistakes
- Pasting values from sheet to sheet with no note on where they came from.
- Changing a formula without recording when and why, so earlier reports cannot be explained.
Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →