🚗 Driving Change: EV Adoption Trends Across the U.S.

📘 Overview

This project presents an interactive Excel dashboard analyzing electric vehicle (EV) adoption trends across the United States. It focuses on understanding the distribution and growth of Battery Electric Vehicles (BEVs) and Plug-in Hybrid Electric Vehicles (PHEVs), along with the impact of CAFV (Clean Alternative Fuel Vehicle) eligibility.

The analysis is built using real-world EV registration data and showcases how Excel can be used as a powerful data analytics and visualization tool.

---

🎯 Objectives

• Analyze EV adoption trends across U.S. states
• Compare BEVs and PHEVs by volume and performance
• Evaluate CAFV eligibility distribution
• Identify leading manufacturers and models
• Build an interactive and user-friendly dashboard

---

📊 Dashboard Features

• KPI Cards: Total EVs, BEVs, PHEVs with percentage breakdown

• Map Visualization: State-wise EV distribution

• Trend Analysis: EV registrations by model year

• CAFV Eligibility Pie Chart

• Top 10 Manufacturers Chart

• Electric Range Treemap

• Interactive Filters (Slicers):

  • EV Type
  • CAFV Eligibility
  • Model Year
  • Make & Model

---

🗂️ Dataset Information

• Source: Kaggle EV Population Dataset

• Records: 177,000+ entries

• Key Columns:

  • Vehicle ID (VIN partial)
  • State, City, ZIP
  • Make, Model, Model Year
  • EV Type (BEV / PHEV)
  • Electric Range
  • CAFV Eligibility

---

🧹 Data Cleaning & Preparation

Performed using Power Query:

• Removed unnecessary columns (MSRP, utility, etc.)
• Standardized data types
• Handled missing/invalid values
• Created a structured Cleaned Data sheet

---

📈 Analysis Breakdown

1. KPI Summary

• Total EV count
• BEV vs PHEV distribution
• Percentage contribution

2. State-wise Analysis

• Map chart highlighting EV adoption across states

3. Yearly Trends

• Growth of EV registrations over time

4. CAFV Eligibility

• Categorization: Eligible / Not Eligible / Unknown

5. Top Manufacturers

• Top 10 brands by EV registrations

6. Electric Range Analysis

• Average range comparison across brands

---

🔍 Key Insights

• BEVs dominate the EV market (~79%)
• Tesla leads in both registrations and electric range
• PHEVs often fall short of CAFV eligibility criteria
• Washington State shows highest EV adoption 177477
• Adoption is influenced by policy, infrastructure, and performance

---

💡 Recommendations

For Policymakers

• Improve clarity of CAFV incentives
• Reassess eligibility criteria for PHEVs
• Promote EV adoption in low-growth regions

For Automakers

• Increase electric range for PHEVs
• Focus on affordability + performance balance

For Infrastructure Planners

• Expand charging networks in underserved areas
• Align infrastructure with adoption trends

---

🛠️ Tools & Technologies

• Microsoft Excel
• Power Query
• Pivot Tables
• Map Charts
• Data Visualization Techniques

---

📊 Dashboard Preview

---

📌 Conclusion

This project demonstrates how Excel can be used for end-to-end data analysis, from data cleaning to interactive dashboard creation. It highlights real-world EV trends and provides actionable insights for stakeholders.

---