Data Validation Process
What is Data Validation?
Data Validation is the process of checking uploaded data for errors, inconsistencies, and compliance with expected formats.
Checks Performed
Format Validation
- Correct column headers
- Proper data types (numbers, dates, text)
- Required fields present
Value Validation
- Valid CMMI IDs (participant exists)
- Values within expected ranges
- Consistent units
Integrity Validation
- No duplicates
- Dates in logical order
- References exist
Error Messages
- Clear descriptions of issues
- Row/column locations
- Suggestions for fixes
Related Terms
- Bulk Upload: Where validation occurs
- Data Quality: Goal of validation