The Key to Unlocking the Full Potential of Your CMMS

The Key to Unlocking the Full Potential of Your CMMS

Jocelyn Facciotti

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
TimkenH913810BEARING, CUP, TAPERED ROLLER, 5.7500” OD, 1.0000” WD, 0.1250” 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.

Jocelyn Facciotti

Jocelyn Facciotti is the Marketing Manager for I.M.A. Ltd., a company that specializes in MRO Data Cleansing and related MMDM services. Using a proven combination of proprietary software, people and procedures, I.M.A. Ltd. supports many global Fortune 100 and 500 companies in their efforts to improve materials data quality. Working with CMMS providers, integrators, and end users on a daily basis, Jocelyn emphasizes the positive results that quality data can deliver to an organization. To learn more about I.M.A. Ltd. and the services offered, visit and take advantage of a complimentary MRO Data Evaluation

Picture of idconadmin



Join the discussion

Click here to join the Maintenance and Reliability Information Exchange, where readers and authors share articles, opinions, and more.

Get Weekly Maintenance Tips

delivered straight to your inbox