🏍️ Indian Bike Resale Analysis - Power BI Dashboard

This project presents a detailed analysis of the Indian bike resale market using Power BI. It explores trends, pricing patterns, and insights to help buyers and sellers understand factors influencing resale prices.

---

📊 Dashboard Overview

The Power BI dashboard includes the following visuals and KPIs:

🔹 Key Performance Indicators (KPIs)

• Total Bikes Analyzed
• Average Resale Price (INR)
• Average Mileage (km/l)
• Average Engine Capacity (cc)

🔹 Visualizations

• Bar Chart: Resale Price by Brand
• Scatter Plot: Engine Capacity vs Resale Price (with trend line)
• Line Chart: Year of Manufacture vs Average Resale Price
• Pie Chart: Fuel Type Distribution
• Table: Top 10 Expensive or High-Mileage Bikes

---

📁 Files in This Repository

File Name	Description
Bike_Sales_Analysis.pbix	Power BI dashboard file
cleaned_bike_sales.xlsx	Cleaned dataset used in the dashboard
screenshot.png	Optional: add screenshot of your dashboard here

---

⚙️ Tools Used

• Power BI
• Python (Pandas, Seaborn) – for data cleaning and initial EDA
• Excel – for initial dataset organization

---

🔍 Insights Derived

• Brands like Honda, Bajaj, and Royal Enfield show consistent resale value.
• Higher engine capacity generally leads to higher resale price.
• Fuel type preference shows majority inclination toward petrol bikes.
• Older bikes (before 2015) tend to have significantly lower resale value.

---

📌 How to Use

1. Download the .pbix file and open it in Power BI Desktop.
2. Explore interactive filters, visuals, and insights.
3. Modify or refresh the dataset using your own data if needed.

---

📬 Contact

For feedback, collaborations, or questions, feel free to connect with me on www.linkedin.com/in/appuanand or email me at appu12anand@gmail.com.

---