Data Validation

1 post / 0 new
Joined: 03/07/2019 - 21:58
Data Validation

Hi all,
I have recently moved roles from an commercial role to a consulting role. With the new role, I have noted that I would have to request for data extracts in order to perform analytics.
Would you be able to provide me with some tests that you would do to validate the data for completeness? Some of the tests I perform are:
- identifying blanks in key fields,
- verfiying the transaction dates to ensure the audit period is captured,
- number sequence check (where numbers are meant to be in sequence),
- confirmation of number of records with the provider of the data.
If you could let me know, that will be great. Thank you!