Guided Notes
Data Quality & Validation
The dimensions of data quality, automated checks in SQL (completeness, validity, uniqueness, timeliness, consistency), reconciliation to source systems and documenting data issues.
Data quality dimensions
Slide 1 / 5| Dimension | Question | Example check |
|---|---|---|
| Completeness | Is required data present? | % encounters missing a discharge date |
| Validity | Are values allowed and plausible? | Ages 0–120; valid ICD-10 format |
| Uniqueness | Are there duplicates? | Encounter IDs appearing twice |
| Consistency | Do related fields agree? | Discharge after admit; sex-specific codes |
| Timeliness | Is data current? | Last load date = yesterday |
| Accuracy | Does it match reality? | Chart audit sample |