🍽️ Zomato Analysis - SQL Project

Project 8: Zomato Analysis

Technology: SQL, PostgreSQL, Relational Schema Design, Analytical Querying

The Zomato SQL Analysis project dives into the real-world structure and functioning of an online food delivery platform. This analysis covers key business performance metrics derived through structured queries in PostgreSQL, covering over 50,000 records.

• 🧭 Extracted top-performing cuisines and customer preferences using complex filters and subqueries.
• 📍 Analyzed city-wise order trends to identify regional demand shifts and delivery bottlenecks.
• 💹 Identified peak time orders and restaurant frequency via aggregate functions and joins.
• 🧮 Delivered actionable KPIs using GROUP BY, JOIN, and CTE-driven SQL logic.

This project reflects strong SQL query-writing ability, business intuition, and real-world dataset handling experience.