Introduction Jumia is one of Africa's leading e-commerce platform that manages millions of transcations with a diverse products from electronics,beauty products and many more categories.Therefore,tracking key perfomance indicators is essential for supply chain operatios and profit optimization Objective My project aim is to build an interactive excel dashboard using Jumia transactional data.I aim to convert disorganized data into an interface that can help in decison making,identify trends and monitor products. Dataset description Data Cleaning and preparation process Raw data mostly contains inconsistency and errors that may occur that may interfere or give the wrong output. An example of a raw dataset In the example above we can see inconsistent and missing data that we need clean in order to have an effective output. First step is to format the prices from text to currency format and replace the before since excel will in order to calculate the discount eg below The image above is the discount price which was obtained by finding the difference between the old price and the new price. The image below is an example of the formula to categorize the prices whether high,low or medium.I used the IF,AND functions.Another example of a logical combination would be the us of OR. The difference when using the IF(AND function is that all the conditions must be met while in the IF(OR,only one condition has to be met. In the image below i used logical combination of that are IF and ANDfor the discount category. In the image below i also used the IF AND functions to in the ratings category. After removing duplicates,removing inconsistent data eg texts in numbers columns.Below is an image of the cleaned version of the Jumia dataset. An example of a clean dataset Descriptive Analysis To calculate the average current price of products i used the average formula and highlighted the cells eg =AVERAGE(B2:B113).The average old price of products was obtained by the same formula but now on the old price column =AVERAGE(D2:D113) To calculate the number of product since they are in text format we will use =COUNTA(A2:A113) To calculate the average product ratings we will use =AVERAGE( We use the count function to calculate the total number of reviews. We will use the MIN() and MAX()Formulas to calculate the least expensive product and most expensive product respectively. Some of my pivot tables and charts include: Slicers are interactive buttons to filter data used to display the filters being applied. Examples of slicers i will use are above. Dashboard Analysis My dashboard that had the following KPIs(KPIs translates and evaluates data for better understanding) Conclusion This case study has explored how ratings,reviews,prices and large discounts do not guarantee for major sales instead,for a platform like Jumia, consistent product quality and customers values are more important.