Case Study: 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 Objectives

1. Explore the menu_items table to get an idea of what's on the new menu
2. Explore the order_details table to get an idea of the data that's been collected
3. Use both tables to understand how customers are reacting to the new menu

Findings

Objective 1

1. There are a total of 32 items on the menu.
2. The least expensive item on the menu is Edamame,price at $5.00. Whereas the most expensive item is the Shrimp Scampi, priced at $19.95.
3. There are 9 Italian dishes on the menu. The least expensive item on the menu is Spaghetti, priced at $14.50 while the most expensive item is the Shrimp Scampi priced at $19.95.
4. The average price for each category cuisine are as follows:
   • Italian: $16.75
   • Asian: $13.47
   • Mexican: $11.80
   • American: $10.07

Project Credential: https://certificates.mavenanalytics.io/61fc3ba2-7061-4537-b296-712733c676d8