Mini-project
Automotive, EV & Aerospace
EV adoption across Indian states
Analyse vehicle registrations by state and fuel type to show how EV adoption is growing.
The brief
An EV start-up wants to know which states are adopting electric vehicles fastest, and in which vehicle types. Collect registration data from the VAHAN dashboard, load it into a database, and analyse EV share and growth by state, fuel type and vehicle class. Good looks like: a clean database, reconciled SQL queries, and charts of where EVs are growing.
What you will build
- Download registrations by state, fuel and vehicle class
- Clean and load them into a database
- Calculate EV share and growth in SQL
- Compare two-wheelers, three-wheelers and cars
- Write an illustrated briefing
Free, open data to build it with
- VAHAN dashboard: vehicle registrations ↗ Ministry of Road Transport and Highways
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.