I have taken the project from CodeBasics Resume Project and done the project with My Knowledge.
Question & Answer Section:
1. List the top 3 and bottom 3 makers for the fiscal years 2023 and 2024 in terms of the number of 2-wheelers sold?
The Top 3 makers for the fiscal years 2023 and 2024 are OLA ELECTRIC, TVS, and ATHER. The Bottom 3 makers for the fiscal years 2023 and 2024 are BATTRE ELECTRIC, JITENDRA, and KINETIC GREEN.
2. Identify the top 5 states with the highest penetration rate in 2-wheeler and 4-wheeler EV sales in FY 2024.
The Top 5 states with the highest penetration rate in 2-wheeler and 4-wheeler EV sales in FY 2024 are Goa, Kerela, Karnataka, Maharashtra, and Delhi.
3. List the states with negative penetration (decline) in EV sales from 2022 to 2024?
There is no Negative penetration Rate From 2022 to 2024.
4. What are the quarterly trends based on sales volume for the top 5 EV makers (4-wheelers) from 2022 to 2024?
The Top 5 makers based on the quarterly trends in the fiscal years 2023 and 2024 are BYD India, Hyundai Motor, Mahindra, MG Motor, and Tata Motors.
5. How do the EV sales and penetration rates in Delhi compare to Karnataka for 2024?
The EV Sales is 160M and the penetration rate is 10.18% for Karnataka, which is higher compared to the EV Sales of 46k and a penetration rate of 7.71% for Delhi.
6. List down the compounded annual growth rate (CAGR) in 4-wheeler units for the top 5 makers from 2022 to 2024.
The top 5 makers of compounded annual growth rate (CAGR) from 2022 to 2024 are BMW India (1140.97%), Volvo Auto India (971.21%), BYD India (566.52%), Hyundai Motor (255.48%), and Mercedes - Benz AG (234.55%).
7. List down the top 10 states that had the highest compounded annual growth rate (CAGR) from 2022 to 2024 in total vehicles sold.
The Top 10 states that had the highest compounded annual growth rate are Uttar Pradesh, Madhya Pradesh, Kerela, Gujarat, Odisha, Maharashtra, Karnataka, Rajastan, Delhi, Tamil Nadu.
8. What are the peak and low season months for EV sales based on the data from 2022 to 2024?
The Peak Seasons are Febraury (133M) & March (193M). The low Season are June (62k) & July (74k).
10. Estimate the revenue growth rate of 4-wheeler and 2-wheelers EVs in India for 2022 vs 2024 and 2023 vs 2024, assuming an average unit price.
The revenue growth rate of
2-wheelers EVs in India for 2022 vs 2024 is 188.20% and 2023 vs 2024 is 269.28%.
The revenue growth rate of 4-wheeler
EVs in India for 2022 vs 2024 is 155.50% and 2023 vs 2024 is 367.79%.
