Data Cleansing and Normalization

Often the existing data has no consistent format being derived from many sources. Or it contains duplicate records/items and may have missing or incomplete descriptions. DESTINY assists in creating and maintaining clean item master and vendor master files.

DESTINY data cleansing process fixes misspellings, abbreviations, and errors. The data is normalized so that there is a common unit of measure for items in a class, e.g. feet, inches, meters, etc. are all converted to one unit of measure. The values are also standardized so that the name of each attribute is consistent, e.g. inch, in., and the symbol “ are all shown as inch.

Our capabilities for Data cleansing and normalization services include:

• Data aggregation, organization, and cleansing
• De-duplication: eliminate duplicate records which might be similar looking records
• Enrichment of data with product attributes, images, and Manufacturer specifications
• Identification of missing or incomplete data
• Abbreviation expansion