Skills / Run It in Production / Data quality & trust
4P Data Quality

Data Quality Triage

Routes every defect to one of four actions, Purge, Pass, Push Back or Patch, each with an owner, and measures the programme honestly.

Book a working session

Private skill · shared by invitation · How access works

Illustrative output of Data Quality Triage: Routes every defect to one of four actions, Purge, Pass, Push Back or Patch, each with an owner, and measures the programme honestly.
Illustrative output with sample data.
The challenge

Five years of fixing, and the source system is still wrong.

One verb: fix

Everything gets patched downstream, forever, by people who didn't create it.

Unowned defects

Nobody can name the source-system owner.

“Zero defects” tolerances

Targets nobody can measure or meet.

Automation hides the problem

Easier patching pushes the programme the wrong way.

How it works

From first question to finished output.

Set the bar

What decision the data feeds, who owns the source, what tolerance applies.

Route every defect

Four questions in order, first yes wins: Purge, Pass, Push Back or Patch.

Measure the Patch Ratio

The one number that shows whether you are fixing causes or symptoms.

Assess the programme

Ten questions scored 1–5, and the binding constraint.

What you get

  • Routed defect list with owners and expiry dates
  • The Patch Ratio: the one number that tells the truth about a quality programme
  • 10-dimension programme assessment and the binding constraint

What goes in

Profiling output or a defect list. Business tolerance per critical element.

Time to answer

As a consulting engagement10 weeks3 people · 30 consultant-weeks
Running the skill30 minutesTriage mode · 2–3 hours to Design

What it still needs from you

The Push Back conversation. No tool has ever made a source owner accept a defect.

Also in Run It in Production
Data quality & trustData Lineage & Audit EvidenceChange & deliveryData Migration & CutoverChange & deliveryTest Data Management

See where this fits in the sequence →

See Data Quality Triage in action.

Thirty minutes with Harveer, on your own data problem.

Book a working session