Project Description: Electric Vehicle Data Analysis

Overview

The Electric Vehicle Data Analysis project involved in-depth exploration and visualization of electric vehicle (EV) data using Microsoft Excel. Leveraging advanced features such as Pivot Tables and various chart types, this project aimed to extract valuable insights from a large dataset related to electric vehicles.

Key Objectives

Top 10 Number of Vehicles by Country:

Analyzed the distribution of electric vehicles across different countries.

Identified the top countries with the highest EV adoption rates.

Number of Electric Vehicles Registered by Model Year:

Tracked the growth trajectory of EV registrations over time.

Highlighted trends and fluctuations in adoption based on model years.

Top 10 Average Electric Range (in Km) After Full Charge:

Calculated and ranked electric vehicle models based on their average range post full charge.

Provided insights into the most efficient EVs in terms of range.

Vehicles Eligibility for Clean Alternative Fuel Vehicle (CAFV):

Evaluated whether vehicles met the criteria for Clean Alternative Fuel Vehicle status.

Assessed eligibility based on specific parameters.

Top 10 Number of Vehicles by Make:

Explored the market share of different EV manufacturers.

Identified the dominant players and emerging contenders.

Technology Stack

• Microsoft Excel: Utilized Excel as the primary tool for data manipulation, analysis, and visualization.
• Pivot Tables: Organized and summarized large datasets efficiently.
• Charts:
  • Bar Chart: Visualized the Top 10 Number of Vehicles by Country.
  • Line Chart: Tracked EV registrations by model year.
  • Pie Chart: Represented market share among different EV makes.
  • Treemap Chart: Depicted CAFV eligibility visually.

Key Achievements

• Successfully derived KPIs:
  • TOTAL VEHICLES: Total count of electric vehicles in the dataset.
  • TOTAL BEV VEHICLES: Count of battery electric vehicles.
  • TOTAL PHEV VEHICLES: Count of plug-in hybrid electric vehicles.
• Presented findings through clear and informative visualizations.