Skip to content

README.md

Latest commit

 

History

History
33 lines (23 loc) · 1.66 KB

README.md

File metadata and controls

33 lines (23 loc) · 1.66 KB

Shiv-restaurant

Restaurant Menu Analysis Project

This project analyzes the performance of a restaurant's new menu introduced at the start of the year. The goal is to identify which menu items are performing well, which are not, and understand customer preferences. The analysis is done using MySQL with two primary tables: menu_items and order_details.

📊 Project Overview

The café recently introduced a new menu and collected data on customer orders. This project aims to:

  1. Explore the menu_items table to understand the new menu.
  2. Analyze the order_details table to understand customer orders.
  3. Combine insights from both tables to evaluate customer reactions to the new menu.

🎯 Objectives

  1. Explore the menu_items Table: Understand the structure and content of the new menu.
  2. Explore the order_details Table: Analyze the data collected from customer orders.
  3. Combine Both Tables: Evaluate how customers are reacting to the new menu by identifying popular and underperforming items.

📂 Files in the Project

The project consists of five files, each serving a specific purpose:

  1. explore_menu_items.sql: Queries to explore the menu_items table.
  2. explore_order_details.sql: Queries to explore the order_details table.
  3. analyze_customer_reaction.sql: Queries combining both tables to analyze customer reactions.
  4. restaurant_db_data_dictionary.xlsx: An Excel file containing details about the tables and columns in the database.
  5. create_restaurant_db: SQL file containing INSERT statements to populate the menu_items and order_details tables with sample data.