Restaurant-Data-Analysis

Project Overview

This project demonstrates a complete data analysis workflow for a restaurant, from data extraction in MySQL to visualization in Power BI. The goal is to provide insights into menu performance, sales trends, and customer behavior.

---

Data Source

-Restaurant Orders Database: https://mavenanalytics.io/data-playground/restaurant-orders?pageSize=10

• A quarter's worth of orders from a fictitious restaurant serving international cuisine, including the date and time of each order, the items ordered, and additional details on the type, name and price of the items.
• Tables included: order_details, menu_items
• Columns used:
  • category, item_id, item_name, menu_item_id,
    order_date, order_details_id, order_id, order_time, price

---

Tools Used

• MySQL: Data extraction, aggregation, and transformation
• Power BI: Dashboard creation, interactive visualizations

---

Features / Visuals in Dashboard

1. Number of menu items
2. Total Revenue
3. Total Orders
4. Average Order Value
5. Menu composition by category
6. Total ordered items per category
7. Most and least ordered items by category
8. Q1 Sales Revenue

---