🔍 What You’ll Learn:
EV adoption trends → Market gaps → Strategic growth insights
India is rapidly transitioning to electric vehicles (EVs), but stakeholders—manufacturers, policymakers, and investors—lack clear, data-driven insights into sales performance across segments and regions. Understanding where demand is growing and which categories are leading adoption is key to capitalizing on this shift.
Using real-world EV sales data, I built a comprehensive end-to-end analytics solution:
- Python (Pandas, NumPy): Cleaned and prepared raw data for analysis
- SQL: Queried and segmented structured data to uncover key trends
- Excel: Aggregated and explored data for quick pivots and validation
- Power BI: Designed an interactive dashboard to visualize:
- Vehicle category performance (2W, 3W, 4W, Public Transport)
- Regional sales patterns across Indian states
- Year-over-year growth trends with seasonal analysis
- 2-Wheelers lead adoption (~50%), indicating mass-market potential in low-cost EVs
- 3-Wheelers (~45%) highlight the demand for urban shared mobility
- 4-Wheelers and Public Transport show untapped potential for future investment
- Identified top-performing states (UP, Maharashtra, Karnataka, Delhi, Rajasthan)
- Revealed consistent annual growth (2015–2020) and seasonal demand patterns
This dashboard helps investors, government bodies, and EV companies understand where the market is heading—and how to align resources accordingly.
This repository contains my Electric Vehicle (EV) Sales Analysis and Dashboard project, completed as part of my internship at Unified Mentor. The goal of this project was to analyze India’s EV sales trends and deliver actionable insights using Python, SQL, Excel, and Power BI.
- Analyzed EV sales data covering vehicle categories, types, states, and time periods (2015–2020).
- Identified key trends, top-performing regions, and growth opportunities.
- Designed an interactive Power BI dashboard to visualize sales performance, category contribution, and regional breakdowns.
- 2-Wheelers lead the market with ~50% share (~1.8M units).
- 3-Wheelers contribute ~45% of total sales, reflecting the dominance of shared mobility solutions.
- 4-Wheelers and public transport vehicles remain under-penetrated, offering future growth opportunities.
- Top states for EV adoption: Uttar Pradesh, Maharashtra, Karnataka, Delhi, and Rajasthan.
- Consistent year-over-year growth, with clear seasonal peaks.
- Python: Data cleaning, preprocessing, and exploratory data analysis
- SQL: Querying structured data to extract key insights
- Excel: Initial data validation, pivot tables, and intermediate analysis
- Power BI: Building the final interactive dashboard
This project gave me practical exposure to combining multiple tools for end-to-end data analysis — from raw data processing in Python & SQL to final visualization in Power BI.
I’m always open to feedback and collaboration!
Feel free to ⭐️ star this repo, raise an issue, or connect with me on LinkedIn.