Jumia Product Performance and Analysis.

Jumia, a prominent African e-commerce platform, manages millions of transactions across various product categories, including electronics and beauty products. To optimize supply chain operations and profit margins, it is crucial to track key performance indicators (KPIs). The objective of this project is to create an interactive Excel dashboard using Jumia's transactional data, transforming disorganized information into a user-friendly interface to aid decision-making, identify trends, and monitor product performance.

The dataset used for this project contains inconsistencies and errors that could potentially lead to inaccurate results. To ensure an effective output, the data must be cleaned and prepared. Initial steps include formatting prices from text to currency format and correcting any discrepancies, such as converting old prices to new prices by calculating the difference.

Additionally, categorizing price ranges into high, low, or medium involves using logical functions like IF and AND, or OR, depending on the specific conditions that need to be met.

After eliminating duplicate entries and inconsistencies, such as texts in number columns, the dataset is deemed clean. An example of a clean dataset is presented in the provided source. Various descriptive analyses are performed to derive meaningful insights from the data. For instance, the average current price of products is calculated using the AVERAGE formula, while the average old price is determined using the same formula on the old price column.

To obtain the number of products, the COUNTA function is employed, as they are stored in text format. The average product ratings are calculated using the AVERAGE function, and the total number of reviews is determined with the COUNT function.

Furthermore, the project utilizes MIN() and MAX() formulas to identify the least expensive and most expensive products, respectively. Pivot tables and charts are incorporated into the dashboard to display the filtered data and support decision-making. Slicers, interactive buttons that filter data and display the applied filters, are also included as examples. Finally, the dashboard presents key performance indicators (KPIs) to translate and evaluate the data, providing a clear understanding of Jumia's product performance.