AutoMarket360 is an interactive Power BI dashboard designed to analyze automotive market data and uncover key insights related to pricing, mileage, fuel types, transmission types, and vehicle conditions.
This dashboard provides a comprehensive view of market trends, helping stakeholders understand car listings, pricing behavior, and distribution patterns across multiple dimensions.
The objective of this project is to:
- Analyze listed car market trends\
- Monitor average price fluctuations over time\
- Understand fuel type and transmission distribution\
- Evaluate vehicle condition breakdown\
- Identify top car manufacturers in the market
Metric Value
Total Listed Cars 23K Average Price 46.04K € Average Mileage 71.33K Accident Free Cars 19.28%
- Top Car Makers by Listing Count\
- Brand-wise market presence comparison
- Average Price by Year\
- Historical price fluctuation analysis\
- Identification of price growth trends
- Count of Cars by Fuel Type (Diesel, Electric, Hybrid, Gasoline, Petrol)\
- Transmission Type Distribution (Automatic vs Manual)\
- Vehicle Condition Breakdown (New, Like New, Used)
- Count of Car Models by Color\
- Mileage distribution\
- Condition-based segmentation
- Transmission Filter\
- Condition Filter\
- Fuel Type Filter\
- Dynamic slicers for interactive exploration
- Power BI Desktop\
- DAX (Data Analysis Expressions)\
- Power Query (Data Cleaning & Transformation)\
- Data Modeling & Relationships\
- KPI Cards & Advanced Visualizations
- Diesel and Electric vehicles show strong representation in listings.\
- Automatic and Manual transmissions have nearly equal market presence.\
- Used cars dominate overall listings compared to new vehicles.\
- Average car price shows a significant upward trend in recent years.\
- Premium brands like Rolls-Royce and McLaren lead in high-value listings.
AutoMarket360-Dashboard
│
├── AutoMarket360_Dashboard.pbix
├── dataset.csv
├── dashboard_preview.png
└── README.md
- Download the
.pbixfile from this repository. - Open it using Power BI Desktop.
- Use slicers to filter by fuel type, transmission, and condition.
- Explore pricing trends and market distribution insights.
- Add price prediction using machine learning\
- Implement market segmentation analysis\
- Add geographic region-based insights\
- Publish dashboard to Power BI Service\
- Embed dashboard into a web application
Tej Pratap
Data Analyst | Business Intelligence Enthusiast | Automotive Analytics
Explorer