Back to Top

Data Cleaning

What is Data Cleaning?

Data cleaning, also called data cleansing or data scrubbing, consists of two parts:

  1. Auditing data for Precision, accuracy, validity, completeness, consistency, relevance and uniformity, and
  2. Performing remedial actions, which include:
  1. Correcting, modifying or removing corrupt or inaccurate data,
  2. Completing incomplete data,
  3. Enhancing lower quality data,
  4. Merging (or removing) duplicate records,
  5. Validating and correcting values against other sources of data,
  6. Standardising values, and
  7. Adapt data to the new data integration schema as required.

When migrating data from legacy system/s to a new database, the data should be ready for import after it has been cleaned.

What We Do

If you are in the process of implementing a new information system, we export your data from all existing systems, perform all the needed remedial actions, and return it to you ready to import to the new system.

When cleaning data of live systems, we create a plan of attack, and then, depending on the system in use, use the system’s own tools and / or third party tools to clean and restructure the data as required.

We train you on how to look after your data going forward, and create a schedule of data maintenance tasks.