The Swiggy Sales & Performance Analysis Dashboard is an interactive Microsoft Excel dashboard that analyzes sales across states, cities, restaurants, and food categories. It displays key metrics like Total Sales, Orders, Ratings, and Average Order Value using dynamic charts, slicers, and dashboards, enabling data-driven decisions and effective business performance analysis
Developed an interactive Swiggy Sales Dashboard using Microsoft Excel to analyze restaurant sales and customer ordering patterns. Cleaned and organized raw sales data to improve data accuracy and reporting. Created Pivot Tables and Pivot Charts to summarize sales across multiple business dimensions. Designed KPI cards to display Total Sales, Total Orders, Average Rating, Average Order Value, and Ratings Count. Built interactive slicers for Month, State, and Restaurant Name to enable dynamic data filtering. Analyzed monthly and daily sales trends to identify peak sales periods and customer ordering behavior. Compared sales performance by food category, state, city, restaurant, and popular dishes. Implemented map visualization to monitor sales distribution across different Indian states. Applied Excel formulas and dashboard design techniques to create an easy-to-use business reporting solution. Delivered actionable business insights that help management identify top-performing locations, restaurants, and products, supporting better business decisions.