The Purpose of Data Cleaning and Preparation

Data preparation is broader than error correction. It includes the work required to make data usable for review, reporting, monitoring, analysis, archiving, and sharing. A raw REDCap export may contain coded values, checkbox fields, repeated event structures, administrative variables, timestamps, and wide-format visit data. The export may be excellent as a database output but not yet convenient for a data quality report or statistical analysis.