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 performance Restaurant 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 table order_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 price quantity: Quantity ordered for each pizza of the same type and size order_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 USD total_price: unit_price * quantity pizza_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 price pizza_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.