Logo

About

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%.

Dashboard


Introduction

In this project we used PowerBI Power Query for data Preprocessing and Transforamtion and Power BI for visualization.
Throughout this challenge, we will identify some interesting questions within an Electric Vehicles dataset.

Questions

  • List top 3 & bottom 3 makers for the fiscal years 2023 and 2024 in terms of the number of 2-wheelers sold.
  • Identify the top 5 states with the highest penetration rate in 2-wheeler and 4-wheeler EV sales in FY 2024.
  • List the states with negative penetration (decline) in EV sales from 2022 to 2024?
  • What are the quarterly trends based on sales volume for the top 5 EV makers (4-wheelers) from 2022 to 2024?
  • How do the EV sales and penetration rates in Delhi compare to Karnataka for 2024?
  • List down the compounded annual growth rate (CAGR) in 4-wheeler units for the top 5 makers from 2022 to 2024.
  • List down top 10 states that had the highest (CAGR) from 2022 to 2024 in total vehicles sold.
  • What are the peak and low season months for EV sales based on the data from 2022 to 2024?
  • What is the projected number of EV sales for top 10 states by penetration rate in 2030, based on the (CAGR) from previous years?
  • Estimate the revenue growth rate in India for 2022 vs 2024 and 2023 vs 2024, assuming an average unit price.