This project leverages Power BI to analyze and visualize bike sales data across India. It aims to uncover key insights related to mileage, resale value, depreciation, fuel efficiency, and regional trends to support informed decision-making for buyers, sellers, and market analysts.
- Clean, transform, and model bike sales data
- Build an interactive Power BI dashboard for data exploration
- Calculate custom metrics like Efficiency Score and Resale Score
- Visualize trends based on brand, model, region, and ownership
- Power BI Desktop
- Power Query Editor
- DAX (Data Analysis Expressions)
- Microsoft Excel/CSV (Data Source)
- 📍 Brand & Model level filters with drill-downs
- 📈 Sales, depreciation & mileage trends
- 🎯 Efficiency and resale score gauges
- 🗺️ Geographic analysis by Indian states
- 📋 KPI cards for dynamic metrics
The dataset includes:
- Brand & Model
- Engine Capacity (CC)
- Mileage
- Price & Resale Price
- Year of Manufacture
- Fuel Type & Ownership Type
- Insurance, Location, and more
🔸 Source: CSV file with ~2,900 records
🔸 Scope: Covers used bikes across various Indian states
Efficiency Score = Mileage / Engine CapacityDepreciation = Price - Resale PriceResale Score = Resale Price / Original Price- Average metrics by Brand, Model, and Region
- Live data integration from dealer portals
- Predictive modeling for price trends
- Expansion to electric bikes and scooters
- Integration with online listing platforms
This project strengthened practical knowledge in:
- Data modeling and transformation in Power BI
- Creating custom DAX measures for dynamic insights
- Building intuitive dashboards with drill-downs and slicers
- Applying business intelligence to real-world automotive data