Blinkit Sales & Inventory Dashboard

Overview

This project presents an interactive Blinkit Sales and Inventory Dashboard developed using Excel. The dashboard offers strategic insights into sales performance, customer satisfaction, and inventory trends, helping business stakeholders at Blinkit make data-backed decisions to enhance retail operations and profitability.

---

Dashboard Preview

---

Folder Structure

1. Dataset

Primary data source used for building the dashboard.

2. Excel File

Interactive Excel report containing all visuals and metrics.

3. Visual Assets

Custom images and icons used in the dashboard.

---

Features

• Key Metrics Tracked:

  • Total Sales
  • Average Sales
  • Number of Items
  • Average Rating

• Fat Content Analysis:

  • Total sales by fat content (Regular vs Low Fat)
  • Impact of fat content on average sales, item counts, and ratings

• Product Category Performance:

  • Total sales and item metrics by item type (e.g., Dairy, Snacks, Canned, etc.)

• Outlet-Level Insights:

  • Fat content breakdown by outlet
  • Sales by outlet size and location
  • Year-wise trend of outlet establishment and performance

• Outlet Type Analysis:

  • Detailed comparison of sales, item count, ratings across outlet types

---

Tools Used

• Excel:
  Dashboard creation and data visualization

• Microsoft Excel:
  Data preprocessing and transformation

• Custom Icons:
  For design enhancement and user-friendly UI

---

Files Included

• Blinkit Dashboard.xlsx: The Excel report file.
• Blinkit Dataset.csv: The dataset used for building visualizations.
• Icons and Images: Design assets used in the dashboard.

---

How to Use

1. Clone or download this repository.
2. Open the .xlsx file using Excel.
3. Use the filter panel and interactive visuals to explore key performance trends.

---

Insights

• Fat Content Impact:
  Regular fat items account for 65% of total sales, showing higher customer preference.

• Product Category Sales:
  Fruits & Vegetables, Snack Foods, and Household items are top-performing categories.

• Outlet Trends:
  Outlets established around 2018 showed peak performance in sales.

• Outlet Size Performance:
  Medium-sized outlets contribute the highest portion of total sales.

• Outlet Type Metrics:
  Supermarket Type 1 dominates in total sales and customer engagement metrics.