Data Analyst Portfolio Project: Restaurant Order Analysis in SQL (with Solutions)

Analyze restaurant order and customer data in SQL in this beginner-level Guided Project!

OR

⏱️Timestamps⏱️
00:00 - Intro
00:43 - Project Brief
01:39 - Downloading the data set
02:42 - Objective 1
11:16 - Objective 2
20:24 - Objective 3
34:23 - Outro

💡 With Guided Projects, your goal is to solve a pre-defined series of tasks and objectives, designed to simulate the exact types of problems that data professionals encounter on the job.
Projects range from basic to advanced, feature tools like Excel, MySQL, Power BI, Tableau and Python, and cover topics spanning HR, transportation, hospitality, retail, government, and more.

[jameszhou]

have to say that every buck I spent in Udemy for Maven Analytics courses is worth it. appreciate these practical guidance. thanks a lot.

[alexrosen]

One of the best SQL project tutorials I have seen so far especially because of the way the tutor explained the different steps followed by great and useful examples 👌
I learned a lot 🙏

[adamo]

Easy to follow and felt guided throughout though I did attempt every question. Amazing content Maven as always!

[MekaJ]

Really enjoyed this project and completing it!

[divyarawatt]

Thank you so much for this guided project.😃

[shaileshtiwari]

Nice project thank you for providing me nice content.

[sahilummat]

When will you guys launch a guided project for python analytics . Your courses are awesome

[richaagrawal]

Thankyou so much!! loved your style!! easy to follow. Where can i find maven baby name analysis project??

[HandyCliffy]

Object 2 Q4. How many items were ordered within this date range
SELECT COUNT(item_id)
from order_details:
output: 12097

vs

SELECT COUNT(*)
FROM order_details;
output: 12234

I feel this should be explained further.🤔

[matthewbraun]

I just ran the numbers in EXCEL and POWER BI for Questions - How many orders had more than 12 items - I got 23 not 20.

[pooja-sl]

HI,
In objective 2 where we need to find the most ordered items I counted the item name and I am getting the same results, Is it correct or not ?

[MsGinnieG]

I'm having trouble joining the data sets. It seems like when I loaded the data into SQL, it made the item_id a STRING and the menu_item_id an INTEGER. Could that be the problem?

[pooja-sl]

hi all,
In the second objective last question where we need to find the number of order_ids with more than 12 orders, I am getting 23 as result. Kindly help

[ItisthatisKarthik]

I don't understand what does Column Order_ID mean in order_details table can someone explain what's that ?

[teachersigaud]

The vocal fry is very irritating, but trying to finish the project here. Thanks for the material.