Swiggy Excel Dashboard | Sales, Orders & Customer Insights Analysis | Data Analytics Project

In this video, we build and analyze a Swiggy Excel Dashboard to understand the company’s sales performance, customer behavior, and operational trends using real-world data. This Excel data analytics project showcases how dashboards can convert raw business data into actionable insights.

The video begins with an overview of Swiggy’s background, vision, and business segments, followed by a deep dive into KPIs, trends, and geographic performance using pivot tables and interactive Excel charts.

🏢 About Swiggy

Founded in 2013, food delivery launched in 2014

Founders: Sriharsha Majety & Lakshmi Nandan Reddy

Core mission: Deliver favorite meals within 30–40 minutes using technology

Business Segments:

Food Delivery

Instamart (Quick Commerce)

Dineout

Genie

Supply Chain & Distribution

📊 Dashboard KPIs

Total Sales: 53.01 Million

Total Orders: 197.43K

Average Rating: 4.34

Average Order Value (AOV): ₹268.51

Total Ratings: 5.59 Million

📈 Key Insights & Trends

Top Cities by Sales:
Bengaluru leads with 5.46M, followed by Lucknow, Hyderabad, Mumbai, and New Delhi

Time-Based Trends:

Monthly: Highest sales in January (6.8M)

Daily: Saturday is the highest-performing day

Weekly: Week 8 shows peak performance

Food Preference:
Vegetarian food dominates with 65% of total sales

Quarterly Performance:

Best Quarter: Q2 (19.9M)

Weakest Quarter: Q3 (13.4M)

State-Wise Performance:
Assam records the highest sales, while Nagaland and Sikkim are the lowest

🎛 Excel Dashboard Features

Pivot Tables for dynamic calculations

Line, Bar, and Map Charts for trend visualization

Interactive filters for time, city, and food type analysis

🎯 Why This Video Matters

Learn Excel dashboard creation step by step

Understand food delivery business analytics

Ideal for data analysts, business analysts, MIS executives, and students

Great portfolio and interview project

📌 Watch till the end to master Excel dashboards using Swiggy business data.

🔍 SEO Keywords (YouTube Tags)

Swiggy Excel Dashboard
Swiggy Sales Analysis
Excel Dashboard Project
Food Delivery Data Analysis
Excel Data Analytics
Business Analytics in Excel
Swiggy Orders Analysis
Excel Pivot Table Dashboard
Sales Performance Dashboard
Customer Behavior Analysis
Excel Dashboard for Beginners
Data Analyst Project

🏷 Top Hashtags

#SwiggyDashboard
#ExcelDashboard
#DataAnalytics
#SalesAnalysis
#FoodDeliveryAnalytics
#BusinessAnalytics
#ExcelForDataAnalysis
#DashboardDesign
#PivotTable
#CustomerInsights
#DataAnalyst
#MISReporting
#ExcelProject
#excel #excelanalytics #msexceltutorial #excelbasics #excellearning #excelforbeginners #exceltips #exceltraining #excelstudents #conditionalformatting #excelfunctions #excelformulas #excelskills #excelpractice #exceldaily #excellearningpath #exceltricks #advancedexcel #excelexpert #excelautomation #excelwithbapisardar #exceldashboard #excelanalytics #excelpoweruser #exceldataanalysis #dataanalytics #businessanalyst #officeskills #corporatetraining #CarrerGrowth #upskill #learnexcel #excelshorts #excelreels #tech #techskills #skilldevelopment #excelvideos #dataanalytics #exceldashboard #salesanalysis #logisticsanalytics #gamingindustry #ussalesdata #pivottables #businessintelligence #dashboarddesign #datavisualization #profitanalysis #supplychainanalytics #excelforanalytics

Видео Swiggy Excel Dashboard | Sales, Orders & Customer Insights Analysis | Data Analytics Project канала Tech With Alok