Data governance - Activity
Data cleansing
Correcting, removing or standardising poor-quality data so it is safer to use
What's it for?
Improves data by fixing or removing errors, gaps and duplicates before people rely on it.
For example…
Duplicate supplier rows are merged and blank postcodes are filled from a trusted source.
Before migration, data cleansing standardises country names, fixes malformed email addresses and removes duplicate customer records
Think of it like…
Proofreading and tidying a messy address book before you print mailing labels