|
The transformation of your company data in it’s current state to a pre-defined, standardised format using off-the-shelf software as well as customised queries and functions. Our aim is to remove or correct the “dirty data” (i.e. incomplete, inconsistent, out-of-date, incorrectly formatted) on your database systems.
The main purpose of data cleansing is not just to clean up the data, but also to bring consistency and add value to the multiple sets of data in your organisation.
Typical Data Cleansing tasks we perform include the following:
|
Correcting spelling mistakes and abbreviations |
|
Identifying and dealing with duplicate records |
|
Identifying erroneous records |
|
Fixing or deleting erroneous/foreign characters |
|
Updating missing information e.g. postcodes, titles, suburbs etc. where possible |
|
Checking postcode and boxcode ranges |
|
Standardising data |
|
Unnecessary spaces |
|
Correct data in correct field (data shuffling) |
|
Changing the case of records to sentence case where appropriate |
|
Translating between English and Afrikaans |
|
Quality checks on telephone and cellphone numbers (correct length, dial codes, cellphone prefixes, etc.) |
|
