Poor data quality and sampling bias
Technology and data Before 16 After 6Missing values, duplicates, wrong units and samples that do not represent the group being studied produce results that look precise but describe the wrong thing.
Who or what is affected: Analysts, decision makers and customers
Causes
Data collected for another purpose, manual entry and samples chosen for convenience.
Consequences
Wrong conclusions, wasted effort and decisions that harm the people the data describes.
Existing controls
- Basic checks for blanks and duplicates run on each load.
- The analyst notes where the data came from.
Control gaps
Quality checks stop at format and do not test whether the sample is representative.
Additional controls
- Prevent: Define data quality rules for completeness, range and format and check them automatically on every load.
- Detect: Compare the sample with the wider group and record any gap before results are shared.