Repository files navigation

This Excel project analyzes pizza sales data from a restaurant to answer six key business questions, such as total sales, most popular pizza category, and peak sales hours. The analysis utilizes basic Excel pivot tables to provide insights into restaurant performanceRestaurant Pizza Sales Analysis

This Excel project analyzes pizza sales data to answer six key questions about restaurant performance.

Data:[https://www.kaggle.com/datasets/shilongzhuang/pizza-sales]This pizza sales dataset make up 12 relevant features:

order_id: Unique identifier for each order placed by a tableorder_details_id: Unique identifier for each pizza placed within each order (pizzas of the same type and size are kept in the same row, and the quantity increases)pizza_id: Unique key identifier that ties the pizza ordered to its details, like size and pricequantity: Quantity ordered for each pizza of the same type and sizeorder_date: Date the order was placed (entered into the system prior to cooking & serving)order_time: Time the order was placed (entered into the system prior to cooking & serving)unit_price: Price of the pizza in USDtotal_price: unit_price * quantitypizza_size: Size of the pizza (Small, Medium, Large, X Large, or XX Large)pizza_type: Unique key identifier that ties the pizza ordered to its details, like size and pricepizza_ingredients: ingredients used in the pizza as shown in the menu (they all include Mozzarella Cheese, even if not specified; and they all include Tomato Sauce, unless another sauce is specified)pizza_name: Name of the pizza as shown in the menu

Project Outcomes:(1).Friday consistently demonstrates the highest weekly sales volume across all observed weeks.

(2).The 'Classic' pizza category consistently ranks as the most popular choice among customers.

(3).July 2015 exhibited the highest overall pizza sales volume among all months analyzed.

(4).Large and Medium size pizzas consistently account for the highest quantities sold across all order sizes.

(5).The timeframe between 12:00 PM and 12:59 PM consistently experiences the highest quantity of pizza sales across all observed time periods.