Plato\'s Pizza - Sales and Orders Dashboard
Completion Date:
Project Overview
Pizza is more than just a food. It’s a global phenomenon that brings people together. In the US alone, the pizza restaurant industry has been on the rise, exceeding $45 billion in sales in recent years. One such restaurant is Plato’s pizza, and I’ve analyzed its sales data from 2015 to help identify opportunities to drive more sales and work more efficiently.
The analysis reveals some interesting insights. For example, the average order price for pizza size small had increased by 0.96% in September 2015 but decreased by 1.32% in October 2015. Additionally, the average order price between 6 pm to 7 pm increased by 2.94% in June 2015, but it decreased by 2.11% during the same hour in May 2015.
Role:
Problem Statement
Just hearing the word \"pizza\" brings a smile to the face of just about every American. Whatever style or variety, pizza invariably makes it to the top of \"favorite foods\" list. Pizza restaurants are an important segment of the restaurant industry in the United States. Pizza restaurant sales exceeded 45 billion U.S. dollars in the recent years.
Since 2012, the number of pizza restaurants in the U.S. has been on the rise, increasing by over 6000 units in the last eight years to a high of more than 78 thousand units recently.
Executive Summary
Data Dictionary
Key Takeaways
Insights:
The Average Order Price for pizza size small has increased by 0.48% in May 2015, whereas the Average Order price for pizza size small had decreased by 1.77% in April 2015.
The Average Order Price for pizza size small has decreased by 1.32% in October 2015, whereas the Average Order price for pizza size small had increased by 0.96% in September 2015.
The Average order price between 6pm - 7pm decreased by 2.45% in July 2015, compared to a increase by 2.94% during the same hour of the day in June 2015.
Next Steps
Based on the analysis, I have some suggestions that could help in improving sales.
Firstly, to increase sales on Mondays, we recommend providing discounts and free delivery for orders that surpass a certain value. This will attract more customers on this day of the week.
Secondly, increasing the presence on Digital Media Platforms like Facebook, Twitter, and Instagram can help reach an even broader audience.
Thirdly, implementing a Customer Loyalty Program can incentivize existing customers to come at different times during the week, leading to more sales.
Finally, Upselling and Cross selling are both successful marketing tactics that can be used to increase the average order value. These tactics can be used to encourage customers to increase the size of their meal or add extra items to their order, leading to higher revenue for the restaurant.
Deployment
In progress
