Pizza Place Sales

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.