Project Objective: Electric Car Sales Dashboard

Overview:

The objective of this project is to create an interactive dashboard using Power BI that visualizes sales records of electric cars sourced from Kaggle data. The dashboard aims to provide insights into various key performance indicators (KPIs) related to electric vehicle sales, enabling stakeholders to make informed decisions and understand trends in the market.

Key Performance Indicators (KPIs):

1. Total Vehicles:

   • Definition: The total number of electric vehicles (BEV and PHEV) sold during the specified period.
   • Importance: Provides an overview of the overall sales volume of electric vehicles.

2. Average Electric Range:

   • Definition: The average range (in miles/kilometers) of electric vehicles available for sale.
   • Importance: Indicates the typical distance electric vehicles can travel on a single charge, which is a crucial factor for potential buyers considering electric vehicles.

3. Total BEV Vehicles and % of Total BEV Vehicles:

   • Definition:
     • Total BEV Vehicles: The total number of Battery Electric Vehicles (BEVs) sold.
     • % of Total BEV Vehicles: The percentage of BEVs compared to the total electric vehicle sales.
   • Importance: Helps to understand the market share of BEVs and assess the popularity of pure electric vehicles among consumers.

4. Total PHEV Vehicles and % of Total PHEV Vehicles:

   • Definition:
     • Total PHEV Vehicles: The total number of Plug-in Hybrid Electric Vehicles (PHEVs) sold.
     • % of Total PHEV Vehicles: The percentage of PHEVs compared to the total electric vehicle sales.
   • Importance: Provides insights into the market penetration of plug-in hybrid vehicles and their adoption rate compared to other electric vehicle types.

CHARTS INCLUDED

1. Total Vehicles by Model Year (From 2010 Onwards):

• Visualization: Line/ Area Chart
• Description: This chart will illustrate the distribution of electric vehicles over the years, starting from 2010, providing insights into the growth pattern and adoption trends.

2. Top 10 Total Vehicles by Make:

• Visualization: Bar Chart
• Description: Highlight the top 10 electric vehicle manufacturers based on the total number of vehicles, providing insights into the market dominance of specific brands.

3. Total Vehicles by CAFV Eligibility:

• Visualization: Pie Chart or Donut Chart
• Description: Illustrate the proportion of electric vehicles that are eligible for Clean Alternative Fuel Vehicle (CAFV) incentives, aiding in understanding the impact of incentives on vehicle adoption.

4. Top 10 Total Vehicles by Model:

• Visualization: Tree map
• Description: Highlight the top 10 electric vehicle models based on the total number of vehicles, offering insights into consumer preferences and popular models in the market.

Conclusion:

By creating this Power BI dashboard, the project aims to empower stakeholders with actionable insights into electric vehicle sales performance, market trends, and consumer preferences. This dashboard can serve as a valuable tool for decision-making and strategy formulation in the electric vehicle industry.