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
  • 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
  • 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