Data Cleaning Exercises

Guide · updated 2026-11-04

Writing a data quality report

Structure and wording for a report that stakeholders read and act on.

Lead with the impact

Start with what the issues mean for the numbers people use, then the details.

Quantify everything

Counts and shares per issue, examples, and who can fix each one.

  • Reconciliation table
  • Exceptions by reason
  • Assumptions
  • Open questions and owners

Recommend fixes

Name two or three source changes that would remove most exceptions.

Practise it