한국어

Chapter 4: Data Quality and Validation

Ensuring Accuracy, Completeness, and Reliability of Research Datasets

4.1 The Importance of Data Quality

Data quality determines whether research conclusions are trustworthy and findings reproducible. Poor quality data leads to incorrect conclusions, wasted resources, failed replication, and potentially harmful clinical decisions. In medical research, data quality is not merely a technical concern—it is an ethical imperative.

Quality assurance must be built into every stage of research, from study design through data collection, processing, and analysis. Detecting and correcting quality issues early prevents propagation of errors and reduces remediation costs.

27%
Datasets Have Quality Issues
$3.1T
Annual Cost of Poor Data
10x
Cost to Fix Post-Entry
30%
Analysis Time on Cleaning

4.2 Data Quality Dimensions

Data quality is multidimensional. Each dimension addresses a different aspect of fitness for use:

Core Quality Dimensions

Dimension Definition Measurement
Accuracy Data correctly represents real-world values Error rates, validation against gold standard
Completeness Required data elements are present Missing value percentages
Consistency Data values are coherent across dataset Logical checks, cross-field validation
Timeliness Data is current and available when needed Data age, update frequency
Validity Data conforms to defined formats and rules Format compliance, range checks
Uniqueness No unintended duplicates Duplicate detection rates

Fitness for Purpose

Data quality is relative to intended use. Data adequate for exploratory analysis may be insufficient for regulatory submission. A population health study tolerates missing data that would invalidate a pharmacokinetic model. Define quality requirements based on how data will be used, and document quality limitations for secondary users.

4.3 Quality Assurance During Collection

Preventing errors is more efficient than correcting them:

Collection Quality Controls

Validation Rule Types

Rule Type Description Example
Range Check Value within expected bounds Age between 0-120 years
Format Check Data matches expected pattern Date as YYYY-MM-DD
Cross-Field Logical relationship between fields Death date after birth date
Referential Foreign key exists Patient ID in patient table
Pattern Match Regular expression validation Email format, phone number

4.4 Data Cleaning and Transformation

Post-collection data processing must maintain data integrity while improving quality:

Cleaning Procedures

⚠️ Preserve Original Data

Never modify source data. Create a separate cleaned version while preserving the original. Document all transformations applied, including the rationale for each decision. This provenance trail enables verification, allows alternative cleaning approaches, and ensures transparency about data modifications.

4.5 Data Validation Frameworks

Systematic validation ensures consistency across the data lifecycle:

Framework Application Features
Great Expectations Data pipelines Expectation suites, data docs
CDISC Conformance Clinical trial data Pinnacle 21, OpenCDISC
Pandas Profiling Exploratory analysis Automated quality reports
OHDSI DQD OMOP databases Data quality dashboard

4.6 Quality Metrics and Reporting

Measuring and communicating quality enables improvement and appropriate data use:

Quality Indicators

Quality Reporting

Generate quality reports at key milestones: after data collection closes, before analysis begins, and with final dataset release. Reports should document quality dimensions assessed, metrics achieved, issues identified, and actions taken. Make quality reports available to data users as part of metadata.

4.7 Reproducible Data Processing

Data processing must be reproducible for validation and replication:

Reproducibility Requirements

✓ Data Quality Best Practices

Define quality requirements based on data use before collection begins; implement validation rules in data capture systems; use standardized instruments and trained collectors; preserve original data and document all transformations; assess multiple quality dimensions (accuracy, completeness, consistency); generate quality metrics and include reports with shared data; and make data processing pipelines reproducible through code and documentation.

📌 Key Takeaways

📝 Review Questions

  1. What are the six core dimensions of data quality and how is each measured?
  2. Why is "fitness for purpose" an important concept in data quality assessment?
  3. What quality controls should be implemented during data collection?
  4. Describe different types of validation rules with examples from medical research.
  5. Why is it important to preserve original data during cleaning? What should be documented?
  6. How should data quality be measured and reported to enable appropriate data use?

📐 시뮬레이터 패널 3