Building an Interactive Excel Dashboard for E-commerce Product Analysis: A Case Study of Jumia Products.
1. Project Introduction and Objective In this project, I used Microsoft Excel and Power Query to clean and analyze a Jumia product dataset and then built an interactive dashboard to summarize pricing, discounts, ratings and customer engagement. The main objective was to turn a small raw e-commerce dataset into useful business information. I wanted the final dashboard to answer practical questions…
This project aimed to transform a raw Jumia product dataset into a useful business report using Microsoft Excel and Power Query. The primary objective was to answer questions like whether products with higher discounts generate more customer engagement and if higher-priced products have better ratings. The dataset, containing 115 rows and 6 columns, posed several data quality issues, which were addressed during the cleaning process.
The cleaned dataset consisted of 112 records, with 57 having complete rating and review information. After cleaning, Excel formulas were used to create analytical categories and flags, such as Discount Amount, Rating Category, Discount Category, Price Category, Engagement Flag, and Performance Flags. These flags helped identify products with high review engagement, low ratings, and potential issues due to high discounts but low ratings.
The project provided practical experience in data cleaning, Excel formulas, PivotTables, PivotCharts, slicers, correlation analysis, and dashboard design.
Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.
