Explore the live dashboard : [Open](https://app.powerbi.com/groups/me/reports/5def771b-6f22-4d3d-9dea-c2ca29663e97/46f9b9de7040d19806d7?experience=power-bi&clientSideAuth=0
🎯 Project Introduction:
AtliQ Motors is an automotive giant from the USA specializing in electric vehicles (EV). In the last 5 years, their market share rose to 25% in electric and hybrid vehicles segment in North America. As a part of their expansion plans, they wanted to launch their bestselling models in India where their market share is less than 2%. The chief of AtliQ Motors India wanted to do a detailed market study of existing EV/Hybrid market in India before proceeding further.
🎯 Project Objective:
The objective is to create a comprehensive dashboard analyzing EV production and sales in India for the 2-wheeler and 4-wheeler segments from 2022 to 2024.
🔎 Power BI Dashboard Overview:
✅ Home View: A landing page with icons to navigate to different views.
✅ EV Makers Sales View : Provides makers' sales insights with filters.
✅ States_Sales View : Provides state-wise sales insights for EVs.
✅ Sales Analysis of States View : EV Sales comparison of all Indian States.
📢 I would like to share the brief gist of "Technical skills" which I acquired in the journey:
✒ Data Modelling:-
↪ Establishing the relationships between tables.
✒ Power Query:-
↪ ETL(Extract, Transform , Load) software in Power Bi
✒ DAX language(Data Analysis Expression):-
↪ New Measure
↪ Calculated Column
✒ Rules for designing effective Dashboard
✒ Creating Slicer.
✒ Editing relationships between different charts in the dashboard.
💡Key Insights:
🔹 Market Leaders: Tata Motors leads the Indian EV market for 4-wheelers, while Ola Electric dominates in the 2-wheeler segment.
🔹 2-Wheeler Dominance: 2-wheelers represent a significant 91% of total EV sales in India.
🔹 Regional Success: Goa boasts the highest EV penetration rate at 18%, with Maharashtra and Karnataka following closely.
🔹 Infrastructure Growth: Maharashtra leads in public charging station infrastructure, supporting the state's strong EV adoption.
🔹 Top Performing States: Maharashtra and Karnataka stand out with nearly 3 lakh EVs sold, reflecting their strong market performance and penetration rates.
𝐑𝐞𝐜𝐨𝐦𝐦𝐞𝐧𝐝𝐚𝐭𝐢𝐨𝐧𝐬:
↪Leverage Government Subsidies
↪Target High-Potential States
↪Tailor Marketing for Indian Consumers
↪Invest in Infrastructure for Future Growth
↪Invest in R&D for Technology Advancements
I'd love to hear your feedback, questions, or insights! Feel free to explore and connect with me. MailId: [email protected]