DATA PROFILING

The process generates simple to advanced profiling information including basic data statistics (mean, median, frequency, variation, etc.) and details (structure, content, classifications, etc.) to identify data errors and weak points in your data collection processes.
Creates a data quality assessment table showing possible issues for each individual column in a customer database, including the number of profanities found, inconsistently ordered names, invalid ZIP codes,etc.

DATA STANDARDIZATION & FORMATTING

Customize and create rules (triggering) to standardize data.
Transform and standardize data such as names, addresses, dates, product numbers, and phone numbers.
Extract structured information from freeform text.

DUPLICATE IDENTIFICATION

After addresses are standardized, it is quite possible that there are duplicate records, especially if this is a merger of several lists or different departments or offices contribute to the list. Using deduplication software and protocols, it is possible to identify possible duplicate records.