PORTFOLIO / ASSET PERFORMANCE
Power BI · DAX · Multi-grain fact tables · As-of backlog · USERELATIONSHIP
Vanterra Energy is a fictional 428 MW wind and solar operator. Is the fleet generating to plan, and when it falls short, is the cause the equipment, the grid or the weather?
Three fact tables at different grains (daily generation, reliability events and work orders) that reconcile to each other, so lost hours, lost energy and repair work tell the same story.
As-of backlog logic: open work orders are counted at any point in time from created and completed dates, so month-on-month backlog movement is real, not a snapshot.
Role-playing dates: work orders are analysed by created or completed date using an inactive relationship and USERELATIONSHIP.
Self-updating narrative: headlines, insights and the priority action are DAX measures, so the story stays true under any filter.
Five pages: Fleet overview, Generation, Reliability, Maintenance, and a How I built it page that documents the model, DAX and definitions.
Generation is 5.5% behind plan year to date. Wind is the gap at 8.0% below plan (49.6 GWh); solar is slightly ahead.
North Ridge Wind accounts for 78% of unplanned downtime hours and 95% of unplanned generation loss. Gearbox events are the largest cause, at 74% of its downtime.
Five critical work orders are open at North Ridge, putting 142 MW of capacity at risk.
Preventive maintenance compliance at North Ridge is 72.2% against a 95% target.
Run a gearbox inspection campaign at North Ridge, starting with the turbines that have open critical work orders.
Restore preventive maintenance compliance at North Ridge before adding more corrective work.
Review curtailment at Elk Valley with the grid operator.
All data is fictional and was generated for portfolio use. Use the tabs inside the report to explore each page.
Medical Imaging Equipment: equipment health, maintenance and downtime for a fictional hospital.