The scenario
EnergyLens is a beginner-friendly analytics project on time-series plant data: load it into MySQL, write the analysis queries, and build a Power BI dashboard comparing plants, inverters and weather conditions.
System architecture
01 Plant readings Generation + weather
02 MySQL Tables + views
03 Power BI KPIs
04 Alerts Under-performers
High-level flow of EnergyLens, from input to output.
What you will learn
- Time-series SQL
- KPI design
- Dashboard storytelling
What you will build
- MySQL database
- Analysis queries
- Performance dashboard
Build plan
- Load
- Query
- KPIs
- Dashboard
- Story