Building an Interactive Excel Dashboard for E-commerce Product Analysis: A Case Study of Jumia Products.

Introduction In this project, I set out to analyze a dataset of products listed on Jumia, one of Africa's leading e-commerce platforms, with the goal of understanding how pricing strategies, discounts, and customer reviews influence overall product performance. Using Microsoft Excel, I cleaned and prepared the raw dataset, engineered new features to categorize products, ran correlation and trend analyses to uncover relationships in the data, and ultimately built an interactive dashboard to present the findings in a clear, business friendly format. The objective was not just to explore the numbers, but to answer practical business questions: Do bigger discounts actually drive more customer engagement? Does price influence how a product is rated? Which products are genuinely performing well, and which ones might need a different pricing or marketing approach? This article breaks down the full process behind how I turned raw data into a finished report from initial data clea