Introduction
In the highly competitive online grocery market, optimizing inventory management and sales strategies is essential for maintaining profitability and ensuring customer satisfaction. This case study focuses on analyzing the SKU (Stock Keeping Unit) data of four online grocery stores.
The goal is to extract valuable insights for the Commercial and Supply Chain teams, enabling them to make informed decisions that enhance operational efficiency and drive growth.
Dataset Description
The dataset comprises city-level data on inventory, sales, and waste for various SKUs across four online grocery stores. The key metrics included in the dataset are:
- Unique SKUs Listed: The total number of unique SKUs that were active and visible in the app.
- Unique SKUs Sold: The total number of unique SKUs that had at least one sold item within the period.
- # of Sold SKU Items: The total number of all sold SKU items within the period.
- Sales Value Before Discount (EUR): The total sales value of all sold SKU items before any discounts.
- User Discount Value (EUR): The total discount value for sold SKU items.
- Total COGS for Sold Items (EUR): The total cost of purchase of all sold SKU items from the suppliers.
- Waste, # of Items: The total number of SKU items written off due to expiration.
Click here to access the dataset.
Objectives
The primary objectives of this case study are:
- To analyze sales performance and identify trends in SKU sales.
- To evaluate inventory management efficiency and identify opportunities for improvement.
- To analyze waste trends and determine the financial impact of expired items.
- To provide actionable recommendations for optimizing sales strategies, reducing costs, and enhancing overall operational efficiency.
Tools Required
To analyze this dataset and create an interactive dashboard, the following tools will be utilized:
- Power BI or Tableau
- Excel
Task
Based on the given data create an intuitive and insightful dashboard using Power BI or Tableau. The dashboard should help visualize the key metrics and provide clear insights into sales performance, inventory efficiency, and waste management.
This case study provides a foundation for analyzing the SKU data and deriving meaningful insights that can help improve the operational efficiency and profitability of online grocery stores. The analysis will enable the Commercial and Supply Chain teams to monitor key metrics, identify trends, and make data-driven decisions to optimize operations.
