Pizza Analytics: Slicing through Sales for Savvy Solutions

Number of Customers per Day:

• The dataset includes data for 358 days in 2015.
• Each day, the number of customers varied, ranging from 27 to 73.
• For instance, on January 1st, 2015, there were 69 customers, while on December 29th, 2015, there were 27 customers.
• Fridays and Thursdays have higher customer engagements compared to Sundays and Mondays which had the lowest customer engagement.
• These insights help understand daily customer traffic and potential demand patterns.

Number of Orders per Hour:

• There are distinct peak hours for pizza orders. For instance, at 12 PM (noon), the business received 6,543 orders, indicating a significant peak in demand during lunch hours.
• This insight is crucial for resource allocation and planning staffing schedules.

Average Number of Pizzas per Order and Bestselling Pizzas:

• On average, customers order approximately 2.32 pizzas per order.

• The top five bestselling pizzas are:

  1. The Classic Deluxe Pizza: 2453 orders
  2. The Barbecue Chicken Pizza: 2432 orders
  3. The Hawaiian Pizza: 2422 orders
  4. The Pepperoni Pizza: 2418 orders
  5. The Thai Chicken Pizza: 2371 orders

• The bestselling pizzas include "The Classic Deluxe Pizza," "The Barbecue Chicken Pizza," and "The Hawaiian Pizza."

• Understanding these metrics aids in optimizing the menu and targeting promotions for popular items.

Total Revenue for the Year and Monthly Revenue Trends:

• The total revenue for the year 2015 amounted to $817,860.05.
• Monthly revenue trends reveal fluctuations throughout the year, with peak revenue in July ($72,557.90) and lowest in September ($64,180.05).
• These insights enable the identification of revenue-generating periods and inform strategic planning.

Pizza Sales Analysis:

• The analysis highlights top-selling pizzas such as "The Classic Deluxe Pizza" and "The Barbecue Chicken Pizza," which have consistently attracted high orders.
• Conversely, pizzas like "The Brie Carre Pizza" have lower sales volumes and may benefit from promotional efforts or menu adjustments.
• This analysis guides menu optimization and promotional strategies to maximize sales and customer satisfaction.