Skip to main content

Maintenance Dashboard - Solution Documentation

The Maintenance Dashboard allows to get insights about costs and maintenance activities. It provides a comprehensive overview of the maintenance status of the assets and the costs associated with the maintenance activities. The dashboard is designed to help maintenance managers and technicians to monitor the maintenance activities, track the costs, and identify potential issues that require immediate attention.

Architecture​

Core Components​

1. Data Modeling (Construction Kit)​

  • Classes: Maintenance Orders, Cost Centers, Confirmations, Energy Consumers
  • Attributes: Order Number, Costs, Status, Timestamps, Energy Consumption
  • Associations: Links between maintenance orders, assets, costs, and confirmations
  • Records: Complex data structures for maintenance history and energy data

2. Data Integration​

Maintenance Orders (SAP/CMMS)

  • Planned and unplanned maintenance
  • Order status and priorities
  • Maintenance intervals
  • Spare parts requirements

Costs (SAP/Excel)

  • Labor costs
  • Material costs
  • External services
  • Total cost analysis

Confirmations (CMMS/Mobile Apps)

  • Working hours
  • Completed activities
  • Consumed materials
  • Status updates

Energy Data (SCADA/IoT)

  • Asset energy consumption
  • Load profiles
  • Efficiency metrics
  • Downtime

3. Aggregations​

  • Cost summation per asset/cost center
  • Maintenance effort by asset type
  • MTBF/MTTR calculations
  • Energy efficiency KPIs
  • Maintenance costs vs. energy consumption correlations

4. Data Provisioning​

Maintenance Dashboard

  • Maintenance order overview
  • Cost analyses
  • Confirmation status
  • Asset availability

PowerBI Analytics

  • Maintenance trends
  • Cost development
  • Energy efficiency reports
  • Predictive maintenance indicators

API Layer

  • Integration with ERP systems
  • Mobile app connectivity for technicians
  • Data export for compliance reports

Benefits​

  • Unified Data Base: All maintenance data in a standardized model
  • Flexibility: Construction Kit enables adjustments without system changes
  • Scalability: From individual assets to complete asset portfolios
  • Transparency: Complete traceability of maintenance costs and activities
  • Efficiency: Correlation of maintenance effort and energy consumption for optimization