Moh Ahamad
PIZZAHUT SALES ANALYSIS
PizzaHut Sales Analysis Using SQL
Project Overview
Objective: To analyze PizzaHut's sales
data using SQL to gain insights on
performance, customer preferences,
and revenue.
🧰 Tools: SQL(MySQL), Excel, CSV files
📊 Focus Areas:-
Project
Order volume and timing
Best-selling pizzas
Revenue patterns
Pizza category breakdowns
Moh Ahamad
PIZZAHUT SALES ANALYSIS
Dataset Summary
orders.csv – order_id, order_date, order_time
order_details.csv – order_details, order_id, pizza_id, quantity
pizzas.csv – pizza_id, pizza_type_id, size, price
pizza_types.csv – pizza_type_id, name, category, ingredients
Moh Ahamad
PIZZAHUT SALES ANALYSIS Basic SQL Analysis
✅ Total Orders Placed: Query using COUNT(*) on orders
💵 Total Revenue: SUM(quantity * price) after joins
🧀 Highest Priced Pizza: ORDER BY price DESC LIMIT 1
🍕 Most Common Size: GROUP BY size with max count
⭐ Top 5 Most Ordered Pizzas:
Joined order details with pizza types
Ranked by quantity ordered
Intermediate SQL Analysis
🔢 Total Quantity by Category: JOIN & GROUP BY category
⏰ Order Distribution by Hour: EXTRACT(HOUR FROM time)
📦 Category-wise Pizza Distribution: JOIN pizza tables and group
📅 Avg Pizzas Per Day: GROUP BY date → AVG(quantity)
💰 Top 3 Revenue-Generating Pizzas:
SUM(quantity * price) → ORDER BY revenue DESC LIMIT 3
Advanced SQL Analysis
📈 % Contribution to Revenue (Per Pizza):
(Pizza Revenue / Total Revenue) * 100
📊 Cumulative Revenue Over Time:
ORDER BY date + SUM(...) OVER(ORDER BY date)
🏆 Top 3 Pizzas by Revenue in Each Category:
GROUP BY category and pizza → Window function or subquery for TOP 3
PIZZAHUT SALES ANALYSIS Moh Ahamad
MySQL Screenshots
Moh Ahamad
PIZZAHUT SALES ANALYSIS
Retrieve the total number of orders placed.
Moh Ahamad
PIZZAHUT SALES ANALYSIS
Calculate the total revenue generated from pizza sales
Moh Ahamad
PIZZAHUT SALES ANALYSIS
Identify the highest-priced pizza.
Moh Ahamad
PIZZAHUT SALES ANALYSIS
Identify the most common pizza size ordered.
Moh Ahamad
PIZZAHUT SALES ANALYSIS
List the top 5 most ordered pizza types along with their
quantities.
Moh Ahamad
PIZZAHUT SALES ANALYSIS
Join the necessary tables to find the total quantity of
each pizza category ordered
Moh Ahamad
PIZZAHUT SALES ANALYSIS
Determine the distribution of orders by hour of the day.
Moh Ahamad
PIZZAHUT SALES ANALYSIS
Join relevant tables to find the category-wise
distribution of pizzas.
Moh Ahamad
PIZZAHUT SALES ANALYSIS
Group the orders by date and calculate the average
number of pizzas ordered per day.
Moh Ahamad
PIZZAHUT SALES ANALYSIS
Determine the top 3 most ordered pizza types based on
revenue.
Moh Ahamad
Calculate the percentage contribution of each pizza type
to total revenue.
Moh Ahamad
Analyze the cumulative revenue generated over time.
Moh Ahamad
Determine the top 3 most ordered pizza types based on
revenue for each pizza category.
PIZZAHUT SALES ANALYSIS
Presented by: Moh Ahamad
Aspiring Data Analyst
📧 Email: [email protected]
“SQL projects demonstrate a data analyst’s ability to extract, manipulate, and analyze data from real-world databases. They
showcase practical skills in deriving actionable insights through structured queries and data-driven thinking.”
PIZZAHUT SALES ANALYSIS
Th an k
Yo u!
