All projects
February 2025
Swiggy Market Intelligence Engine — Strategic Food Analytics
Data AnalyticsBusiness IntelligenceEDAMarket Strategy
- Data analysis project for a food-delivery business: scored every city and every restaurant on the platform to show leadership exactly where to expand and which restaurants need help before they churn.
- 4-signal City Expansion Index (Revenue 30%, Rating 25%, Density 25%, Diversity 20%) scored every city 0–100 across 197,430 orders.
- BCG-style Menu Intelligence Matrix classified food categories into Stars/Cash Cows/Hidden Gems by revenue and rating, while a separate Restaurant Health Score tiered 1,200+ vendors into Champion/Healthy/At Risk/Critical.
- 10-query SQL pipeline and ARIMA forecasting confirmed a Pareto effect (~20% cities = ~80% revenue); delivered a 7-tab Streamlit dashboard + 13-sheet Excel KPI report.
PythonPandasPlotlyStreamlitSQLiteSciPyStatsmodelsScikit-learnopenpyxl