Blinkit Sales & Profitability Analysis
💰 Analyzed $1.2M+ sales across
8,523 transactions
📊 Identified key revenue drivers & profitability gaps
📈 Delivered actionable insights for category and outlet optimization
Developed an end-to-end Excel analytics solution covering data cleaning, transformation, and dashboard development to evaluate business performance across products, outlets, and locations.
Key Insights at a Glance
- 💰 Total Sales: $1.2M+
- 📦 Transactions: 8,523
- 🏬 Top Performer: Tier 3 outlets
- 📊 Focus: Category profitability & outlet segmentation
Tools Used
Excel
Data Cleaning
Pivot Tables
KPI Dashboard
Access Excel File & Project Summary Pdf
Dashboard Overview
📊 Interactive dashboard highlighting sales trends, outlet performance, and category insights.
Business Problem
Blinkit requires visibility into which products, outlet types, and locations drive revenue to improve operational efficiency and maximize profitability.
Key Insights
- 📈 Tier 3 outlets contribute 40%+ revenue
- 📊 Few categories dominate total sales
- 🏪 Medium & large outlets drive higher average sales
- ⚠️ Some high-sales categories have lower efficiency
Business Impact
- 🚀 Identified high-performing outlet segments for expansion
- 💡 Highlighted top revenue-driving product categories
- 📉 Detected inefficiencies affecting profitability
- 🎯 Enabled data-driven decisions for inventory & pricing
Recommendations
- 🚀 Expand Tier 3 outlet presence
- 💰 Optimize product mix for better margins
- 📉 Improve low-efficiency categories
What I Learned
- Transforming raw data into business insights
- Importance of data cleaning in analytics
- Designing dashboards for decision-making