← back to notebook
Swiggy Market Intelligence screenshot
2025 · ANALYTICS

Swiggy Market Intelligence

The Swiggy Market Intelligence Engine turns raw order history into a market-entry signal. A four-signal City Expansion Index scores every city 0–100 across revenue, rating, density, and diversity, while a separate Restaurant Health Score tiers vendors from Champion to Critical so at-risk restaurants can be caught before they churn.

Stack
PythonPandasPlotlyStreamlitSQLiteSciPyStatsmodelsscikit-learnopenpyxl
Highlights
  • City Expansion Index scored every city 0–100 across 197,430 orders using four weighted signals
  • Restaurant Health Score tiered 1,200+ vendors into Champion / Healthy / At Risk / Critical
  • SQL + ARIMA analysis confirmed a Pareto effect (~20% of cities driving ~80% of revenue); delivered as a 7-tab Streamlit dashboard plus a 13-sheet Excel KPI report