Plant Information Data Mart

The BI-Cycle Plant Information Data Mart stores engineering data, maintenance work orders, preventive maintenance programs, production data, process data, spare parts, HSE incidents and more.

The BI-Cycle Data Mart can be implemented in the following Business Intelligence/Data Warehouse Solutions:

  • Oracle Enterprise, Microsoft SQL server and SAP BW

BI-Cycle has standard extractors for the following source systems:

  • ERP systems: SAP, IFS, Indus and others
  • CMMS systems: Maximo, Datastream and others

The BI-Cycle Data Mart supports the following KPIs:

Leadership and Organisation

  • Overall Operating Efficiency
  • Production Efficiency
  • Maintenance Cost per Total Operating Cost
  • Maintenance Cost per Equipment Replacement Value

Facility Availability

  • Proactive Maintenance Cost
  • Maintenance Cost per Capacity
  • Reliability Analysis Program Cost
  • Overall Equipment Effectiveness
  • Equipment Reliability
  • Reliability of Critical Equipment
  • Facility Availability
  • Availability of Critical Equipment

Work Management

  • Percent Planned Work
  • Man-Hour Schedule Compliance
  • Overdue Safety Critical Equipment Work Orders
  • Maintenance Personnel Utilization (Wrench Time)
  • Maintenance Personnel Utilization (Value Added Work)
  • Man-Hour Backlog
  • Percent Emergency Maintenance
  • Percent Proactive Maintenance
  • Percent Prompted Corrective Maintenance
  • Percent Breakdown Corrective Maintenance
  • Proactive Maintenance Man-Hours Overdue
  • Corrective Maintenance Man-Hours Overdue (non-emergency)
  • Estimated to Actual Proactive Maintenance Man-Hours
  • Estimated to Actual Corrective Maintenance Man-Hours
  • Maintenance Overtime Man-Hours
  • Contractor Cost
  • Effectiveness of Proactive Maintenance Program

Materials Management

  • Savings due to Preferred Provider Relationships
  • Storehouse Cost per Inventory Value
  • Storehouse Inventory per Equipment Replacement Value
  • Stockouts
  • Inventory Turns per Year
  • Parts Expedited

Continuous Improvement

  • Availability Improvement
  • Reliability Improvement
  • Maintenance Utilization Improvement
  • Schedule Compliance Improvement
  • Mean Time To Repair (MTTR)
  • Mean Time Between Failures (MTBF) for Critical Equipment

Leave a Reply