Power BI Dashboard for Electric Vehicles (EV) launch in India

Hi Everyone,
I’m excited to share my analysis on Electric Vehicles (EV) launch in India Dashboard project, by Codebasics.

Some Key Useful Insights:

Below is the detailed analysis of AtliQ Motors’ data for the Electric Vehicles (EV) launch in India.

𝟭. 𝗧𝗼𝗽 𝗮𝗻𝗱 𝗯𝗼𝘁𝘁𝗼𝗺 2-wheeler Electric Vehicle Maker:

• OLA Electrics, TVS, and Arther are the leading electric 2-wheeler makers for the year 2024, with sales of 15.61%, 8.75%, and 5.21% of total sales, respectively.
• OLA Electrics, OKINAWA, and Hero Electric are the leading electric 2-wheeler makers for the year 2023 with sales of 7.39%, 4.69%, and 4.31% of total sales, respectively.
• KINETIC Green, REVOLT, and BATTRE Electric are the bottom electric 2-wheeler makers for the year 2024, with sales of 0.46%, 0.35%, and 0.23% of total sales, respectively.
• PURE EV, BEING, and JITENDRA are the bottom electric 2-wheeler makers for the year 2023 with sales of 0.56%, 0.53%, and 0.41% of total sales, respectively.

2. 𝗧𝗼𝗽 𝗮𝗻𝗱 𝗯𝗼𝘁𝘁𝗼𝗺 4-wheeler Electric Vehicle Maker:

• Tata Motors, Mahindra & Mahindra, and MG Motor are the leading electric 4-wheeler makers for the fiscal year 2024 with sales of 2.33%, 1.13%, and 0.43% of total sales, respectively.
• Tata Motors, Mahindra & Mahindra, and MG Motor are the leading electric 4-wheeler makers for the fiscal year 2023 with sales of 1.36%, 0.67%, and 0.16% of total sales, respectively.
•  VOLVO Auto India, Kia Motors, and Mercedes-Benz AG are the bottom electric 4-wheeler makers for the fiscal year 2024 with sales of 0.02%, 0.02%, and 0.01% of total sales, respectively.
• PCA Automobiles, VOLVO Auto India, and Mercedes-Benz AG are the bottom electric 4-wheeler makers for the fiscal year 2023 with sales of 0.01%, 0.01%, and 0.00% of total sales, respectively.

3. States with the Highest and Negative Penetration Rates:

• Goa, Kerala, Karnataka, Maharashtra, and Delhi are the top 5 states with the highest Penetration rate for electric 2-wheelers for the fiscal year 2024.
• Kerala, Chandigarh, Delhi, Karnataka, and Goa are the top 5 states with the highest Penetration rate for electric 4-wheelers for the fiscal year 2024.
• Rajasthan, Haryana, Uttarakhand, Gujarat, and Jharkhand are the 5 states with negative Penetration rates for Electric Vehicles for the fiscal year 2024.

4. 𝗣𝗿𝗼𝗱𝘂𝗰𝘁 𝗖𝗮𝘁𝗲𝗴𝗼𝗿𝘆 𝗧𝗿𝗲𝗻𝗱𝘀:

• 𝗠𝗮𝗿𝗰𝗵 stand out as 𝗽𝗲𝗮𝗸 𝘀𝗮𝗹𝗲𝘀 𝗺𝗼𝗻𝘁𝗵𝘀 for both 2-wheeler and 4-wheeler Electric Vehicle shows highest sales in the last quarter(Q4) of the fiscal year for most of the EV makers except Mahindra & Mahindra (4-wheeler category).
• June experienced the 𝗹𝗼𝘄𝗲𝘀𝘁 𝗽𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲 for 2-wheeler EV and 𝗔𝗽𝗿𝗶𝗹 experienced the 𝗹𝗼𝘄𝗲𝘀𝘁 𝗽𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲 for 4-wheeler EV. These two months come under the first Quarter of the fiscal year, showing the least sales in Q1.

5. States and Makers with the Highest Compound Annual Growth Rate(CAGR):

• BMW India, Volvo Auto India, BYD India, OLA Electric, and TVS are the top 5 makers with the highest CAGR from the fiscal year 2022 to 2024.
• Some Makers like Kia Motors, Jitendra, Kinetic Green, and PCA Automobiles are showing -100% CAGR because there are no electric vehicles sold for these makers in the fiscal year 2022.
• Meghalaya, Goa, Assam, Gujarat, Karnataka, and Rajasthan are the top states with the highest CAGR, with the maximum number of vehicles sold.
• Maharashtra, Karnataka, Kerala, Gujarat, Uttar Pradesh, Madhya Pradesh, and Chhattisgarh show the highest forecast for Electric vehicle sales by 2030.

6. Revenue Growth:

•  The revenue of 4-wheelers grows more than 2-wheelers from 2022 to 2024. The 2-wheeler revenue grows from 5.90% to 7.61% but for the 4-wheeler, it increases from 22.52% to 29.18%

𝗥𝗲𝗰𝗼𝗺𝗺𝗲𝗻𝗱𝗮𝘁𝗶𝗼𝗻s:

1. Karnataka, Maharashtra, Uttar Pradesh, and Delhi have the most charging stations in India, justifying these states with the highest penetration rate for Electric Vehicles.
2. Gujarat, Maharashtra, Karnataka, Andhra Pradesh, and Meghalaya provide maximum subsidies on electric vehicles in India.
3. Low Cost, Environmental Benefits, Increase in Charging Infrastructure, Government Incentives, and subsidies are the prime factors that made AtliQ Motors launch Electric Vehicles in India.
4. Gujarat is expanding its EV ecosystem via investing in investments in manufacturing, charging infrastructure, and battery technology. Many big players set up their plants in Gujarat for EV manufacturing.
5. Apart from Gujarat, Tamil Nadu, Andhra Pradesh, Maharashtra, Uttar Pradesh, and Delhi are good choices to set up manufacturing units for AtliQ Motors.

This is my first independent attempt at the Power BI Dashboard for the complete project. Kindly share your suggestions so that I can improve my future dashboards!

Thank you!