• Login / Signup

    • Welcome Back

    Google icon Sign in with Google
    OR
    Forgot Password?
    I agree to abide by Pharmadaily Terms of Service and its Privacy Policy

    Create Account

    Google icon Sign up with Google
    OR
    By signing up, you agree to our Terms of Service and Privacy Policy
    Instagram
    youtube
    Facebook

    Electric Vehicle Sales Dashboard in Power BI

    Objective:

    Learn how to import, prepare, visualize, and analyze real-world Electric Vehicle sales data from India using Power BI, and create an interactive dashboard to extract actionable insights.

    Step 1: Understand the Dataset

    • Source: Clean Mobility Shift Website

    • Download: Kaggle Dataset - Electric Vehicle Sales by State in India (CSV format)

    • Size: ~96,846 rows, 8 columns

    • Key Fields:

      • Year, Month Name, Date

      • State (Indian states/UTs)

      • Vehicle Class (motor car, cab, etc.)

      • Vehicle Category (4-Wheelers, Others)

      • Vehicle Type (Personal, Shared)

      • EV Sales Quantity (number of vehicles sold)

    Note: Dataset is clean and ready for use.

    Step 2: Load Data into Power BI

    • Open Power BI Desktop

    • Click Get Data > Text/CSV

    • Select and load the downloaded CSV file

    Step 3: Data Preparation

    • Open Power Query Editor to inspect data

    • Check for missing values or errors (minimal cleaning needed here)

    • Since there is only one table, no relationships need to be created

    Step 4: Create Key Measures

    Create the following DAX measures for analysis:

    • Total EV Sales = SUM([EV Sales Quantity])

    • Monthly Sales = Aggregate EV Sales by Month

    • State-wise Sales = Aggregate EV Sales by State

    • Sales by Vehicle Class = Aggregate by Vehicle Class

    • Yearly Sales by Vehicle Category = Aggregate by Year and Category

    Step 5: Build Visualizations

    • Card Visual: Show Total EV Sales dynamically

    • Line Chart: Monthly sales trend (shows peaks and dips)

    • Pie Chart: State-wise sales distribution (percentage share)

    • Bar Chart: Sales by Vehicle Class

    • Waterfall Chart: Yearly sales by Vehicle Category

    Step 6: Add Filters and Slicers

    • Add Dropdown Slicers for:

      • Year

      • Month

      • Vehicle Category

    • Add Toggle Buttons to switch between Personal and Shared vehicle types

    Step 7: Make Dashboard Interactive

    • Connect all slicers to every visual

    • Selecting any filter updates all charts dynamically for seamless data exploration

    Step 8: Design and Format

    • Use consistent color themes and fonts

    • Add titles, labels, and legends for clarity

    • Arrange visuals in a logical flow for easy understanding

    Step 9: Insights from the Dashboard

    • Top EV-selling States: Maharashtra, Karnataka, Delhi

    • Monthly Sales Pattern: Peak in December, dip in January-February

    • Popular Vehicle Class: Motor cars lead sales

    • Market Focus: Majority sales are 4-Wheelers

    Step 10: Recommended Actions Based on Insights

    • Boost EV sales in states with low sales figures

    • Investigate causes for monthly sales dip and address strategically

    • Promote shared vehicles and smaller 2/3-wheelers for market expansion

    • Regularly update dataset to maintain dashboard accuracy

    • Use high-performing states as benchmarks for improvement

    Conclusion

    By completing this lesson, you will be able to:

    • Import and prepare data in Power BI

    • Create meaningful and interactive visualizations

    • Use filters and slicers to explore data dynamically

    • Draw actionable insights from EV sales data

    • Make data-driven decisions to improve EV market strategies

     

    ❮ Previous Next ❯