Real life car service data analysis
Welcome to the Car Service Dashboard project! This repository features an in-depth Exploratory Data Analysis (EDA) in Python and a powerful interactive Power BI dashboard that provides valuable business insights into car sales, ownership, services, and trends.
Created by Abhijeet Kuanr.
The dataset (Master_car_table.csv) contains 1,000+ records with 25 columns, covering:
- 🔹 Vehicle Information: Brand, Model, Year, Color, Fuel Type, Transmission
- 🔹 Ownership Details: Owner Type, Purchase & Sale Years, City
- 🔹 Pricing: Price (New vs Sale), Sale Date
- 🔹 Services: Type, Cost, Center, Date
- 🔹 Insurance: Provider, Policy Number, Expiry Date
Python libraries used:
pandasfor data wranglingseaborn&matplotlibfor visualizationnumpyfor numerical operations
- Top Brands: Hyundai, Maruti, Renault
- Popular Fuel Types: Electric, Petrol, CNG
- Most Sales: Lucknow, Mumbai, Chennai
- Owner Type: Majority are first-hand cars
- Costliest Services: Brake Service > Oil Change > Full Service
An interactive Power BI dashboard was developed to visualize and drill down into:
- ✅ Total Cars Sold
- ✅ Total Sale Value (₹1.3M Lakh)
- ✅ Sales by Year
- ✅ Cars by Fuel Type, Transmission, Model
- ✅ Service Cost Insights
- Languages: Python (Jupyter Notebook)
- Visualization: Power BI Desktop
- Libraries:
pandas,matplotlib,seaborn,numpy - File Format:
.csv,.pbix,.ipynb,.png
car-data-analysis/ ├── 📈 PowerBI_Dashboard.pbix # Interactive dashboard ├── 📊 EDA_Car_Data.ipynb # Python EDA notebook ├── 📄 Master_car_table.csv # Original dataset ├── 📸 a5347473-...dashboard.png # Dashboard image └── 📘 README.md # Project documentation
- 🧑💻 GitHub: Abhijeet107
- 📧 Email: abhijeet.kuanr@gmail.com
- 💼 LinkedIn: linkedin.com/in/abhijeet-kuanr-6a2672160
#PowerBI #EDA #DataAnalytics #Python #Visualization #CarMarketInsights #BusinessIntelligence #DataScience