View Project
Data Source:https://www.kaggle.com/datasets/mysarahmadbhat/pizza-place-sales
BACKGROUND:
The pizza place aims to leverage its business strategy by understanding more about its customers' preferences, peak hours, busiest days, best-selling pizzas, the seasonality in the sales, least selling pizza, improving staff management and building strategies to increase their revenue.
METHODOLOGY:
Data Collection
Data Cleaning & organisation
Data Analysis
Conclusion
GOALS:
Identify Customers' preferences
Optimize menu & pricing startegy
Identify Peak sales periods
Forecasting & Planning
PROJECT SCOPE:
1. How many customers do they have each day? Are there any peak hours?
2. How many pizzas are typically in an order? Do they have any bestsellers?
3. How much money did they make this year? Can we identify any seasonality in the sales?
4. Are there any pizzas they should take off the menu, or any promotions they could leverage?
KPIs:
• Number of customers each day
• Number of orders in the queue at a given time
• Peak hours
• Top bestselling pizza
• Revenue generated in a year
• Seasonality in sale
• Least selling pizza
CONCEPTS USED:
• SUM, AVERAGE, MULTIPLICATION, ROUNDUP, COUNTIF, Month, Hour formulas
• VLOOKUP, removing delimiter, Conditional formatting, Sorting.
• Pivot Tables & Charts
CONCLUSION:
In conclusion, the analysis of pizza sales data has shed light on several important aspects of customer behaviour, market trends, and business performance within the pizza industry. We have identified key findings by examining the data and draw insights that can guide decision-making and drive business growth.