Skip to content

An interactive Power BI dashboard analyzing Blinkit’s sales, outlets, and items. With $1.20M sales, 8523 items, and 3.9 ratings, it highlights top categories, outlet performance, and trends, enabling stakeholders to make informed, data-driven business decisions.

Notifications You must be signed in to change notification settings

aishureddy1789/Blinkit-Analysis-Dashboard

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 

Repository files navigation

📊 Blinkit Sales Analysis Dashboard (Power BI)

📌 Project Overview

This project presents a detailed Sales Analysis Dashboard for Blinkit - India's Last Minute App, created using Power BI.
The dashboard provides insights into sales performance, outlet distribution, item sales, and customer ratings to help business stakeholders make data-driven decisions.


🚀 Key Features & Insights

  • Total Sales: $1.20M
  • Average Sales per Item: $141
  • Number of Items: 8,523
  • Average Rating: 3.9 ⭐

🔍 Analysis Highlights:

  • Sales Breakdown by Fat Content:

    • Low Fat: $425.36K
    • Regular: $776.32K
  • Top Performing Categories:

    • Fruits & Vegetables: $0.18M
    • Snack Foods: $0.18M
    • Household Items: $0.14M
  • Sales by Outlet Location:

    • Tier 3: $472.13K
    • Tier 2: $393.15K
    • Tier 1: $336.40K
  • Sales by Outlet Size:

    • High: $507.90K
    • Medium: $444.79K
    • Small: $248.99K
  • Outlet Type Performance:

    • Supermarket Type1: $787.55K (highest sales)
    • Grocery Store: $151.94K
    • Supermarket Type3: $130.71K
    • Supermarket Type2: $131.48K
  • Trend Over Years:

    • Sales peaked in 2018 at $205K before stabilizing in subsequent years.

📂 Files Included

  • Blinkit_Sales_Analysis.pbix → Power BI dashboard file
  • data.csv → Dataset used for analysis
  • README.md → Project documentation

🛠️ Tools & Technologies

  • Power BI → Dashboard creation & visualization
  • Excel / CSV → Data cleaning & preprocessing
  • DAX Queries → Data modeling & calculations

📈 Business Use Case

This analysis helps Blinkit to:

  • Identify top-selling product categories.
  • Optimize outlet performance by size & location.
  • Track sales trends over time.
  • Understand customer preferences (Fat content, product categories).

About

An interactive Power BI dashboard analyzing Blinkit’s sales, outlets, and items. With $1.20M sales, 8523 items, and 3.9 ratings, it highlights top categories, outlet performance, and trends, enabling stakeholders to make informed, data-driven business decisions.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors