Building an Interactive Excel Dashboard for E-commerce Product Analysis: A Case Study of Jumia Products
If you've ever wondered what actually happens between "I have a spreadsheet full of messy data" and "I have a dashboard I'd be proud to show someone," this article walks through that whole journey, step by step, using a real example. 1. Project Introduction and Objective Online stores discount things constantly. But here's a question that's easy to assume the answer to and actually get wrong:…
A case study of Jumia's e-commerce products illustrates how to build an interactive Excel dashboard. The project's objective was to create a dashboard that managers could trust and use for analysis. The dataset consisted of 116 rows and 6 columns with product information, current price, old price, discount, reviews, and ratings.
There were quality issues in the raw data, such as negative review counts, duplicates, and stored values in text format. The dataset underwent cleaning and preparation steps, including removing duplicates, converting text to numbers, and creating extra columns for rating status, calculated discount, rating categories, discount categories, price categories, engagement flags, and compound flags.
PivotTables were then used to create insightful visualizations, such as products with high discounts and low ratings, heavily reviewed but average ratings, and top 10 rankings by rating, reviews, and discount. The final dashboard included KPI cards and charts, revealing that 55.4% of products were heavily discounted, but bigger discounts did not necessarily attract more attention.
Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.
This story
This is one outlet's version. Read the fullest account.
