Power BI · Energy and renewables
Power BI asset performance dashboards for a renewable energy portfolio
A Power BI report that follows generation, losses, breakdowns and module cleaning across every solar plant in a portfolio, from an executive summary down to the inverter.
- Client
- A renewable energy company operating several solar plants
- Industry
- Energy and renewables
- Platform
- Power BI
- Started from
- Power BI Dashboards product
01The challenge
Generation, availability, breakdown and cleaning data sat in separate plant reports. Asset managers could not see how far each plant was from target, where the energy was being lost or whether the planned module cleaning was actually done.
02The solution
We built one Power BI report with fifteen pages on a single landing page. It covers ESG numbers, a loss waterfall, target against actual, monthly and daily KPIs, breakdown analysis with repair and failure times, and wet and dry module cleaning from the fleet down to the inverter and the day.
How the report works
- Bring plant data togetherGeneration, irradiation, availability, breakdown and cleaning data from every plant are loaded into one Power BI model.
- Start from the landing pageA landing page offers a button for every report page, so each role goes straight to its view.
- Check ESG and headline KPIsEnergy exported, performance ratio, availability and the equivalent environmental impact for the financial year.
- Compare target with actualGeneration, PR, irradiation and availability are shown with target, actual and deviation, month by month and day by day.
- See where energy is lostA waterfall splits the gap between target and actual into irradiation, availability, grid, curtailment and unknown losses.
- Analyse breakdownsBreakdowns are listed with component, fault and duration, then ranked by loss, with repair time and time between failures per fault.
- Track module cleaningWet and dry cleaning cycles are planned and measured against actual for every plant, block, inverter and day.
- Filter and shareSlicers for date, state, plant, component and fault, with the report shared through Microsoft 365.
Screens from the report
Sample data only. These screens show the layout and charts, not real figures.
Screen 1 of 12Built for this client
Landing page
One landing page with a button for every report page, so engineers and managers reach the right view in one click.
What we built
- Landing page navigationOne page with a button for every report view.
- ESG dashboardEnergy exported, PR, availability and equivalent trees and emissions saved.
- Loss waterfallTarget to actual generation with each loss bucket.
- Target against actual and daily achievementDeviation tiles, monthly charts and colour coded daily calendars.
- Breakdown analysisLoss by plant, fault and component with revenue lost per site.
- MTTR and MTBF analysisRepair time against time between failures for every fault.
- Module cleaning analysisWet and dry cleaning plan against actual from fleet to inverter and day.
- Detail tables and slicersDaily generation, breakdown and cleaning tables with slicers on every page.
Built with Power BI · DAX measures · Data modelling · Microsoft 365 sharing
The result
- 15Report pages from ESG summary to module cleaning records
- Target against actual for generation, PR, irradiation and availability
- Energy loss traced to plant, component and fault
- Cleaning plan against actual down to the inverter and day
More case studies
Power BI job life cycle, exception and debtors reports for a freight forwarder
A set of Power BI reports for a freight forwarding and customs clearing company with many branches. They follow every job from creation to closure and flag exceptions, pending billing, debtors and profit.
Read the case study →Power BI · Retail and consumer goodsPower BI sales dashboards for digital channels and prescription sales
Two Power BI reports that bring sales data from every channel into one view. Digital sales covers partners, marketplaces, website and products, and Rx sales covers prescribers, zones, brands and field teams.
Read the case study →Power BI · Food and beverageA Power BI supervisor scorecard for a multi-branch cafe chain
A Power BI report that gives branch supervisors one scorecard for sales, costs, delivery partner times, loss prevention, customer feedback and stock, each shown against target, with the standards documents one click away.
Read the case study →Planning something similar?
Tell us what you need. The first call is free.