Workspace
Caio Alves/

Pizza Sales

0
Beta
Spinner

Pizza Sales Analysis

This project is based on a challenge from Maven Analytics, where the data was given, and the image above contains a little explanation and some questions about the data. The data is about sales from a fictional pizza place during a year.

The Data

The data given, is divided in four soucers:

Order information

  • 'order_id' - The ID of the order (matches the order_details data)
  • 'date' - the date of the order
  • 'time' the time of the order

Order Details information

  • 'order_details_id' - The ID for the order detail
  • 'order_id' - The ID of the order refered to (matches the order data)
  • 'pizza_id' - The ID of the pizza for the order (matches the pizza data)
  • 'quantity' - The number of pizzas mentioned on 'pizza_id' for that order

Pizza information

  • 'pizza_id' - The ID of the pizza (matches ..)
  • 'pizza_type_id' - The ID for the type of the pizza (matches witch the pizza_type data)
  • 'size' - The size of the Pizza ('S','M','L','XL','XXL')
  • 'price' - The price of the Pizza

Pizza Types Information

  • 'pizza_type_id' - The ID for the type of the pizza (matches witch the pizza data)
  • 'name' - The name for this pizza type
  • 'category' - Category for the pizza type (e.g. Chicken, Veggie, Meat, etc)
  • 'ingredients' - A list of the ingredients of this pizza type

Before answering the questions I'll take a first look at the data

Hidden code
Hidden code
Hidden code
Hidden code
Hidden code
Hidden code

1. How many customers do we have each day? Are there any peak hours?

Since there's no registration of customers of any type, I'll consider the orders to answer this question. So I'll only use the order data which already contains the order id and date and time.

Hidden code

The pizza place had a mean of 60 orders a day during 2015




  • AI Chat
  • Code