andyababio/Jiji-Cars-Analysis

This project provides an end-to-end analytical exploration of the car listings section on Jiji.com, an African online marketplace. The workflow includes web scraping, data cleaning, and transformation using Python and MySQL, followed by interactive data visualization and insights generation in Power BI. # JIJI CARS MARKETPLACE ANALYSIS & INSIGHTS ## Introduction Jiji.com is a leading African online marketplace that connects buyers and sellers across a wide range of products and services. This project focuses specifically on the Car Listings section, aiming to uncover patterns in pricing, demand, and market dynamics. The goal was to analyze car advertisement data to identify key insights such as popular car brands (make & model), pricing trends, and regional performance etc. ## Process Flow ◻ **Webscraping (Python)** - Extracted car listing data from Jiji.com using Scrapy. - Collected fields such as make, model, year, condition, mileage, region, price, and listing date. - Consolidated the extracted data into a structured CSV file for further analysis. - See script here. ◻ **Data Preparation (MySQL)** - Performed data cleaning, transformation, and normalization using MySQL. - Built relational tables (Fact & Dimension) to ensure consistency and efficient querying. - Created a robust data model to support Power BI integration and analytics. - See script here. ◻ **Data Analysis & Visualization (Power Bi)** - Imported the prepared dataset into Power BI for exploration and visualization. - Designed an interactive dashboard using DAX measures for KPIs and advanced calculations. - Delivered insights through visual storytelling — enabling users to interact with filters, explore trends, and understand performance drivers. - Interact with dashboard here ## Data Overview 🟥 Fact Table: - listing_id - make_id - model_id - region_id - color_id - condition_id - transmission_id - is_boost - paid_info_text - year_of_manufacture - second_condition - interior_color - mileage - registered_car - exchange_possible - price_value - url - date_created 🟥 Dim model - Model id - Make id - Model name 🟥 Dim make - Make id - Make name 🟥 Dim color - Color id - Color name 🟥 Dim condition - Condition id - Condition name 🟥 Dim transmission - Transmission id - Transmission type 🟥 Dim …