Pizza sales analysis

Project highlights: We need to analyze key indicators for our pizza sales data to derive insights into our business performance.

Technology used: Microsoft Excel

Metrics:

1. Total revenue: The sum of total prices of all pizza orders

2. Average order values: the average amount spent per order, calculated by dividing the total revenue by the total number of orders

3. total pizzas sold: the sum of quantities of all pizzas sold

4. total orders: total no. of orders placed

5. Average pizzas per order: the average number of pizzas sold per order, calculate dividing total number of pizzas sold by total no of orders

Charts:

1. daily trend for total orders - displays the daily trend of total orders over a specific time period. it will help to identify any pattern in order volume.

2. hourly trend for total orders - hourly trend for total orders throughout the day..helps to identify peak hours/period of high order.

3. percentage of sales by pizza category - distribution of sales among diff pizza category.

Key insights derived:

1. Orders are highest during Fridays/Saturdays

2. Most Orders are placed during 12-1 pm and 5-8 pm timeframe

3. Classic category contributes most in sales and total no. of orders.

4. Large size pizzas contribute to most sales.

5. Classic deluxe and chicken pizza is the best seller

6. The Brie care pizza is the worst seller