While data quality may seem both simple and obvious, many companies overlook this area due to a misunderstanding on how the CMMS and data are used. In some cases, companies are well aware of their data quality issues, yet don’t understand the affects that poor data can have on their organization. In other cases, companies believe that an expensive new CMMS will be the answer to all of their problems, only to realize six months down the road that they cannot conduct basic part searches and transactional reports.

Improving and maintaining data quality is an ongoing process that plays a critical role in an organization’s overall cost savings strategy and the success of a CMMS implementation. A typical data cleansing project begins by establishing client-specific data standards that will consistently be used to structure data moving forward. The Standard Operating Procedure will address client-specific CMMS configuration, naming convention, abbreviation, and classification requirements.

Before migrating legacy data to the new CMMS, each and every item needs to be cleansed, standardized and enhanced where possible, according to pre-defined client standards. During the cleansing process, manufacturer names and part numbers are segregated, existing information is parsed and standardized, spelling mistakes are corrected, and text is converted to upper or proper case. Each item is assigned a new corporate part number, linking all sites of the organization in a “virtual warehouse”, while legacy item/ID numbers remain in tact for future reference. After the cleansing process is complete, duplicate items are identified by direct match and fit-form-function similarity. Direct duplicates include two or more items possessing the same manufacturer name, part number and description, whereas, fit-form-function duplicates include two or more items that possess different manufacturer names and part numbers, but have the same description and specifications. Dependent on client preference, items can be classified by various international and client-specific codification systems, enabling deeper reporting capabilities. The final deliverable is then formatted to comply with specific configuration requirements of the chosen CMMS, including field name, type and character limitation.

To illustrate the results of data cleansing, let’s take a look at a few samples.

The first sample shows what a client’s raw data looked like before and after it had been cleansed, standardized and enhanced.

BeforeRaw Client Data

PlantPlant 1
Stock Number222-113-509
Manufacturer NameSKF USA
Manufacturer Part Number23022CCC3W33
Description23022 CC/C3W33SKF Bearing, ABC Co. 12345
Vendor NameABC Company
Vendor Part Number12345

AfterCleansed, Standardized and Enhanced Data

PlantPlant 1
Material Number1000001
Manufacturer NameSKF
Manufacturer Part Number23022 CC/C3W33
Material DescriptionBEARING, ROLLER, 110MM ID, 170MM OD
Vendor Part Number12345
Old Item Number222-113-509
Corp Number *1000001

The second sample illustrates the consistency within a specific product group before and after cleansing.

BeforeRaw Client Data

MFG NamePart NumberDescription
TimkinH913810BEARING TAPERED 5 3/4” x 1” x 0.130”
TimkenM88010BEARING TAPERED 2 11/16” x 11/16” x 0.060”

AfterCleansed, Standardized and Enhanced Data

MFG NamePart NumberDescription
Timken25821BEARING, CUP, TAPERED ROLLER, 2.8750” OD, 0.7500” WD, 0.0310” RAD, STRAIGHT OUTER
Timken33821BEARING, CUP, TAPERED ROLLER, 3.7500” OD, 0.8750” WD, 0.0930” RAD, STRAIGHT OUTER
TimkenM88010BEARING, CUP, TAPERED ROLLER, 2.6875” OD, 0.6875” WD, 0.0620” RAD, STRAIGHT OUTER

As you can see, the transformation is astonishing and the benefits of data cleansing are clear. What was once inconsistent, incomplete and inaccurate information is now clean, standardized and enhanced data that, in this case, has been formatted specifically for SAP. Using the cleansed Item/Material Master, organizations can now identify and dispose of excess inventory, reduce equipment downtime, eliminate false stock-outs, prevent maverick purchases, and leverage accurate search and reporting functionalities for improved maintenance efficiency.

Through trial and error, organizations are quickly learning that no matter how expensive, functionality-rich, or industry recommended a CMMS may be, the reality is that the software is only as good as the data flowing through it. While data cleansing may add cost to an already expensive CMMS implementation, the savings and long-term benefits far exceed the upfront investment.

Keep reading...Show less

Upcoming Events

August 9 - August 11 2022

MaximoWorld 2022

View all Events
80% of Reliabilityweb.com newsletter subscribers report finding something used to improve their jobs on a regular basis.
Subscribers get exclusive content. Just released...MRO Best Practices Special Report - a $399 value!
“Steel-ing” Reliability in Alabama

A joint venture between two of the world’s largest steel companies inspired innovative approaches to maintenance reliability that incorporate the tools, technology and techniques of today. This article takes you on their journey.

Three Things You Need to Know About Capital Project Prioritization

“Why do you think these two projects rank so much higher in this method than the first method?” the facilitator asked the director of reliability.

What Is Industrial Maintenance as a Service?

Industrial maintenance as a service (#imaas) transfers the digital and/or manual management of maintenance and industrial operations from machine users to machine manufacturers (OEMs), while improving it considerably.

Three Things You Need to Know About Criticality Analysis

When it comes to criticality analysis, there are three key factors must be emphasized.

Turning the Oil Tanker

This article highlights the hidden trap of performance management systems.

Optimizing Value From Physical Assets

There are ever-increasing opportunities to create new and sustainable value in asset-intensive organizations through enhanced use of technology.

Conducting Asset Criticality Assessment for Better Maintenance Strategy and Techniques

Conducting an asset criticality assessment (ACA) is the first step in maintaining the assets properly. This article addresses the best maintenance strategy for assets by using ACA techniques.

Harmonizing PMs

Maintenance reliability is, of course, an essential part of any successful business that wants to remain successful. It includes the three PMs: predictive, preventive and proactive maintenance.

How an Edge IoT Platform Increases Efficiency, Availability and Productivity

Within four years, more than 30 per cent of businesses and organizations will include edge computing in their cloud deployments to address bandwidth bottlenecks, reduce latency, and process data for decision support in real-time.

MaximoWorld 2022

The world's largest conference for IBM Maximo users, IBM Executives, IBM Maximo Partners and Services with Uptime Elements Reliability Framework and Asset Management System is being held Aug 8-11, 2022