Dataset: Pizza Place Sales Analysis

About this Dataset

Pizza Place Sales Analysis

🍕🍽️ Pizza Restaurant Sales

Problem: - Pizza restaurant has recently seen a decline in sales and plans to increase them by looking at customer and order data. To do this, the management plans to perform a thorough analysis of order data and consumer behaviour in order to spot important trends and areas for improvement.

Background: - An overview of pizza sales data from January 2015 to December 2015 is given in this report. To find trends and patterns in pizza sales, data was gathered from pizza joints across the United States and analysed.

About the dataset📅¶

This dataset contains 4 tables in CSV format

The Orders table contains the date & time that all table orders were placed

The Order_Details table contains the different pizzas served with each order in the Orders table, and their quantities

The Pizzas table contains the size and price for each distinct pizza in the Order Details table, as well as its broader pizza type

The Pizza_Types table contains details on the pizza types in the Pizzas table, including their name as it appears on the menu, the category it falls under, and its list of ingredients.

Tables

Orders

@kaggle.ankitrajmishra_pizza_place_sales_analysis.orders

249.47 KB
21350 rows
3 columns


CREATE TABLE orders (
  "order_id" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR
);

Order Details

@kaggle.ankitrajmishra_pizza_place_sales_analysis.order_details

500.54 KB
48620 rows
4 columns


CREATE TABLE order_details (
  "order_details_id" BIGINT,
  "order_id" BIGINT,
  "pizza_id" VARCHAR,
  "quantity" BIGINT
);

Pizzas

@kaggle.ankitrajmishra_pizza_place_sales_analysis.pizzas

4.63 KB
96 rows
4 columns


CREATE TABLE pizzas (
  "pizza_id" VARCHAR,
  "pizza_type_id" VARCHAR,
  "size" VARCHAR,
  "price" DOUBLE
);