Back to projects
Maintenance management with SAP PM and Power BI
BI, 2026
Annual plan compliance and reliability by asset and packing line.
5
maintenance types
MTBF, MTTR
per asset and line
| Problem | SAP PM notifications, work orders and confirmations lived in loose exports; there was no view of progress against the annual Gantt nor of MTBF and MTTR per asset. |
|---|---|
| Solution | Power BI star schema on SAP PM exports, with DAX measures for MTBF, MTTR, physical availability, backlog and compliance by type (preventive, predictive, corrective, restorative, improvement), cost and duration per asset and owner, and a failure Pareto. |
| Results | Monthly KPI reports for management, critical assets prioritized and deviations caught in time for root-cause analysis. |
| Technologies | Power BI, DAX, Power Query, SAP PM, Excel |

