🌱⚡🚗 Electric-Vehicle-Market-Analysis

This repository contains resources for analyzing the Indian electric vehicle market to support AtliQ Motors' expansion strategy. It includes:

-🛠️ SQL Queries for querying and transforming raw EV sales data

• 📊 Power BI Dashboard visualizing key metrics across makers and states

• 📑 Presentation with strategic recommendations based on customer behavior, government policies, and infrastructure readiness.

📝 Company Overview

• AtliQ Motors, a leading U.S.-based EV manufacturer with 25% market share in North America, aims to expand into the Indian market where it currently holds less than 2% share.

• To assist in this expansion, the project explores the Indian EV landscape using data-driven analysis to identify market trends, customer behavior, and state-wise opportunities.

🎯 Objective

To analyze India’s electric and hybrid vehicle market and deliver actionable insights to support AtliQ Motors in:

• Understanding EV growth trends
• Identifying top-performing brands and states
• Assessing government incentives and infrastructure
• Strategically planning product launch and market penetration

⚠️ Problem Statement

• Despite its success in North America, AtliQ Motors has less than 2% market presence in India and lacks clear insights into the country’s EV and hybrid vehicle landscape

📊 Key Metrics Analyzed

• CAGR – Compound Annual Growth Rate
• Penetration Rate – EVs as a percentage of total vehicles
• Revenue Growth – State-wise and category-wise trends

👩‍💻 Tech Stack

• Data Visualization: Power BI
• Data Analysis: SQL
• Tools: SQL, Power BI Desktop, Power BI Service and Powerpoint.

📈 Dashboard Overview

🏭 Makers Report

• Top brands: Ola Electric, TVS, Ather
• Underperformer: Hero Electric (negative CAGR)

📈 Growth & Sales Trend

• March is consistently the peak sales month
• 2-Wheelers dominate the EV market (~92.6%)

🌍 State Report

• Highest revenue: Maharashtra, Karnataka, Tamil Nadu
• Highest EV penetration: Goa
• Infrastructure (charging stations) directly linked to higher EV adoption

💡 Insights & Recommendations

• Focus on high-revenue, high-penetration states for launch (e.g., Tamil Nadu, Maharashtra)
• Leverage government subsidies to improve price competitiveness
• Prioritize 2-wheeler EV segment for quicker market entry
• Invest in charging infrastructure to support long-term adoption

🔗 Important Links

💼 [Linkedin Post]https://www.linkedin.com/posts/shveta-maini-2b2a1a28b_sql-powerbi-electricvehicles-activity-7334073333900029952-fh5W?utm_source=share&utm_medium=member_desktop&rcm=ACoAAEZzviYBaoS8w9o7cPkOgTL26BLpYMkRRkM

📊 [Live Dashboard]https://app.powerbi.com/view?r=eyJrIjoiOThjMzIzY2ItNDU1Mi00MThhLTlkNmYtMGZkMWExYTA5YzQzIiwidCI6ImM2ZTU0OWIzLTVmNDUtNDAzMi1hYWU5LWQ0MjQ0ZGM1YjJjNCJ9

🎥 [Full Presentation Walkthrough]https://youtu.be/YUtfUir-3P8