Pizza House Sales Analysis --SQL Project

To analyze pizza sales data to provide actionable insights on sales performance, customer preferences, and revenue generation.

1. SQL Project
A Project on Pizza House Sales Analysis
https://www.linkedin.com/in/mayank-srivastava-6a8421105/

2. PROJECT SUMMARY
OBJECTIVE
To analyze pizza sales data to:
•
provide actionable insights on sales
performance,
•
customer preferences, and
•
revenue generation.
01
FEATURES OF THE TOPIC
•
Sub Query
•
Group By
•
Cumulative sum, Rank
•
Visualizations
02
ABOUT THE DATASET
•
Analyzing sales records from a pizza
restaurant, spanning one year.
•
Dataset has 48,620 sales
transactions to analyze.
02
TOOLS USED
•
MySQLfor data querying and
manipulation
•
Python(Pandas, Matplotlib,
Seaborn)
04

3. Connecting to
pizza_houseDatabase

4. DATA SCHEMA

6. Retrieve the total number of orders
placed.

7. Calculate the total revenue generated
from pizza sales.

8. Identify the highest-priced pizza.

9. Identify the most common pizza size
ordered.

10. List the top 5 most ordered pizza types
along with their quantities.

12. Join the necessary tables to find the total
quantity of each pizza category ordered.

13. Determine the distribution of orders by
hour of the day.

14. Join relevant tables to find the category-
wise distribution of pizzas.

15. Group the orders by date and calculate the
average number of pizzas ordered per day.

16. Determine the top 3 most ordered pizza
types based on revenue.

17. Calculate the percentage contribution of
each pizza type to total revenue.

18. Analyze the cumulative revenue
generated over time.

19. Determine the top 3 most ordered pizza types
based on revenue for each pizza category.

20. CREDITS: This presentation template was
created by Slidesgo, including icons by
Flaticon, infographics & images by Freepik
Do you have any questions?
•
[email protected]
•
https://www.linkedin.com/in/mayank-srivastava-6a84211054
•
https://www.hackerrank.com/profile/mayanksri461994
•
https://github.com/Mayank4694
•
https://www.kaggle.com/mayanksrivastava469