Blinkit Sales Analysis Dashboard (Excel) -
Date
Service
Data Analytics
Client
Personal Project
Project Overview
Developed an interactive Excel dashboard to analyze Blinkit's sales performance, customer ratings, inventory distribution, and outlet performance. The dashboard enables stakeholders to monitor key business metrics and explore sales trends through interactive filters and visualizations, supporting data-driven decision-making.
Business Problem
Blinkit requires a centralized dashboard to evaluate sales performance across products, outlet types, outlet sizes, and geographic locations. The objective is to identify sales trends, measure customer satisfaction, understand inventory distribution, and uncover business opportunities using interactive data visualizations and key performance indicators (KPIs).
Dataset
Blinkit Sales Dataset Overview
Dataset: Blinkit Sales Dataset
Records: 8,523
File Format: Excel (.xlsx)
Industry: Retail / Grocery
Key Fields:
Item Type, Sales, Rating, Outlet Type, Outlet Size, Outlet Location, Fat Content, Establishment Year.
Tools Used
Microsoft Excel
Pivot Tables
Pivot Charts
Slicers
Data Cleaning
Project Methodology
Data Collection
Data Cleaning
Data Preparation
KPI Development
Pivot Table Analysis
Dashboard Design
Business Insights
Business Recommendations
Dashboard Overview
This interactive Excel dashboard provides a comprehensive view of Blinkit's sales performance through KPI cards, trend analysis, outlet comparisons, and product-level insights. Users can dynamically filter the data by Outlet Size, Outlet Location Type, and Item Type to explore business performance.
Key Highlights
Insights
• Total Sales reached $1.20M.
• Fruits & Vegetables generated the highest sales.
• Tier 3 outlets recorded the highest revenue.
• Medium-sized outlets outperformed other outlet sizes.
• Supermarket Type 1 generated the highest sales.
• Average customer rating is 4.0.
Recommendations
• Increase inventory for high-performing product categories.
• Expand operations in Tier 3 locations.
• Apply successful practices from Supermarket Type 1 to other outlet types.
• Improve customer satisfaction to increase ratings.
• Optimize product distribution across outlet sizes.
