Dev iconDevSep 19, 2026 ~1 min source read

Jumia Product Analysis WithExcel Dashboards

Introduction Big E-commerce organisation like Jumia handle large datasets that are vital in the day-to-day operations. The average customer rating of the product out of 5 Data Cleaning Before any analysis could be done on the dataset, I had to clean the data for the mistakes that were done during data entry.

Jumia Product Analysis WithExcel Dashboards

Share this story

Send the public story page.

Useful takeaways from this story.

Introduction Big E-commerce organisation like Jumia handle large datasets that are vital in the day-to-day operations.

The data needs to be evaluated to make good and decisive business decisions that will improve overal business perfomance.

The average customer rating of the product out of 5 Data Cleaning Before any analysis could be done on the dataset, I had to clean the data for the mistakes that were done during data entry.

Building the complete brief

The page is ready to read now. The fuller skim-friendly version will appear here automatically.

The useful part

Introduction Big E-commerce organisation like Jumia handle large datasets that are vital in the day-to-day operations. The data needs to be evaluated to make good and decisive business decisions that will improve overal business perfomance. For this article I will take you through the process of building a comprehensive product analysis and dashboards that will guide smarter business decisions.

How it works

  • The average customer rating of the product out of 5 Data Cleaning Before any analysis could be done on the dataset, I had to clean the data for the mistakes that were done during data entry.
  • This are the steps that i did towards effective data cleaning 1) The first step i did was to copy the data to a new worksheet then renamed it "Cleaned" and renamed the other worksheet as "original" <img...
  • To produce excel dashboards that provide insights into the perfomance of products.
  • To analyze product pricing, discounts, customer reviews and ratings to understand product perfomance and identity trends.

Details worth keeping

The current seeling price of products in (Ksh) Old price. The original price before discount in (Ksh) Discount. The percentage discounts offer on the products Review.

Keep reading in the app

Open the app view to save this story, compare related coverage, and continue from the same source.

Open in app