Learn how to use Power BI to create a Planned vs Actual Work Order Maintenance KPI.
In this video I'll take you step-by-step through the process of setting up the calculated columns and measures required to created a planned vs actual work order hours KPI.
Planned vs actual hours (Planner accuracy) is a maintenance KPI that compares the hour originally planned on a work order against the final total hours booked to a work order. However this approach could be used for cost too. It could also be used in project management or any ticketing system that has the concept of planned vs actual analysis.
The approach I cover also let you set different planned vs actual tolerance levels for work orders with different planned hours. For example you might want to set a higher planned vs actual tolerance level for work order with a lower number of hours.
Once I've set-up the calculations I'll then take you through the process I took when creating a planned vs actual hour planning accuracy dashboard.
Tip: This is a longer video so why not try increasing the playback speed to save time. Research has shown that this can speed up your learning! You'd be surprised how well it works!