Overview / Method

The method, written down

Five steps that make the work traceable. At each step you know what we need, what we produce and what you are asked to confirm.

StepWhat we need from youWhat we doWhat you see
1. ScopeThe question, the decision it supports, the files involved and a named contactWrite a one-page scope with what is in and outScope note to approve
2. ProfileA minimised extract with unneeded columns removedMeasure types, gaps, formats and duplicatesProfile summary and first questions
3. Agree rulesAnswers about meaning: what a blank is, which name is canonicalDraft rules with worked examplesRule list to approve line by line
4. ProcessNothing, unless an exception needs your judgementApply rules, record counts, set aside failuresPrepared data, change log, exceptions
5. Read togetherThirty to sixty minutes of attentionPresent outputs and the interpretation noteAgreed reading and next actions

Principles that do not move

Minimise first

We ask for the smallest extract that answers the question. If a name or address is not needed to match records, it should not be in the file.

Never change silently

Every rule is agreed and logged. The original file is kept unchanged so any result can be reproduced from it.

Report counts, always

Rows in, rows out, rows set aside. If the numbers do not reconcile, the run is not finished.

Say what the data cannot do

A note that lists its own limits is more useful than one that sounds confident.

Hand over properly

Run notes are written for the next person, so the process does not depend on any one individual, including us.