Skip to content
/ Zomato_SQL_Analysis Public

SQL-based analysis of Zomato, a leading food delivery company in India data, including database setup, data cleaning, and solving.Through this project, various insights are generated around restaurants, customers, and orders, highlighting strong SQL problem-solving and analytical skills.

0 stars 0 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

samansiddiqui55/Zomato_SQL_Analysis

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
README.md
README.md
 
 
customers.csv
customers.csv
 
 
deliveries.csv
deliveries.csv
 
 
orders.csv
orders.csv
 
 
restaurants.csv
restaurants.csv
 
 
riders.csv
riders.csv
 
 

Repository files navigation

SQL Project: Data Analysis for Zomato - A Food Delivery Company

Overview

This project demonstrates my SQL problem-solving skills through the analysis of data for Zomato, a popular food delivery company in India. The project involves setting up the database, importing data, handling null values, and solving a variety of business problems using complex SQL queries.

Project Structure

  • Database Setup: Creation of the zomato_db database and the required tables.

  • Data Import: Inserting sample data into the tables.

  • Data Cleaning: Handling null values and ensuring data integrity.

  • Business Problems: Solving 20 specific business problems using SQL queries.

  • erd

About

SQL-based analysis of Zomato, a leading food delivery company in India data, including database setup, data cleaning, and solving.Through this project, various insights are generated around restaurants, customers, and orders, highlighting strong SQL problem-solving and analytical skills.

Resources

Readme
Activity

Stars

0 stars

Watchers

0 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published