joshuaochuko4-cyber/car-sales-analytics-dashboard-excel

Built a Car Sales Analytics Dashboard in Excel analyzing used vehicle listings across Nigeria. Used Pivot Tables to uncover top models, pricing trends, and state-level distribution. Average price: ₦4.9M across all listings. Tools: Excel · Pivot Tables · Data Visualization # car-sales-analytics-dashboard-excel Built a Car Sales Analytics Dashboard in Excel analyzing used vehicle listings across Nigeria. Used Pivot Tables to uncover top models, pricing trends, and state-level distribution. Average price: ₦4.9M across all listings. Tools: Excel · Pivot Tables · Data Visualization # 🚗 Car Sales Analytics Dashboard ### Built with Microsoft Excel | By Isah Joshua , , --- ## 📌 Project Overview Designed and developed an interactive Car Sales Analytics Dashboard in Excel to analyze vehicle pricing, sales distribution, and market trends across Nigerian states and cities. --- ## ❓ Problem Statement The used car market generates large volumes of transactional data that is difficult to interpret without structured analysis. This project transforms raw car listing data into a clear, interactive dashboard that supports pricing and market decisions. --- ## 🎯 Objective To analyze used car sales data and uncover insights around pricing patterns, top-selling models, geographical distribution, and vehicle conditions across Nigeria. --- ## 🛠️ Tools Used - Microsoft Excel - Pivot Tables - Data Cleaning & Transformation - Data Visualization & Dashboard Design --- ## 🔧 Data Preparation & Cleaning - Cleaned raw car listings dataset in Excel - Handled missing values across key columns - Standardized data types for numerical and categorical fields - Structured data model to support pivot table analysis --- ## 📐 Data Modeling & Analysis - Built Pivot Tables to summarize sales by model, state, and condition - Calculated Average Selling Price and Average Horsepower - Analyzed Top 10 Car Models by count - Mapped geographical distribution across Nigerian states --- ## 📈 Dashboard Features - **KPI Summary** — Average price and horsepower metrics - **Top 10 Car Models** — ranked by volume - **State Distribution** — sales count by Nigerian state - **Vehicle Condition Analysis** — Foreign Used vs Nigerian Used - **Interactive Slicers** — dynamic filt …