Data cleansing, data cleaning, or data scrubbing is the process of detecting and correcting (or removing) corrupt or inaccurate records from a record set, table, or database. Used mainly in databases, it’s identifying incomplete, incorrect, inaccurate, irrelevant, etc. parts of the data and then replacing, modifying, or deleting this compromised data.
Inconsistencies in data can be caused by user entry errors, by corruption in transmission or storage, or by different definitions of similar entities.
The actual process of data cleansing may involve removing typographical errors or validating and correcting values against a known list of entities. The validation may be strict (such as rejecting any address that does not have a valid postal code) or fuzzy (such as correcting records that partially match existing, known records).
What are our prices?
We offer a full bespoke data cleansing service, please contact us to discuss your requirements and for a no obligation quote.