Thursday 6 February 2014

Three Service Levels For Data Cleansing

For IMA, flexibility has always been our competitive advantage when it comes to differentiating our services from others on the market. It is our flexibility and system independence that allows IMA to tailor MRO data to the specific needs of each client. IMA understands that every project is unique and the scope of work must be defined by the client’s specific business objectives, data requirements, and budgetary constraints. In an effort to satisfy those client needs, IMA has recently restructured its data cleansing service to offer three separate service levels. Those service levels are as follows:

LEVEL 1 - Cosmetic Cleanse
As an primary-level cleansing service, the Cosmetic Cleanse will identify and standardize Manufacturer Names and Part Numbers, while assigning accurate Noun-Modifier pairs for efficient part identification. During the Cosmetic Cleanse, duplicate items are identified within individual sites and across the corporation, while items lacking critical information are flagged as “review items”. The Cosmetic Cleanse is typically selected when data is being used specifically for procurement purposes, or when budgetary constraints are a critical factor. In this case, only pertinent information is cleansed to enable accurate spend analysis, commodity segmentation, and part identification.

Service includes:
  • Correct spelling mistakes
  • Convert text to desired format (Upper Case, Proper Case, etc.)
  • Provide a consistent and standardized noun, modifier, manufacturer name, and manufacturer part number
  • Example:
    • Raw data - Bearing, 6205-2rs, SKF
    • Cleansed – BEARING, BALL, SKF, 6205-2RS

LEVEL 2 – Standardization
As a mid-level cleansing service, the Standardization cleanse will identify and standardize Manufacturer Names and Part Numbers, assign accurate Noun-Modifier pairs and standardize the client provided item description. During the Standardization cleanse, duplicate items are identified within individual sites and across the corporation, while items lacking critical information are flagged as “review items”. The Standardization cleanse is typically selected when existing client data contains sufficient attribute information and enhancement is not required or desired. In this case, all existing information is cleansed according to pre-defined client standards, enabling improved part search ability, commodity segmentation, and spend analysis.

Service includes:
  • Correct spelling mistakes
  • Convert text to desired format (Upper Case, Proper Case, etc.)
  • Provide a consistent and standardized noun, modifier, manufacturer name, and manufacturer part number
  • Standardize the customer provided item description
  • Example:
    • Raw data - Bearing, 6205-2rs, two seals, SKF, 25 MM ID
    • Cleansed – BEARING, BALL, 25 MM ID, TWO SEALS, SKF, 6205-2RS

LEVEL 3 - Full Enhancement

As the luxury-level cleansing service, the Full Enhancement cleanse will identify and standardize Manufacturer Names and Part Numbers, assign accurate Noun-Modifier pairs, standardize the client provided item description, and provide attribute enhancements. During the Full Enhancement cleanse, duplicate items are identified within individual sites and across the corporation, while items lacking critical information are flagged as “review items”. The Full Enhancement cleanse is typically selected when data is being used by maintenance and engineering, in which case comprehensive and complete item descriptions are required for efficient part search ability. The Full Enhancement cleanse delivers data that is accurate, reliable and readily available, ensuring rapid part location, minimal equipment downtime, and detailed management reporting.

Service includes:

  • Correct spelling mistakes
  • Convert text to desired format (Upper Case, Proper Case, etc.)
  • Provide a consistent and standardized noun, modifier, manufacturer name, and manufacturer part number
  • Standardize the customer provided item description
  • Provide item attribute enhancement
  • Example:
    • Raw data - Bearing, 6205-2rs, two seals, SKF, 25 MM ID
    • Cleansed - BEARING, BALL, 25 MM ID, 52 MM OD, 15 MM WD, CONRAD, SINGLE ROW, LIGHT DUTY, 2 SEALS, C3 CLEARANCE, STEEL, SKF, 6205-2RS
For more information on IMA Ltd. and the services offered, please visit www.imaltd.com or contact info@imaltd.com.


1 comment:

  1. Great post on data cleansing. Data cleansing help us to detect and correct corrupt or inaccurate records from a record set, table, or database to increase data efficiency.

    ReplyDelete