Skip to content

Designed a Power BI dashboard to analyze Blinkit’s $1.2M sales data, enabling outlet-level performance tracking, product category insights, and data-driven decision-making.

Notifications You must be signed in to change notification settings

apooorv19/blinkit-dashboard

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 

Repository files navigation

🛒 Blinkit Sales Analysis Dashboard

Blinkit - India's Last Minute App - has been visualized in this interactive Power BI dashboard to analyze outlet-level performance, product category trends, and customer preferences.


📊 Dashboard Overview

This Power BI dashboard provides a comprehensive overview of:

  • 🧾 Total Sales: $1.20M
  • 📦 Number of Items: 8,523
  • 💰 Average Sales per Item: $141
  • Average Customer Rating: 3.9

🔍 Key Visuals

  • Time Series Analysis of outlet establishment growth (2010–2022)
  • Sales by Outlet Location (Tier 1, 2, 3)
  • Sales by Outlet Size (Small, Medium, High)
  • Sales by Outlet Type (e.g., Grocery Store, Supermarket Type1/2/3)
  • Fat Content Breakdown: Low Fat vs Regular
  • Item Type Sales across categories like Fruits, Dairy, Snacks, etc.
  • Interactive Filters for Outlet Type, Size, Location, and Item Type

📌 Features

  • 📅 Yearly Trend of outlet establishment and performance
  • 🧭 Outlet Geography Analysis (Tier-based segmentation)
  • 🥫 Product Category Insights to track top-selling categories
  • ⚙️ Fully Interactive Filter Panel to dynamically update visuals
  • 🎨 Custom UI Design with Blinkit branding and color themes

🔧 Built With

  • Power BI Desktop
  • DAX for Measures & Calculated Columns
  • Interactive Slicers and Visual Filters

📷 Dashboard Preview

Blinkit Dashboard Preview


👤 Developed By

Apurva Mishra
🔗 LinkedIn 📧 For queries: apooorvmishra@gmail.com


📂 File Info

  • Blinkit Dashboard.pbix – Main Power BI dashboard file
  • Blinkit Dashboard.png – Dashboard preview image

🚀 Usage

  1. Open the .pbix file in Power BI Desktop
  2. Use the filter panel to explore various metrics and insights

📈 Insights Highlight

  • Tier 3 contributes the highest sales: $472K
  • Supermarket Type 1 leads with $787K+ sales
  • Regular fat products outperform low-fat in total sales
  • Fruits and Snacks are the most sold item categories

About

Designed a Power BI dashboard to analyze Blinkit’s $1.2M sales data, enabling outlet-level performance tracking, product category insights, and data-driven decision-making.

Resources

Stars

Watchers

Forks