📊 Restaurant Sales Dashboard

📌 Overview

This project is an Excel-based restaurant sales analysis and dashboard.
It provides a detailed look into sales performance, customer behavior, and time-based trends, helping to identify opportunities for growth and improvement.

---

Features

✅ KPIs (Key Performance Indicators)

• Total Sales
• Total Quantity Sold
• Total Orders
• Average Sale per Order

✅ Visualizations

• Sales Count by Product – find best-selling items
• Average Sales per Customer by Time – spending behavior during the day
• Monthly Sales – track revenue growth month over month
• Sales Trend – overall sales patterns
• Peak Selling Time – busiest hours of the day
• Sales by Day – weekday vs weekend patterns
• Sales by Gender – compare spending by customer gender
• Sales by Transaction Type – cash vs card

---

📂 Files in this Repository

• restaurant-dashboard.xlsx → Main Excel workbook with analysis and dashboard
• data.csv → Cleaned dataset (optional for preview)
• screenshot.png → Dashboard screenshot (replace with your actual file name)

---

📊 Key Insights

• Identified top-selling products that drive the most revenue.
• Found the peak selling hours and busiest days.
• Compared sales by gender and transaction type.
• Highlighted monthly sales trends to detect growth and seasonal patterns.

---

✨ Author

Muhammed Shamsuddin
GitHub Profile(https://github.com/Muhammed-Shamsuddin)