Blinkit Sales Analysis

Analyzing 8,500+ retail records to uncover revenue drivers, outlet strategy signals, and product performance patterns.

MySQL Window Functions CTEs Stored Procedures Tableau
$1.2M
Total Revenue
8,523
Records Analysed
65%
Type1 Revenue Share
42%
Medium Outlet Sales

Project Files

Key Visuals

Sales by item type bar chart
Sales by item type
Outlet size contribution chart
Outlet size contribution
Outlet type revenue chart
Outlet type revenue

Key Insights

Outlet Strategy

Supermarket Type1 is a concentration risk

Driving 65% of total revenue from one outlet type creates vulnerability. Medium outlets show stronger sales efficiency and should anchor expansion plans.

Product Mix

Low Fat demand is a consistent signal

Low Fat products outperform Regular across categories — this is a procurement signal to shift shelf allocation, not a one-category anomaly.

Visibility

Placement alone doesn't drive sales

Low-visibility products still generate strong revenue, suggesting product type and price point matter more than shelf placement optimization.

Ratings

Customers aren't buying on ratings

Medium-rated products outsell high-rated ones, pointing to habit and availability as the real purchase drivers. A UX experiment on rating visibility is warranted.