BlinkIt Dashboard
Comprehensive Sales Analysis and Performance Optimisation
OBJECTIVE
The dashboard visualizes year-wise sales data for Blinkit, focusing on various aspects such as outlet locations, item categories, and sales distribution. The primary business challenge addressed by this dashboard is optimizing the performance of outlets across different regions and item categories. This includes:
- Identifying trends in sales and discounts across regions and item categories.
- Analyzing outlet performance based on tier and size.
- Understanding the regional distribution of sales and availability of item categories to ensure efficient inventory management.
- Strategizing marketing efforts to boost sales in underperforming categories or regions.
The insights derived from the dashboard can guide management in improving supply chain efficiency, increasing regional sales, and offering competitive discounts tailored to customer preferences.
DATA UNDERSTANDING
Key columns in the dataset and their relevance to the dashboard include:
- Outlet-Level Data:
- Outlet_Identifier: Unique ID for each store.
- Outlet_Size: Outlet sizes (Small, Medium, Large).
- Outlet_Location_Type: Tier classifications (Tier 1, 2, or 3).
- Outlet_Region: Central, East, North, South, West.
- Item-Level Data:
- Item_Type: Type of items (Snacks, Frozen Foods, etc.).
- Item_Category: High-level categories like Household, Dairy, etc.
- Item_Visibility: Availability percentages for items.
- Sales and Discount Data:
- Total_Sales: Sales value for the year.
- Discount: Discounts offered across categories.
Understanding the relationships among these data points helps analyze trends in sales and the influence of discounts on different categories.
