SQL Data Analysis
Project
Solved 13 Business Questions using SQL
MONIKA SINGH | ASPIRING DATA ANALYST
PROJECT OVERVIEW
DATASET : PIZZA SALES DATA
TOOLS USED : SQL(POSTGRESQL)
TOTAL QUESTIONS SOLVED : 13
FOCUS : BUSINESS INSIGHTS FROM SALES
DATASET
OBJECTIVE:
TO ANALYS SALES, REVENUE, AND CUSTOMER TRENDS
USING SQL
Q1 - Retrieve the total number of
orders placed?
Insight :
The Dataset contains 21,350 total orders
Q2 - Calculate the total revenue
generated from pizza sales?
Insight :
The total revenue generated from pizza sales is
₹817,860.05, reflecting strong overall business
performance.
Q3 - Identify the highest-priced
pizza?
Insight :
The Greek pizza is the highest-pizza on
the menu, priced at ₹35.95
Q4 - Identify the most common
pizza size ordered?
Insight :
Customer preference is highest for Large-sized
pizzas, suggesting standard portion sizes drive
most sales, where XL and XXL contribute
minimally.
Q5 - List the top 5 most ordered pizza
types along with thier quantities?
Insight :
The Classic Deluxe pizza is the most
ordered pizza, followed closely by
Barbecue Chicken and Hawaiian pizzas,
indicating strong customer preference for
classic and chicken based flavors.
Q6 - Join the necessary tables to find the total
quantity of each pizza category ordered?
Insight :
Classic pizzas lead overall demand, while
Supreme, Veggie, and Chicken categories
show relatively balanced quantities.
Q7 - Determine the distribution of
orders by hours of the day?
Insight :
Orders peak during late afternoon to
evening hours (around 12PM-7PM),
indicating lunch and dinner are the
busiest time slots.
Q8 - Join relevant tables to find the
category-wise distribution of pizzas?
Insight :
Supreme pizzas have the highest variety,
while Veggie pizzas have the lowet number
of distinct pizza types.
Q9 - Group the orders by date and calculate
the average number of pizzas ordered per day?
Insight :
On average, around 138 pizzas are ordered
per day, indicating consistent daily demand.
Q10 - Determine the top 3 most ordered pizza
types based on revenue?
Insight :
Chicken-based pizzas dominate revenue,
with Thai Chicken pizzas generating the
highest total revenue among all pizza types.
Q11 - Calculate the percentage contribution of
each pizza type to total revenue?
Insight :
Revenue contribution is evenly distributed across all
pizza categories, with Classic pizzas leading at- 27%
and Veggie pizzas contributing the least at- 24%,
indicating diverse customer preferences rather then
reliance on a single category.
Q12 - Analyze the cumulative revenue
generated over time?
Insight :
Revenue accumulates smoothly over time,
reflecting consistent order volume and
healthy saless performance throughout the
period.
Q13 -Determine the top 3 most ordered pizza types
based on revenue for each pizza category?
Insight :
Within each pizza category, a small set of
pizza types generates the majority of
revenue, highlighting clear best-sellers that
drive category-level performance.
PROJECT SUMMARY & KEY LEARNINGS
Analyzed pizza sales data using SQL
Performed data analysis using JOINs, GROUP BY,
ORDER BY
Applied WINDOW Functions(RANK) for ranking
analysis
Calculate revenue, percentage contribution &
cumulative sales
Converted query results into business insights
Open to Feedback and Learning opportunities