Restaurant Operations Analysis
The Situation: You've just been hired as a Data Analyst for the Taste of the World Cafe, a restaurant that has diverse menu offerings and serves generous portions
The Assignment: The Taste of the World Cafe debuted a new menu at the start of the year You've been asked to dig into the customer data to see which menu items are doing well/ not well and what the top customers seem to like best
The Objective:
- Explore the menu_items table to get an idea of what's on the new menu
- Explore the order_details table to get an idea of the data that's been collected
- Use both tables to understand how customers are reacting to the new menu
Objective 1: Exploer the Items table
-
View the menu_items table and write a query to find the number of items on the menu
-
What are the least and most expensive items on the menu?
-
How many italian dishes are on the menu? What are the least and most expensive italian dishes on the menu?
-
How many dishes are in each category? What is the average dish price within each category?
Objective 2: Explore the Orders table
-
View the order_details table. What is the date range of the table?
-
How many orders were made within this date range? How many items were ordered within this date range?
-
Which orders had the most numbers of items?
-
How many orders had more than 12 items?
Objective 3: Analyze Customer Behavior
-
Combine the menu_items and order_details tables into a single table
-
What were the least and most ordered items? What categories were they in?
-
What were the top 5 orders that spent the most money?
Order ID 440, 2075, 1957, 330, 2675
- View the details of the highest spend order. What insights can you gather from the results?
Query shows that Italian followed by Asian food are the most popular category.
- Bonus: View the details of the top 5 highest spend orders. What insights can you gatgher from the results?