BenardGabriel/Nigeria-Car-Market-Analysis-

# Nigeria-Car-Market-Analysis- ### Project Overview The Nigerian automotive market is one of the largest in Africa, with millions of vehicles being traded every year. A significant percentage of cars are imported, and the preferences of buyers vary across brands, models, colors, and performance metrics. This project seeks to provide data-driven insights into the Nigerian car market using a Power BI dashboard that highlights: * Average vehicle metrics such as price, mileage, horsepower, and engine size. * Popularity of car brands and models across Nigeria. * Color preferences among Nigerian car buyers. * Driver transmission choices (Automatic vs. Manual). * Market segmentation between brand new, foreign used (Tokunbo), and Nigerian used cars. This analysis is intended to serve stakeholders including car dealers, importers, policymakers, and buyers who require deeper market intelligence to make better-informed decisions. ### Problem Statement The Nigerian car market, while vibrant, suffers from information asymmetry. Buyers often face uncertainty regarding pricing, mileage, performance, and long-term value of vehicles, while sellers and importers struggle to align inventory with buyer preferences. * Some of the challenges include: * Lack of reliable market averages for price, mileage, and engine performance. * Limited knowledge about consumer preferences for brand, color, and transmission type. * Heavy reliance on foreign imports without proper market segmentation insights. * Policymakers lacking sufficient data-driven evidence to regulate vehicle importation and promote sustainable alternatives. This project addresses these issues by building a comprehensive market analysis dashboard, backed by real vehicle data, to uncover trends and recommend strategies for key stakeholders. ### Data Structure The dataset used was compiled from Car45.com (a vehicle marketplace in Nigeria). The structure includes the following: Description, Amount (₦), State, City, …