PIZZA Home About Contact
Sales analysis
PIZZA SALES
ANALYSIS USING
SQL
Developed by,
NOOR AZAM
PIZZA
ABOUT PROJECT
Sales analysis Home About Contact
This project focuses on analyzing pizza sales data to uncover key business
insights such as total revenue, customer purchasing trends, and popular pizza
categories. Using SQL queries, the data was extracted, filtered, and aggregated to
identify high-performing products and sales patterns across different time
periods.
The goal of this analysis is to help a pizza business make data-driven decisions — from
optimizing menu offerings to improving sales strategies — through a structured SQL-
based exploration of real-world sales data.
🔍 KEY FOCUS AREAS
PIZZA
Sales analysis
Home About Contact
SALES PERFORMANCE: UNDERSTANDING TOTAL AND
AVERAGE SALES OVER TIME.
PRODUCT ANALYSIS: IDENTIFYING TOP-SELLING PIZZA
TYPES AND SIZES.
CUSTOMER TRENDS: ANALYZING ORDER FREQUENCY,
TIMING, AND PREFERENCES.
OPERATIONAL INSIGHTS: EVALUATING OUTLET-WISE
OR LOCATION-BASED PERFORMANCE.
Questions PIZZA
Home About Contact
Sales analysis
Basic:
Retrieve the total number of orders placed.
Calculate the total revenue generated from pizza sales.
Identify the highest-priced pizza.
Identify the most common pizza size ordered.
List the top 5 most ordered pizza types along with their quantities.
Intermediate:
Join the necessary tables to find the total quantity of each pizza category ordered.
Determine the distribution of orders by hour of the day.
Join relevant tables to find the category-wise distribution of pizzas.
Group the orders by date and calculate the average number of pizzas ordered per day.
01 the top 3 most ordered
Determine 02 pizza types based 03on revenue. 04
Advanced:
Calculate the percentage contribution of each pizza type to total revenue.
Analyze the cumulative revenue generated over time.
Determine the top 3 most ordered pizza types based on revenue for each pizza category.
BASIC
01 Q. Retrieve the total number of orders
placed.
BASIC
02 Q. Calculate the total revenue generated
from pizza sales.
BASIC
03 Q. Identify the highest-priced pizza.
BASIC
04 Q. Identify the most common pizza size
ordered.
BASIC
05 Q. List the top 5 most ordered pizza types
along with their quantities.
INTERMEDIATE
01 Q. Join the necessary tables to find the total
quantity of each pizza category ordered.
INTERMEDIATE
02 Q. Determine the distribution of orders by
hour of the day.
INTERMEDIATE
03 Q. Join relevant tables to find the category-
wise distribution of pizzas.
INTERMEDIATE
04 Q. Group the orders by date and calculate the
average number of pizzas ordered per day.
INTERMEDIATE
05 Q. Determine the top 3 most ordered pizza
types based on revenue.
ADVANCED
01 Q. Calculate the percentage contribution of
each pizza type to total revenue.
ADVANCED
02 Q. Analyze the cumulative revenue generated
over time.
ADVANCED
03 Q. Determine the top 3 most ordered pizza types
based on revenue for each pizza category.
PIZZA
Sales analysis
🍕 CONCLUSION Home About Contact
THE PIZZA SALES ANALYSIS PROVIDED VALUABLE INSIGHTS INTO CUSTOMER
PREFERENCES, SALES PERFORMANCE, AND PRODUCT DEMAND. BY LEVERAGING
SQL, WE EFFICIENTLY EXTRACTED AND ANALYZED KEY PATTERNS FROM LARGE
DATASETS, HELPING TO IDENTIFY:
🍕 TOP-PERFORMING PIZZAS THAT DRIVE THE MAJORITY OF REVENUE.
💰 PEAK SALES PERIODS AND TIME-BASED BUYING TRENDS.
📊 LOCATION-WISE AND CATEGORY-WISE PERFORMANCE DIFFERENCES.
🎯 OPPORTUNITIES FOR GROWTH, SUCH AS PROMOTING UNDERPERFORMING
ITEMS OR ADJUSTING MENU PRICING.
THIS PROJECT DEMONSTRATES HOW SQL CAN TRANSFORM RAW TRANSACTIONAL
DATA INTO ACTIONABLE BUSINESS INSIGHTS, SUPPORTING BETTER DECISION-
MAKING FOR SALES, MARKETING, AND INVENTORY MANAGEMENT.
PIZZA
Sales analysis Home About Contact
THANK YOU
FOR ATTENTION NOOR AZAM
EMAIL: NOORAZAM7011@[Link]
MOB: 6200878534