The Pizza Sales Report provides valuable insights and analysis into the sales performance of our pizza offerings. By querying the database, this report offers a comprehensive overview of key metrics, trends, and patterns related to pizza sales. This information aids in making informed decisions about inventory management, pricing strategies, and marketing initiatives to optimize our pizza sales.
Report Highlights: Sales Overview: Gain a holistic view of total pizza sales, including revenue, quantities sold, and average order value.
Top Selling Pizzas: Identify the most popular pizza flavors and styles, helping us understand customer preferences
Time-based Analysis: Analyze sales trends based on different time periods such as daily, weekly, and monthly, to spot seasonality and demand patterns.
The dataset is found on Maven Analytics under the name Pizza Place Sales with a total of 4 tables with 48,620 records and 12 fields.
• Order Details
The table has the order_details_id which is the primary key of the table along with the order_id, pizza_id as the foreign key of the orders and pizzas table and last, we have the quantity column of each type of pizza.
• Orders
This table includes the order_id which is the primary key, and the date and time of each order.
• Pizza Types
We have the pizza_type_id as the primary key, along with each pizza's name, category and ingredients.
• Pizzas
The pizzas table has the pizza_id as the primary key, and the pizza_type_id as the foreign key from the pizza types table, it also includes the size and price of the pizza.