HomeAboutProjectsHow I workContact

Document

So nobody has to ask me.

What comes in
OTIF 92.4%

A bare number on the dashboard.

  • On time according to whom?
  • By line or by order?
  • Who owns it?
What goes out
OTIF %Metric card
  • On timethe customer gets it, in full
  • Grainone order, not one line
  • Owneroperations manager
Example figures

What isn’t written down gets asked. Or AI makes it up.

Five things. Not everything.

The OTIF card, field by field.

OTIF %Metric card
  1. 1DefinitionOrders received on time and in full ÷ orders delivered.
  2. 2FormulaDIVIDE ( [OTIF orders], [Orders delivered] )
  3. 3GrainOne order, not one line: by line it gave 96.0%.
  4. 4OwnerOperations manager · checked every Monday.
  5. 5Source and freshnessfct_despachos in BigQuery · daily load.
I don’t document

The obvious: “a warehouse is a warehouse”.

What changes every week.

I do document

What someone would ask.

Next to the data, not in a separate document.

Written once, it travels.

1dbtschema.yml
columns:
  - name: otif
    description:
Order received on time and in full.
2BigQueryfct_despachos
otif · BOOL
description:
Order received on time and in full.
3Power BImeasure
/// Order received on time and in full.
measure 'OTIF %' =
  DIVIDE ( … )

A separate document, OTIF_definition_final.docx: nobody opens it, and it goes stale.

AI drafts. I check it against the source.

Without a description

What’s OTIF?

94.1%It used Logistics’ definition.
With the description

What’s OTIF?

92.4%Same as the dashboard.
  1. 1AI drafts
  2. 2I check the data note
  3. 3I test three questions

The full card, with its history.

OTIF %Metric card
Definition
Orders received on time and in full ÷ orders delivered.
Formula
DIVIDE ( [OTIF orders], [Orders delivered] )
Grain
One order, not one line: by line it gave 96.0%.
Filters
The 3 warehouses · no transport costs.
Owner
Operations manager · every Monday · target 94%.
Source and freshness
fct_despachos in BigQuery · daily load.
Changelogdate · what · who
  1. wk 40Customer definition wins: 92.4%, not 94.1%.Operations manager
  2. wk 41Grain: order, not line.Diego
  3. wk 42Card published in dbt, BigQuery and Power BI.Diego
Example figures

Done when nobody has to ask me.

  • What’s OTIF?

    →

    OTIF %on time, in full ÷ delivered

    Someone new answers what OTIF is, alone.

  • Dashboard92.4%

    =

    AI92.4%

    AI gives the same answer as the dashboard.

  • wk 40manager

    wk 41Diego

    wk 42Diego

    Every change has a date and an owner.

That closes the case: see it applied in a project.← CommunicateProjects →