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 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.…
Jumia, a major e-commerce company, relies on large datasets to make informed, data-driven decisions for their business. The objective of this article is to demonstrate the process of building Excel dashboards that provide insights into product performance, with an emphasis on pricing, discounts, and customer reviews.
The dataset contains product information, such as name, current price (in Ksh), original price (in Ksh), discount percentage, customer reviews, and average ratings out of 5 stars. Before analysis can begin, the data must be cleaned and enhanced. This process includes copying the data to a new worksheet, capitalizing titles, converting numeric columns to the correct currency data type, removing duplicates, and adding new columns for discounted amount, rating category, discount category, and price category.
To analyze the data, the author created a new worksheet to display questions related to the project. They used the IF function to categorize ratings as excellent, average, or poor, as well as discount and price categories. Additionally, the author used the CORREL() function to analyze the relationship between product ratings and reviews, as well as between discounts and reviews.
Based on the analysis, the author drew several business insights and recommendations. Firstly, high discounts do not necessarily correlate with high customer engagements, as many discounted products have poor ratings. Secondly, highly rated products tend to have lower prices, but this is not always the case. Thirdly, improving quality assurance for low-rated products may help improve their ratings. Finally, enhancing the review process may lead to increased customer satisfaction and better insight into product performance.
In conclusion, this project highlights the importance of data analysis in making informed business decisions for e-commerce organizations like Jumia. Through the creation of Excel dashboards and thorough data analysis, companies can gain valuable insights into their products and make data-driven decisions to improve overall performance.
Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.
