Skip to content

AchyuthaRavula/blinkit-business-insights

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 
 
 

Repository files navigation

🛒 10-Minute Magic

Data-Driven Insights into Blinkit’s Quick Commerce Model

📌 Project Overview

Blinkit (formerly Grofers) is a leading quick commerce platform in India, delivering groceries and essentials within 10–15 minutes using a hyperlocal dark-store model. While ultra-fast delivery has transformed customer expectations, it also introduces challenges related to logistics efficiency, marketing effectiveness, customer retention, and profitability.

This project analyzes Blinkit’s sales, customer behavior, delivery performance, and marketing data to understand how urgency-based campaigns and delivery speed influence:

  • Conversions
  • Impulse buying
  • Customer retention
  • Revenue optimization

The analysis combines business analytics and data visualization to generate actionable insights for quick commerce strategy.


🎯 Objectives

The primary goal of this project is to evaluate how Blinkit’s operational and marketing strategies drive customer behavior and business outcomes.

Key Objectives

  • Assess the effectiveness of urgency-based marketing campaigns (e.g., flash sales)
  • Analyze the impact of ultra-fast delivery on impulse purchases and basket size
  • Measure how delivery lead time affects retention, repeat purchases, and revenue per user
  • Compare performance across metro and non-metro regions
  • Translate insights into business recommendations

📊 Dataset

  • Source: Blinkit Sales Dataset (Kaggle)
  • Time Period: January 2023 – December 2024
  • Geographic Scope: Urban and semi-urban regions across India
  • Data Coverage:
    • Customer behavior & order history
    • Delivery lead times
    • Inventory movement
    • Marketing & urgency campaigns
    • Product category metadata

📁 Dataset details are documented in data/README.md


🧠 Methodology

  • Data cleaning and aggregation for visualization
  • Feature engineering for:
    • Impulse buying trends
    • Cart abandonment recovery
    • Lead time vs retention
  • Exploratory and comparative analysis
  • Business-focused storytelling using Tableau dashboards
  • Iterative refinement based on peer review feedback

📈 Key Insights & Findings

  • Urgency campaigns (flash sales, limited-time offers) increased conversions among cart abandoners by up to 2.3%
  • Ultra-fast delivery (<15 minutes) led to:
    • Higher order frequency
    • Larger basket sizes
    • Increased impulse purchases
  • Shorter delivery lead times significantly improved:
    • Customer retention
    • Repeat purchase rates
    • Revenue per user
  • Metro regions showed the strongest response, while non-metro areas demonstrated untapped growth potential

🎨 Visualization & Design Principles

  • Applied Tufte’s data-ink ratio to reduce clutter
  • Used Cole Nussbaumer Knaflic’s storytelling framework
  • Each dashboard directly answers a specific business question
  • Peer feedback helped:
    • Improve chart clarity
    • Align visuals with research questions
    • Strengthen narrative flow

📊 Interactive Tableau Dashboard

An interactive Tableau Story was created to communicate insights clearly and effectively.

🔗 View Tableau Dashboard:
https://public.tableau.com/app/profile/achyutha.ravula/viz/BlinkitBusinessInsightsCustomerTrendsMarketingPerformanceInventoryOptimization_17674348686660/10-MinuteMagicData-DrivenInsightsintoBlinkitsQuickCommerceModel


💡 Business Recommendations

  • Leverage urgency marketing to recover abandoned carts
  • Optimize delivery routing to maintain sub-15-minute lead times
  • Expand quick commerce penetration in non-metro markets
  • Use lead-time insights to improve customer lifetime value
  • Explore AI-driven personalization and routing for future scalability

⚠️ Limitations & Future Work

Limitations

  • Lack of real-time delivery data
  • Incomplete campaign-level tracking
  • Limited behavioral granularity

Future Enhancements

  • Integrate real-time delivery and demand signals
  • Explore AI-based routing and demand forecasting
  • Extend analysis to supplier-side and inventory optimization

⭐ Why This Project Matters

This project demonstrates how data-driven decision-making can optimize marketing, logistics, and customer experience in quick commerce, offering practical insights for businesses operating in high-speed, high-expectation markets.

About

Business analytics & data visualization project analyzing Blinkit’s quick commerce model-delivery speed, urgency marketing, customer behavior, and revenue insights using Tableau.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors