Verifying audit data

You should always verify the completeness and validity of the data you are going to work with before performing any analytical work. Even a small amount of invalid data in a table can invalidate all your subsequent data analysis.

Operation Description
Verify Tests the validity of values in character, numeric, and datetime fields
Count

Counts the number of records in a table

You can compare the result to a control count

Total

Totals one or more numeric fields

You can compare the result to control totals

 

Analytics 14.1 Help