Blinkit_Data_Analysis

KO | EN

gitlite — search

#react #ai #typescript #llm #go #docker #macos #nodejs #windows #kubernetes #vue #security #pytorch #openai

Blinkit_Data_Analysis

(★ 9)

A comprehensive end-to-end data analysis project using SQL, Python, Power BI, and Excel.

파일 탐색기

최종 버전 다운로드 (.zip)

Blinkit Analysis.ipynb
BlinkIt Dashboard.pdf
BlinkIT Grocery Data.xlsx
Blinkit Insights.pdf
BlinkIt.pbix
BlinkIt_SQL.sql
README.md

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# 🛒 Blinkit Grocery Sales Data Analysis

Welcome to the Blinkit Data Analysis project! This is a **real-world business intelligence case study** that uses **SQL, Python, Excel**, and **Power BI** to uncover valuable insights from Blinkit's grocery sales and outlet data. From sales patterns to customer ratings and outlet efficiency — this project covers it all!

---

## 📌 Objective

The main goal of this project is to **analyze Blinkit's sales data** to discover:

- 🔍 Patterns in customer purchasing behavior
- 📉 Underperforming categories or outlets
- 📈 Opportunities to improve revenue and efficiency

This project simulates how a data analyst would present data-driven recommendations to business stakeholders.

---

## 🧰 Tools & Technologies Used

| Tool       | Purpose                             |
|------------|-------------------------------------|
| **SQL**    | Data extraction, transformation, and aggregation |
| **Python** | Data cleaning, EDA (Exploratory Data Analysis) using Pandas and Matplotlib |
| **Excel**  | Initial data exploration and quick KPIs |
| **Power BI** | Interactive dashboard creation for KPI storytelling and visualizations |

---

## 📂 Dataset Summary

- **Items**: Various grocery products sold by Blinkit  
- **Sales**: Units sold, revenue generated  
- **Customer Ratings**: Based on purchase satisfaction  
- **Outlet Details**: Type, size, location, and year of establishment

> 📄 Format: Excel Workbook (.xlsx)

---

## 📊 Business Questions & KPI Requirements

Here are the key insights and metrics we aimed to extract:

### 🔸 1. Total Sales by Fat Content
- **Objective**: Analyze how fat content (Low Fat, Regular) affects total revenue  
- **KPIs**: Total Sales, Average Sales, Number of Items, Average Rating  
- **Chart**: Donut Chart (Power BI)

---

### 🔸 2. Total Sales by Item Type
- **Objective**: Identify which product categories contribute most to revenue  
- **KPIs**: Same as above  
- **Chart**: Bar Chart

---

### 🔸 3. Fat Content Sales across Outlets
- **Objective**: Compare total sales across different outlet types segmented by fat content  
- **Chart**: Stacked Column Chart

---

### 🔸 4. Total Sales by Outlet Establishment Year
- **Objective**: Explore how the outlet age impacts performance  
- **Chart**: Line Chart

---

### 🔸 5. Sales by Outlet Size
- **Objective**: Determine which outlet sizes generate the most revenue  
- **Chart**: Donut / Pie Chart

---

### 🔸 6. Sales by Outlet Location
- **Objective**: Discover the geographic distribution of Blinkit’s revenue  
- **Chart**: Funnel Map

---

### 🔸 7. All KPIs by Outlet Type
- **Objective**: Compare all KPIs (Sales, Ratings, etc.) across outlet types  
- **Chart**: Matrix Card

---

## 📌 Power BI Dashboard Overview

The final dashboard is built using **Power BI** and provides an **interactive and real-time view** of all the insights, including:

- Dynamic filters and slicers
- Drill-down capability for deeper analysis
- Clean UI with bold visuals and a logical flow

> ✅ Each chart answers a specific business question  
> 📊 KPIs are displayed in cards and matrix format for clarity  
> 🌐 Geographic visuals help identify location-based performance trends

---

## 🔍 Python EDA (Exploratory Data Analysis)

Using **Pandas and Matplotlib**, we:

- Handled missing values and duplicates
- Created grouped metrics like avg. sales and ratings
- Visualized trends and correlations in the dataset

---

## 📈 Excel Use

- Initial data validation and transformation
- Quick pivot tables for checking metrics
- Manual KPI calculations for cross-verification

---

## 🚀 Key Takeaways

- Leveraged multiple tools to simulate real-world BI workflow
- Gained business insights that can drive marketing and inventory decisions
- Built a compelling and easy-to-navigate dashboard for stakeholders
- Strengthened hands-on skills in data storytelling and BI presentation

---

## 📁 Project Structure

📦 Blinkit-Data-Analysis/
├── 📊 PowerBI Dashboard (Blinkit.pbix)
├── 🐍 Python Scripts (EDA.ipynb / analysis.py)
├── 📈 Excel Files (BlinkIT Grocery Data.xlsx)
├── 📄 Documentation (Insights.pdf, README.md)

---

## 🙋‍♀️ About Me

**Snehal Nalawade**  
💼 Aspiring Data Analyst | Passionate about BI and storytelling  
📧 snehalrnalawade2003@gmail.com 
📍 India

---

## 🙏 Thank You!

Blinkit_Data_Analysis

파일 탐색기

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Blinkit_Data_Analysis

파일 탐색기

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README