CMMS Software | CMMS Programs
One of the benefits of using CMMS software is that once data is submitted to the system it becomes available for analysis and reporting. Data analysis can identify problems in the maintenance operation directing the maintenance manager to the proper corrective actions. There are several ways to analyze equipment maintenance data and report on this data with CMMS software. All of the methods presented below are fairly simple to use. Some are drag and drop.
- Built-in analysis tools that use SQL queries.
- OLAP (online analytical processing) data cubes.
- Crystal Reports.
- Direct Excel export.
- OLE automation Excel export.
- OEE (overall equipment effectiveness).
Some of the above listed methods are presented below. Others are on their own separate page. If further explanation is needed feel free to contact CMMS University.
Inventory and Purchasing, Work Order and Preventative Maintenance Analysis screens are all presented with basically the same format. Therefore of these three analysis sections only the work order analysis screen will be discussed below. The Down Time (equipment failure) Analysis screen is unique in it's format and use so it will be also discussed below.
Other data analysis methods and procedures covered in this and another separate module are listed below. Reliability analysis (military standard) analyzes failure rate and Mean Time Between Failure (MTBF) using either individual equipment items or groups of equipment items. This CMMS software package is unique in that it also provide a way for the maintenance manager to compare MTBF with PM task intervals and then the software suggests optimized preventative maintenance task intervals based upon this MTBF data.
- PM (preventative maintenance) completion rate reporting.
- Overall Equipment Effectiveness (OEE).
- Methods for reporting CMMS data.
- Online Analytical Processing (OLAP).
Inventory, PM and Work Order Analysis
- CMMS data analysis overview.
- Date filters.
- CMMS data filtered analysis reports.
- Reporting methods.
- Equipment failure analysis methods.
- Equipment failure (downtime) reports.
- Using OLAP to analyze equipment failures.
- Exporting unexpected downtime CMMS data.
Reliability Analysis and Cost of Equipment
- Reliability analysis methods.
- Reliability analysis and PM task intervals.
- Overall cost of equipment.