Mini-project
Energy, Power & Utilities
India power supply analysis
Compare electricity demand, supply and shortages across states and sources.
The brief
An energy analyst wants to know which states face shortages and how the generation mix is changing. Load daily power data into a database and compare demand met, shortages and generation by source and region over time. Good looks like: a clean database, reconciled SQL queries, and charts of shortages and the growing share of renewables.
What you will build
- Collect daily power data by state and source
- Clean and load it into a database
- Compare demand, supply and shortage in SQL
- Track the share of renewables over time
- Write an illustrated briefing
Free, open data to build it with
- Grid-India reports ↗ Grid Controller of India
- Daily power generation in India ↗ Kaggle
Check each dataset's licence before you publish your work. Your mentor gives your team its own version of the brief (data, scope or region), so every team's project is its own.