Swiggy Data Analytics & Dashboard Development

This project focuses on analyzing operational, customer, and outlet-level data for a Swiggy-associated food brand to derive actionable business insights and build interactive dashboards for decision-making.

The objective is to track performance across outlets, understand customer complaints, monitor item availability, evaluate marketing campaigns, and identify revenue loss due to operational issues such as stock-outs and downtime.

Scope of Work

The project includes end-to-end data analysis starting from raw data understanding, cleaning, transformation, and visualization using Power BI and Excel.

Key dashboards developed as part of this project include:

Consolidated Complaint Dashboard
To analyze customer complaints by category, outlet, time period, and severity, helping identify recurring issues and improvement areas.

Monthly Outlet Performance Dashboard
To track sales, orders, growth trends, and outlet-wise performance on a monthly basis.

POS Dashboard
To monitor point-of-sale data for order volume, revenue contribution, and operational efficiency.

Campaign Performance Dashboard
To evaluate the impact of marketing campaigns on orders, revenue, and customer engagement.

Item Stock-out History & Revenue Loss Dashboard
To identify frequently stock-out items, duration of stock-outs, and the estimated revenue loss caused by unavailable items.

Outlet Downtime Analysis
To analyze downtime duration, frequency, and its impact on sales and customer experience.

Contact Number Validity Analysis
To check data quality issues related to invalid or missing customer contact details.

Key Deliverables

Interactive Power BI dashboards with slicers and filters

Cleaned and structured datasets ready for reporting

Business insights and observations derived from the dashboards

Identification of operational bottlenecks and revenue leakage points

Tools & Skills Used

Power BI – Dashboard creation, DAX measures, data modeling

Excel – Data cleaning, validation, and preprocessing

SQL (where applicable) – Data extraction and aggregation

Data Analysis & Data Management

Business Insights & Reporting

Outcome

This project demonstrates the ability to:

Handle real-world food-tech and delivery platform data

Convert raw operational data into meaningful insights

Build decision-ready dashboards for stakeholders

Support business teams in improving efficiency, customer satisfaction, and revenue performance