Data Cleaning Exercises

Glossary

Reconciliation

Checking that clean + quarantined (+ filtered) rows equal the input rows.

Reconciliation catches lost and duplicated rows. After a pivot or aggregation the grain changes, so reconcile totals instead of row counts.

Related: Quarantine, Row grain