Data Cleansing
Consulting Services to audit, deduplicate, extract, reformat and cleanse your digital files
Consulting Services to audit, deduplicate, extract, reformat and cleanse your digital files
File systems, databases, spreadsheets and drawings over time become disorganised and littered with dirty data.
Datasets are plagued with inaccurate, incomplete, inconsistent and out-of-date information. CAD drawings
contain data that does not conform to a standard, have information in the wrong fields, levels or symbology.
Dirty data has inherent negative effects on all data-driven activities including filename and metadata searches.
Without data cleansing and enforced document standards your data will become plagued with issues such as the following:
• Duplicates - these are costly, confuse searches and you run the risk of working on the wrong document or record
• Dirty Data - documents and metadata of poor quality, incomplete and inconsistent
• Incorrect Filenames - documents will not appear in searches and often are misplaced and subsequently duplicated
• Propogation - documents and records can be duplicated whereby dirty data is propogated
If you are about to implement a document management system (DMS) we strongly recommend that you cleanse your data
before you upload it into the DMS. A DMS will be a powerful mechanism to search for and manage your documents and
you do not want to infiltrate such a valuable resource with dirty data.
Having clean, accurate data is critical as it ensures information is consistent, standardised and uniform, in the
right fields and uses only valid characters. ECS apply various cleansing routines according to each client's
requirements, and can also help to determine business rules for maintaining data quality in the future.
A complete data cleansing process improves the condition of your data ensuring:
• Accuracy
• Quality
• Completeness
• Elimination of errors and inconsistencies
• Searchability
• Deliverability
• Predictability
• Adherence to standards
ECS have conducting data cleansing and data migration projects on large scales. Hundreds of thousands of documents
checked and cleansed to eradicate dirty data, and to introduce a level of consistency that seriously improves the value
of client's data assets as well as increased productivity, searchability and predictability.
We have a suite of tools to extract information from spreadsheets, DWG and DGN files as well as cell libraries and
datasheets. The extracted data is presented in a spreadsheet and can be sorted and evaluated to reveal the state of
your data. Cleansing processes can follow using the extracted data in the spreadsheet as the reference for conducting
the corrections.
Arrange a meeting today to discuss how a review can be undertaken of your digital data. We will formulate a plan to review what data your organisation has, how and when to audit the data and set in place a process for data cleansing together with improving work practices to help keep your data clean and accurate.