Jumia Product Data Analyzed via Excel Dashboards to Uncover Pricing and Rating Trends

A data analysis project examined Jumia's e-commerce product dataset, focusing on pricing, discounts, customer reviews, and ratings using Microsoft Excel. The dataset was first cleaned by removing duplicates, correcting data types, and standardizing formatting before analysis began. New calculated columns were added to categorize products by discount level, price range, and rating quality. Correlation analysis using Excel's CORREL function revealed that high discounts do not necessarily drive greater customer engagement or better ratings. The resulting pivot-table-based dashboards showed that highly rated products tend to be lower-priced, though this pattern was not universal across all product categories.