SQL Project on Zomato Analytics

INTRODUCTION

SQL stands for Structured Query Language. It is the standard language to interact with databases. SQL is the most important tool, a data analyst uses to manipulate and gain insights from the data. In this project, we will try to process, and analyze the data, for this purpose we will use this Zomato Datasets from Github

1 Creating Zomato Table Script

So now after creating the database let’s start exploring the data and answer some questions.

2. PROCESSING THE DATA

So let’s have a look at our data set, to see the data we will use this query:

Q1 — — what is total amount each customer spent on zomato ?

Q2 — — How many days has each customer visited zomato?

Q3 — — what was the first product purchased by each customer?

Q4 — — what is most purchased item on menu & how many times was it purchased by all customers ?

Q5 — — which item was most popular for each customer?

Q6 — — which item was purchased first by customer after they become a member ?

Q7 — — which item was purchased just before customer became a member?

Q8 — — what is total orders and amount spent for each member before they become a member ?

Q9 — — if buying each product generate points for eg 5rs=2 zomato point and each product has different purchasing points — for eg for p1 5rs=1 zomato point,for p2 10rs=zomato point and p3 5rs=1 zomato point 2rs =1zomato point, — calculate points collected by each customers and for which product most points have been given till now.

Q10 — — rnk all transaction of the customers ?

We can further analyse more out of this dataset

Let me know what would you like me to analyse in this dataset further

Thanks for reading! If you want to get in touch with me, feel free to reach me at Twitter or my LinkedIn Profile.