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