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.
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