TahaEmad90/-Egypt-Used-Car-Market-Analysis-2024-Excel-Dashboard

# 🚗 Egypt Used Car Market Analysis 2024 – Excel Dashboard ## 📌 Project Overview This project analyzes the Egyptian used car market using **Microsoft Excel** to uncover market trends, pricing patterns, vehicle characteristics, and listing behavior. The analysis is based on **20,783 used car listings** and focuses on understanding the market through pricing, mileage, model year, manufacturer, location, vehicle features, and data-driven ratings. An interactive Excel dashboard was developed to provide both a **Market Overview** and **Detailed Insights** for exploring the used car market from different perspectives. --- ## 🎯 Business Objectives The main objectives of this analysis are to: - Evaluate the overall used car market using key KPIs. - Analyze used car price distribution. - Understand the impact of vehicle age and mileage on price. - Identify the most common manufacturers and car models. - Analyze market activity across Egyptian cities. - Compare automatic and manual transmission listings. - Analyze the availability of key car features. - Identify the most common car colors. - Evaluate car listings using a data-driven rating score. - Identify pricing patterns across manufacturers. - Generate actionable business insights from the market data. --- ## 🗂️ Dataset The dataset contains **20,783 used car listings** from the Egyptian market. ### Main Fields | Field | Description | |---|---| | `Full Name` | Full car listing name | | `Car Model` | Car model information | | `Manufacturer` | Car manufacturer | | `Model` | Vehicle model | | `Model Year` | Manufacturing/model year | | `Age` | Vehicle age | | `Model Year Category` | Age-based vehicle classification | | `Price` | Car price in EGP | | `Price Range (EGP)` | Price segmentation | | `Color` | Car color | | `Mileage` | Vehicle mileage | | `Mileage Categories` | Mileage classification | | `City` | Listing location | | `Date Displayed` | Listing date | | `Automatic Transmission` | Transmission type …