The latest articles on DEV Community by Nidhi J Poojary (@nidhi_poojary_0212). https://dev.to/nidhi_poojary_0212 https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4156897%2F24084daa-373a-432c-9d91-99e82e187f85.jpg https://dev.to/nidhi_poojary_0212 en Nidhi J Poojary Fri, 02 Oct 2026 09:15:26 +0000 https://dev.to/nidhi_poojary_0212/jumia-product-data-analysis-using-excel-1b5f https://dev.to/nidhi_poojary_0212/jumia-product-data-analysis-using-excel-1b5f <h2> Overview </h2> <p>I completed a product data analysis project using Excel based on Jumia product listings.</p> <p>The project focuses on cleaning the dataset, analysing pricing, discounts, reviews and ratings, and creating a simple dashboard to present the findings.</p> <h2> What I Did </h2> <ul> <li>Cleaned and prepared 109 unique product listings</li> <li>Removed duplicate records and cleaned inconsistent data</li> <li>Analysed prices, discounts, reviews and ratings</li> <li>Created calculated categories and summary statistics</li> <li>Built analysis tables and a dashboard in Excel</li> </ul> <h2> Key Insights </h2> <ul> <li>Average current price: 1,208.26</li> <li>Average discount: 36%</li> <li>Average rating: 3.88</li> <li>Budget products formed the largest price category</li> <li>High-discount products formed the largest discount category</li> </ul> <h2> Tools </h2> <p>Microsoft Excel</p> <h2> Project </h2> <p>You can view the complete Excel project and dashboard on GitHub:</p> <p>[GitHub Project]<br> <a href="https://github.com/poojarynidhi-pixel/Jumia-product-data-analysis" rel="noopener noreferrer">https://github.com/poojarynidhi-pixel/Jumia-product-data-analysis</a></p> beginners dataanalysis excel