Skip to content
Smith Lino Moreno
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

ProblemSAP 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.
SolutionPower 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.
ResultsMonthly KPI reports for management, critical assets prioritized and deviations caught in time for root-cause analysis.
TechnologiesPower BI, DAX, Power Query, SAP PM, Excel

More projects

3spend categories

Maintenance budget control

BI, 2026

Spend on spare parts, materials and third-party services against budget.

Power BI, DAX, Power Query, Excel

Ready to make better decisions with your data?

Book a free 30-minute consultation and get an initial assessment of your situation.