Data Verification
Data verification is the process of confirming that the data is accurate or true.
Data Verification Methods
- Review field value data
- look for data that seems to be outside the norm
- Verify record counts
- checking the record count is often the fastest and simplest way to validate a data load
- first step in confirming data integrity
- Data loss is the intentional or accidental loss of information through human error or an ineffective process
- occurs when records:
- are lost
- are incomplete
- are poorly named
- have accidentally dropped out
- discrepancy between data types in the source system and the system where data is transferred can also result in missing data
- checking the record count is often the fastest and simplest way to validate a data load
- Review calculations
- using calculations for verifying data is good
- but need to test and verify these calculations
- should also be reviewed within the peer review process
- using calculations for verifying data is good
- Test and explore visuals
- always confirm that:
- visuals are labeled correctly and meet business requirements
- data is sorted effectively for the visual
- visuals make sense to users
- always look for spelling errors in your visual titles, labels, and text
- confirm that colors are consistent across visuals
- always confirm that: