Data Core · Data Governance · Module

Definitions and lineage

What each term means, where the figure comes from, and what happens to it on the way — the record that makes two reports reconcilable.

The idea

How it works

Two reports disagreeing about the same figure is a definition problem or a lineage problem, and without a record of either it is settled by whoever argues longest.

Lineage matters as much as definition. The same definition applied to data that was filtered differently upstream produces different answers, and the difference is invisible in the report.

Working with it

In practice

  1. 01

    Maintain one definition set

    Terms defined once, referenced everywhere. Local definitions are how the argument starts.

  2. 02

    Record the path from source to report

    What is joined, filtered and transformed. This is where most discrepancies actually originate.

  3. 03

    Make definition changes an event

    With a version, a date and a note about where the trend breaks.

  4. 04

    Name who decides a definition

    One person per term, or the definition set becomes a negotiation.

One level in

The components of definitions and lineage

A component is something that exists afterwards which did not exist before — a deliverable or a mechanism, not an intention.

  1. The definition set

    What each term means, held in one place.

    Learn
  2. The lineage

    The path from source to report, including transformations.

    Learn
  3. The change process

    How a definition is altered, and who decides.

    Learn

Most reporting discrepancies are lineage problems rather than definition problems, and lineage is rarely recorded.