Data Analysis MAVEN PIZZA CHALLENGE

Improve operations and drive growth: A Data analysis Travel with Plato's Pizza

REFERENCE

In the fast-paced and competitive world of the restaurant industry, Data analysis has become an indispensable tool for improving operations, improving customer experience and driving sales. Like a Data analysis specialist at Digital Rise Solutions, for Plato's Pizza, a Greek-inspired pizzeria in New Jersey. The goal of this project was to leverage transactional data collected over the past year to uncover valuable insights, identify opportunities to drive more sales, and optimize operational efficiencies.

Understanding the dataset:
The dataset used in this project consists of four tables in CSV format:

• Orders Table: Contains the date and time of all table orders placed.
• Order Details table: Lists the different pizzas served with each order, along with their quantities.
• Pizzas Table: Provides pizza size, price, and type information for each separate pizza in the Order Details table.
• Pizza Types Table: Contains complete details about pizza types, including name, category, and ingredient list.

The Maven Pizza Challenge: Plato's Pizza, recognizing the potential of Data analysis . The challenge was to answer several critical questions using the dataset: Identify the busiest days and times: By analyzing the order chart, determine the peak days and times when the restaurant experiences the highest customer attendance. Understanding these patterns could help Plato's Pizza optimize its staff and resources during peak periods.

Evaluating peak hour pizza production: The Order Details table held the key to quantifying the number of pizzas produced during peak periods. By doing so, the restaurant could ensure streamlined kitchen operations and minimize wait times for customers. Discover the best-selling and least-selling pizzas: The Pizzas and Pizza Types tables contained essential data to identify the best-selling pizzas, which could help focus on popular offerings and potentially promote them further. Additionally, knowing the least popular pizzas would allow the restaurant to consider possible improvements or remove items that don't resonate with customers.

Calculating Average Order Value: By analyzing the order table and associated pricing information, I calculated the average order value. This information allowed Plato's Pizza to evaluate customers' spending habits and adapt their marketing strategies to increase order value. Optimizing Seat Capacity Utilization: Understanding seating capacity utilization was vital for Plato’s Pizza. I evaluated order board data to determine how efficiently the restaurant used its 15 tables and 60 seats during different periods, providing opportunities for improvement.