An interactive Excel dashboard analyzing customer preferences, restaurant distribution, delivery performance, and pricing — transforming raw Swiggy food delivery data into actionable insights.
The Swiggy Food Analysis Dashboard is an interactive data analysis project built using Microsoft Excel. It provides insights into customer preferences, restaurant distribution, delivery performance, pricing, and ratings across different cities.
Food delivery platforms generate large volumes of data, but raw data is difficult to interpret. Key challenges include identifying popular food categories, understanding delivery time differences across cities, analyzing pricing variations by area, and evaluating customer ratings and service quality.
The objective was to analyze restaurant distribution by food category, understand customer preferences, evaluate delivery time across cities, compare pricing across areas, and analyze ratings across cities — all within a clean, interactive Excel dashboard.
The dataset is based on Swiggy food delivery data, preprocessed using Microsoft Excel with data cleaning techniques and Pivot Tables to enable meaningful analysis and visualization.
Data fields included:
This dashboard converts raw Swiggy food delivery data into meaningful insights, helping food businesses and platform operators understand market dynamics and customer behavior. By leveraging Excel's Pivot Tables and chart capabilities, it demonstrates how data visualization techniques can bridge the gap between raw operational data and strategic decisions — from city-level delivery optimization to cuisine-specific targeting and customer satisfaction improvement.
Feel free to reach out for feedback, collaboration, or any data analytics opportunities.