Pizza restaurant sales

Here’s my latest project for a pizza restaurant sales data analysis using Power BI:

Firstly i’d like to thank Adham Osama for the great effort and endless support

The primary goal of this project is to analyze sales data from a pizza restaurant to gain insights into sales performance, customer preferences, and operational efficiency.

The analysis will cover the following aspects:

1️⃣ **Sales Volume and Order Size**

- Evaluate the total sales volume over the last four quarters.

- Analyze the total order size and its variation by season.

2️⃣**Pizza Variety Availability**

- Assess the number of different pizza varieties available and their contribution to overall sales.

3️⃣**Top-selling Pizzas**

- Identify the top three best-selling pizza types based on sales data.

4️⃣**Price Comparison**

- Compare prices across different pizza categories and sizes to identify pricing trends and customer preferences.

5️⃣ **Total Orders Analysis**

- Calculate the total number of orders based on pizza name and size.

- Analyze total sales by pizza size.

6️⃣**Order Trends Over Time**

- Visualize order quantities over time, including date and time trends.

- Interactive dashboards in Power BI showcasing the above metrics.

- Data visualizations that provide insights into sales trends, customer preferences, and operational performance.