Skills: SQL, Data Cleaning, Aggregations, GROUP BY, Filters Difficulty: ⭐ Beginner
What it is: Analyse 1.5 lakh restaurants listed on Swiggy across 600+ Indian cities. Find top cuisines, best rated cities, most popular restaurant chains, and pricing patterns.
What it shows hiring managers: Real-world data handling + business insight thinking + SQL fundamentals
How to run this project If you want to replicate this analysis locally, follow these simple steps:
Get the Dataset: Download the source dataset (Swiggy restaurants data) from Kaggle.
Set up the Database:
Open DB Browser for SQLite.
Create a new database file.
Import the downloaded CSV file as a table named swiggy, ensuring you check the box for "Column names in first line".
Run the Analysis: Open the provided .sql file in DB Browser, load the queries into the execution tab, and run them step by step to explore the insights.