The Purpose of Data Cleaning and Preparation

The unmodified export or file received from the source system.

Identifying, investigating, documenting, and resolving data quality issues.

Structuring, transforming, and documenting data so it can be reviewed, reported, analyzed, archived, or shared.

A listing of records that need site, investigator, monitor, or data manager review.

The ability to connect outputs back to raw inputs, scripts, rules, and decisions.