23 datasets found
  1. 🍕🍽️ Pizza Restaurant Sales

    • kaggle.com
    Updated Oct 21, 2022
    Share
    FacebookFacebook
    TwitterTwitter
    Email
    Click to copy link
    Link copied
    Close
    Cite
    Shi Long Zhuang (2022). 🍕🍽️ Pizza Restaurant Sales [Dataset]. https://www.kaggle.com/datasets/shilongzhuang/pizza-sales/code
    Explore at:
    CroissantCroissant is a format for machine-learning datasets. Learn more about this at mlcommons.org/croissant.
    Dataset updated
    Oct 21, 2022
    Dataset provided by
    Kagglehttp://kaggle.com/
    Authors
    Shi Long Zhuang
    Description

    Contents

    This pizza sales dataset make up 12 relevant features: - order_id: Unique identifier for each order placed by a table - order_details_id: Unique identifier for each pizza placed within each order (pizzas of the same type and size are kept in the same row, and the quantity increases) - pizza_id: Unique key identifier that ties the pizza ordered to its details, like size and price - quantity: Quantity ordered for each pizza of the same type and size - order_date: Date the order was placed (entered into the system prior to cooking & serving) - order_time: Time the order was placed (entered into the system prior to cooking & serving) - unit_price: Price of the pizza in USD - total_price: unit_price * quantity - pizza_size: Size of the pizza (Small, Medium, Large, X Large, or XX Large) - pizza_type: Unique key identifier that ties the pizza ordered to its details, like size and price - pizza_ingredients: ingredients used in the pizza as shown in the menu (they all include Mozzarella Cheese, even if not specified; and they all include Tomato Sauce, unless another sauce is specified) - pizza_name: Name of the pizza as shown in the menu

    🍕The Pizza Challenge

    For the Maven Pizza Challenge, you’ll be playing the role of a BI Consultant hired by Plato's Pizza, a Greek-inspired pizza place in New Jersey. You've been hired to help the restaurant use data to improve operations, and just received the following note:

    Welcome aboard, we're glad you're here to help!

    Things are going OK here at Plato's, but there's room for improvement. We've been collecting transactional data for the past year, but really haven't been able to put it to good use. Hoping you can analyze the data and put together a report to help us find opportunities to drive more sales and work more efficiently.

    Here are some questions that we'd like to be able to answer:

    1. What days and times do we tend to be busiest?
    2. How many pizzas are we making during peak periods?
    3. What are our best and worst-selling pizzas?
    4. What's our average order value?
    5. How well are we utilizing our seating capacity? (we have 15 tables and 60 seats)

    That's all I can think of for now, but if you have any other ideas I'd love to hear them – you're the expert!

    Thanks in advance,

    Mario Maven (Manager, Plato's Pizza)

    Colllection Methodology

    The public dataset is completely available on the Maven Analytics website platform where it stores and consolidates all available datasets for analysis in the Data Playground. The specific individual datasets at hand can be obtained at this link below: https://www.mavenanalytics.io/blog/maven-pizza-challenge

    📌I set up the data model to include all the related instances in one single table so obtaining data for analysis is made easier.

    My Inspiration

    Complete details were also provided about the challenge in the link if you are interested. The purpose of uploading here is to conduct exploratory data analysis about the dataset beforehand with the use of Pandas and data visualization libraries in order to have a comprehensive review of the data and translate my findings and insights in the form of a single page visualization.

  2. A

    ‘🍕 Pizza restaurants and Pizzas on their Menus’ analyzed by Analyst-2

    • analyst-2.ai
    Updated Feb 13, 2022
    Share
    FacebookFacebook
    TwitterTwitter
    Email
    Click to copy link
    Link copied
    Close
    Cite
    Analyst-2 (analyst-2.ai) / Inspirient GmbH (inspirient.com) (2022). ‘🍕 Pizza restaurants and Pizzas on their Menus’ analyzed by Analyst-2 [Dataset]. https://analyst-2.ai/analysis/kaggle-pizza-restaurants-and-pizzas-on-their-menus-e043/latest
    Explore at:
    Dataset updated
    Feb 13, 2022
    Dataset authored and provided by
    Analyst-2 (analyst-2.ai) / Inspirient GmbH (inspirient.com)
    License

    Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
    License information was derived automatically

    Description

    Analysis of ‘🍕 Pizza restaurants and Pizzas on their Menus’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/yamqwe/pizza-restaurants-and-pizzas-on-their-menuse on 13 February 2022.

    --- Dataset description provided by original source is as follows ---

    About this dataset

    About this Data

    This is a list of over 3,500 pizzas from multiple restaurants provided by Datafiniti's Business Database. The dataset includes the category, name, address, city, state, menu information, price range, and more for each pizza restaurant.

    Note that this is a sample of a large dataset. The full dataset is available through Datafiniti.

    What You Can Do with this Data

    You can use this data to discover how much you can expect to pay for pizza across the country. E.g.:

    • What are the least and most expensive cities for pizza?
    • What is the number of restaurants serving pizza per capita (100,000 residents) across the U.S.?
    • What is the median price of a large plain pizza across the U.S.?
    • Which cities have the most restaurants serving pizza per capita (100,000 residents)?

    Data Schema

    A full schema for the data is available in our support documentation.

    About Datafiniti

    Datafiniti provides instant access to web data. We compile data from thousands of websites to create standardized databases of business, product, and property information. Learn more.

    Interested in the Full Dataset?

    Get this data and more by creating a free Datafiniti account or requesting a demo.

    This dataset was created by Datafiniti and contains around 10000 samples along with Longitude, Price Range Max, technical information and other features such as: - Date Updated - Categories - and more.

    How to use this dataset

    • Analyze Date Added in relation to Province
    • Study the influence of Price Range Min on Address
    • More datasets

    Acknowledgements

    If you use this dataset in your research, please credit Datafiniti

    Start A New Notebook!

    --- Original source retains full ownership of the source dataset ---

  3. p

    Pizza Restaurants in United States - 95,956 Verified Listings Database

    • poidata.io
    csv, excel, json
    Updated Jun 28, 2025
    Share
    FacebookFacebook
    TwitterTwitter
    Email
    Click to copy link
    Link copied
    Close
    Cite
    Poidata.io (2025). Pizza Restaurants in United States - 95,956 Verified Listings Database [Dataset]. https://www.poidata.io/report/pizza-restaurant/united-states
    Explore at:
    csv, excel, jsonAvailable download formats
    Dataset updated
    Jun 28, 2025
    Dataset provided by
    Poidata.io
    Area covered
    United States
    Description

    Comprehensive dataset of 95,956 Pizza restaurants in United States as of June, 2025. Includes verified contact information (email, phone), geocoded addresses, customer ratings, reviews, business categories, and operational details. Perfect for market research, lead generation, competitive analysis, and business intelligence. Download a complimentary sample to evaluate data quality and completeness.

  4. p

    Pizzas in Illinois, United States - 1 Available (Free Sample)

    • poidata.io
    csv
    Updated May 30, 2025
    + more versions
    Share
    FacebookFacebook
    TwitterTwitter
    Email
    Click to copy link
    Link copied
    Close
    Cite
    Poidata.io (2025). Pizzas in Illinois, United States - 1 Available (Free Sample) [Dataset]. https://www.poidata.io/report/pizza/united-states/illinois
    Explore at:
    csvAvailable download formats
    Dataset updated
    May 30, 2025
    Dataset provided by
    Poidata.io
    Area covered
    Illinois, United States
    Description

    This dataset provides information on 1 in Illinois, United States as of May, 2025. It includes details such as email addresses (where publicly available), phone numbers (where publicly available), and geocoded addresses. Explore market trends, identify potential business partners, and gain valuable insights into the industry. Download a complimentary sample of 10 records to see what's included.

  5. A

    ‘USA Key Economic Indicators’ analyzed by Analyst-2

    • analyst-2.ai
    Updated Dec 28, 2021
    Share
    FacebookFacebook
    TwitterTwitter
    Email
    Click to copy link
    Link copied
    Close
    Cite
    Analyst-2 (analyst-2.ai) / Inspirient GmbH (inspirient.com) (2021). ‘USA Key Economic Indicators’ analyzed by Analyst-2 [Dataset]. https://analyst-2.ai/analysis/kaggle-usa-key-economic-indicators-cfd5/latest
    Explore at:
    Dataset updated
    Dec 28, 2021
    Dataset authored and provided by
    Analyst-2 (analyst-2.ai) / Inspirient GmbH (inspirient.com)
    License

    Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
    License information was derived automatically

    Area covered
    United States
    Description

    Analysis of ‘USA Key Economic Indicators’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/calven22/usa-key-macroeconomic-indicators on 28 January 2022.

    --- Dataset description provided by original source is as follows ---

    Context

    Domino’s Pizza, like many other restaurant chains, is getting pinched by higher food costs. The company’s chief executive, Richard Allison, anticipates “unprecedented increases” in the company’s food costs, which could jump by 8-10%. He said that is three to four times what the pizza chain would normally expect in a year.

    This leads to the paramount issue of inflation which affects every aspects of the economy, from consumer spending, business investment and employment rates to government programs, tax policies, and interest rates. The recent release of consumer inflation data showed prices rose at the fastest pace since 1982. Inflation forecasting is key in the conduct of monetary policy and can be used in many other ways such as preserving asset values. This dataset is a consolidated macroeconomic official statistics from 1981 to 2021, containing data available in month and quarterly format.

    Content

    The Core Consumer Price Index (ccpi) measures the changes in the price of goods and services, excluding food and energy due to their volatility. It measures price change from the perspective of the consumer. It is a often used to measure changes in purchasing trends and inflation.

    Do note there are some null values in the dataset.

    Acknowledgements

    All data belongs to the U.S. Bureau of Economic Analysis official release, and are retrieved from FRED, Federal Reserve Bank of St. Louis.

    Inspiration

    What are some noticeable patterns or seasonality of the economy? What are the current trends of the economy? Which indicators has an effect on Core CPI or vice-versa based on predictive power or influence?

    Quarterly data and monthly data can be merged with forward-fill or interpolation methods.

    What is the forecast of Core CPI in 2022?

    --- Original source retains full ownership of the source dataset ---

  6. p

    Pizza Restaurants in Georgia, United States - 2,425 Available (Free Sample)

    • poidata.io
    csv
    Updated May 30, 2025
    Share
    FacebookFacebook
    TwitterTwitter
    Email
    Click to copy link
    Link copied
    Close
    Cite
    Poidata.io (2025). Pizza Restaurants in Georgia, United States - 2,425 Available (Free Sample) [Dataset]. https://www.poidata.io/report/pizza-restaurant/united-states/georgia
    Explore at:
    csvAvailable download formats
    Dataset updated
    May 30, 2025
    Dataset provided by
    Poidata.io
    Area covered
    Georgia, United States
    Description

    This dataset provides information on 2,425 in Georgia, United States as of May, 2025. It includes details such as email addresses (where publicly available), phone numbers (where publicly available), and geocoded addresses. Explore market trends, identify potential business partners, and gain valuable insights into the industry. Download a complimentary sample of 10 records to see what's included.

  7. p

    Pizza Restaurants in Michigan, United States - 3,129 Available (Free Sample)...

    • poidata.io
    csv
    Updated May 14, 2025
    Share
    FacebookFacebook
    TwitterTwitter
    Email
    Click to copy link
    Link copied
    Close
    Cite
    Poidata.io (2025). Pizza Restaurants in Michigan, United States - 3,129 Available (Free Sample) [Dataset]. https://www.poidata.io/report/pizza-restaurant/united-states/michigan
    Explore at:
    csvAvailable download formats
    Dataset updated
    May 14, 2025
    Dataset provided by
    Poidata.io
    Area covered
    Michigan, United States
    Description

    This dataset provides information on 3,129 in Michigan, United States as of May, 2025. It includes details such as email addresses (where publicly available), phone numbers (where publicly available), and geocoded addresses. Explore market trends, identify potential business partners, and gain valuable insights into the industry. Download a complimentary sample of 10 records to see what's included.

  8. p

    Pizza Restaurants in Kentucky, United States - 1,336 Available (Free Sample)...

    • poidata.io
    csv
    Updated May 10, 2025
    Share
    FacebookFacebook
    TwitterTwitter
    Email
    Click to copy link
    Link copied
    Close
    Cite
    Poidata.io (2025). Pizza Restaurants in Kentucky, United States - 1,336 Available (Free Sample) [Dataset]. https://www.poidata.io/report/pizza-restaurant/united-states/kentucky
    Explore at:
    csvAvailable download formats
    Dataset updated
    May 10, 2025
    Dataset provided by
    Poidata.io
    Area covered
    Kentucky, United States
    Description

    This dataset provides information on 1,336 in Kentucky, United States as of May, 2025. It includes details such as email addresses (where publicly available), phone numbers (where publicly available), and geocoded addresses. Explore market trends, identify potential business partners, and gain valuable insights into the industry. Download a complimentary sample of 10 records to see what's included.

  9. p

    Pizza Restaurants in Iowa, United States - 969 Available (Free Sample)

    • poidata.io
    csv
    Updated May 29, 2025
    Share
    FacebookFacebook
    TwitterTwitter
    Email
    Click to copy link
    Link copied
    Close
    Cite
    Poidata.io (2025). Pizza Restaurants in Iowa, United States - 969 Available (Free Sample) [Dataset]. https://www.poidata.io/report/pizza-restaurant/united-states/iowa
    Explore at:
    csvAvailable download formats
    Dataset updated
    May 29, 2025
    Dataset provided by
    Poidata.io
    Area covered
    Iowa, United States
    Description

    This dataset provides information on 969 in Iowa, United States as of May, 2025. It includes details such as email addresses (where publicly available), phone numbers (where publicly available), and geocoded addresses. Explore market trends, identify potential business partners, and gain valuable insights into the industry. Download a complimentary sample of 10 records to see what's included.

  10. p

    Pizza Restaurants in Oregon, United States - 1,175 Available (Free Sample)

    • poidata.io
    csv
    Updated May 14, 2025
    Share
    FacebookFacebook
    TwitterTwitter
    Email
    Click to copy link
    Link copied
    Close
    Cite
    Poidata.io (2025). Pizza Restaurants in Oregon, United States - 1,175 Available (Free Sample) [Dataset]. https://www.poidata.io/report/pizza-restaurant/united-states/oregon
    Explore at:
    csvAvailable download formats
    Dataset updated
    May 14, 2025
    Dataset provided by
    Poidata.io
    Area covered
    Oregon, United States
    Description

    This dataset provides information on 1,175 in Oregon, United States as of May, 2025. It includes details such as email addresses (where publicly available), phone numbers (where publicly available), and geocoded addresses. Explore market trends, identify potential business partners, and gain valuable insights into the industry. Download a complimentary sample of 10 records to see what's included.

  11. p

    Pizza Takeouts in New York, United States - 1,658 Available (Free Sample)

    • poidata.io
    csv
    Updated May 29, 2025
    Share
    FacebookFacebook
    TwitterTwitter
    Email
    Click to copy link
    Link copied
    Close
    Cite
    Poidata.io (2025). Pizza Takeouts in New York, United States - 1,658 Available (Free Sample) [Dataset]. https://www.poidata.io/report/pizza-takeout/united-states/new-york
    Explore at:
    csvAvailable download formats
    Dataset updated
    May 29, 2025
    Dataset provided by
    Poidata.io
    Area covered
    New York, United States
    Description

    This dataset provides information on 1,658 in New York, United States as of May, 2025. It includes details such as email addresses (where publicly available), phone numbers (where publicly available), and geocoded addresses. Explore market trends, identify potential business partners, and gain valuable insights into the industry. Download a complimentary sample of 10 records to see what's included.

  12. p

    Pizza Deliveries in Texas, United States - 3,027 Verified Listings Database

    • poidata.io
    csv, excel, json
    Updated Jun 30, 2025
    Share
    FacebookFacebook
    TwitterTwitter
    Email
    Click to copy link
    Link copied
    Close
    Cite
    Poidata.io (2025). Pizza Deliveries in Texas, United States - 3,027 Verified Listings Database [Dataset]. https://www.poidata.io/report/pizza-delivery/united-states/texas
    Explore at:
    excel, csv, jsonAvailable download formats
    Dataset updated
    Jun 30, 2025
    Dataset provided by
    Poidata.io
    Area covered
    Texas, United States
    Description

    Comprehensive dataset of 3,027 Pizza deliveries in Texas, United States as of June, 2025. Includes verified contact information (email, phone), geocoded addresses, customer ratings, reviews, business categories, and operational details. Perfect for market research, lead generation, competitive analysis, and business intelligence. Download a complimentary sample to evaluate data quality and completeness.

  13. p

    Pizza Deliveries in California, United States - 3,372 Available (Free...

    • poidata.io
    csv
    Updated May 3, 2025
    + more versions
    Share
    FacebookFacebook
    TwitterTwitter
    Email
    Click to copy link
    Link copied
    Close
    Cite
    Poidata.io (2025). Pizza Deliveries in California, United States - 3,372 Available (Free Sample) [Dataset]. https://www.poidata.io/report/pizza-delivery/united-states/california
    Explore at:
    csvAvailable download formats
    Dataset updated
    May 3, 2025
    Dataset provided by
    Poidata.io
    Area covered
    United States, California
    Description

    This dataset provides information on 3,372 in California, United States as of May, 2025. It includes details such as email addresses (where publicly available), phone numbers (where publicly available), and geocoded addresses. Explore market trends, identify potential business partners, and gain valuable insights into the industry. Download a complimentary sample of 10 records to see what's included.

  14. p

    Pizza Takeouts in California, United States - 3,528 Available (Free Sample)

    • poidata.io
    csv
    Updated May 4, 2025
    Share
    FacebookFacebook
    TwitterTwitter
    Email
    Click to copy link
    Link copied
    Close
    Cite
    Poidata.io (2025). Pizza Takeouts in California, United States - 3,528 Available (Free Sample) [Dataset]. https://www.poidata.io/report/pizza-takeout/united-states/california
    Explore at:
    csvAvailable download formats
    Dataset updated
    May 4, 2025
    Dataset provided by
    Poidata.io
    Area covered
    California, United States
    Description

    This dataset provides information on 3,528 in California, United States as of May, 2025. It includes details such as email addresses (where publicly available), phone numbers (where publicly available), and geocoded addresses. Explore market trends, identify potential business partners, and gain valuable insights into the industry. Download a complimentary sample of 10 records to see what's included.

  15. p

    Pizza Takeouts in Pennsylvania, United States - 1,298 Verified Listings...

    • poidata.io
    csv, excel, json
    Updated Jun 28, 2025
    Share
    FacebookFacebook
    TwitterTwitter
    Email
    Click to copy link
    Link copied
    Close
    Cite
    Poidata.io (2025). Pizza Takeouts in Pennsylvania, United States - 1,298 Verified Listings Database [Dataset]. https://www.poidata.io/report/pizza-takeout/united-states/pennsylvania
    Explore at:
    csv, json, excelAvailable download formats
    Dataset updated
    Jun 28, 2025
    Dataset provided by
    Poidata.io
    Area covered
    Pennsylvania, United States
    Description

    Comprehensive dataset of 1,298 Pizza Takeouts in Pennsylvania, United States as of June, 2025. Includes verified contact information (email, phone), geocoded addresses, customer ratings, reviews, business categories, and operational details. Perfect for market research, lead generation, competitive analysis, and business intelligence. Download a complimentary sample to evaluate data quality and completeness.

  16. p

    Pizza Takeouts in Ohio, United States - 1,473 Available (Free Sample)

    • poidata.io
    csv
    Updated May 29, 2025
    Share
    FacebookFacebook
    TwitterTwitter
    Email
    Click to copy link
    Link copied
    Close
    Cite
    Poidata.io (2025). Pizza Takeouts in Ohio, United States - 1,473 Available (Free Sample) [Dataset]. https://www.poidata.io/report/pizza-takeout/united-states/ohio
    Explore at:
    csvAvailable download formats
    Dataset updated
    May 29, 2025
    Dataset provided by
    Poidata.io
    Area covered
    Ohio, United States
    Description

    This dataset provides information on 1,473 in Ohio, United States as of May, 2025. It includes details such as email addresses (where publicly available), phone numbers (where publicly available), and geocoded addresses. Explore market trends, identify potential business partners, and gain valuable insights into the industry. Download a complimentary sample of 10 records to see what's included.

  17. p

    Pizza Takeouts in Louisiana, United States - 465 Available (Free Sample)

    • poidata.io
    csv
    Updated May 12, 2025
    Share
    FacebookFacebook
    TwitterTwitter
    Email
    Click to copy link
    Link copied
    Close
    Cite
    Poidata.io (2025). Pizza Takeouts in Louisiana, United States - 465 Available (Free Sample) [Dataset]. https://www.poidata.io/report/pizza-takeout/united-states/louisiana
    Explore at:
    csvAvailable download formats
    Dataset updated
    May 12, 2025
    Dataset provided by
    Poidata.io
    Area covered
    Louisiana, United States
    Description

    This dataset provides information on 465 in Louisiana, United States as of May, 2025. It includes details such as email addresses (where publicly available), phone numbers (where publicly available), and geocoded addresses. Explore market trends, identify potential business partners, and gain valuable insights into the industry. Download a complimentary sample of 10 records to see what's included.

  18. p

    Pizza Takeouts in Maine, United States - 184 Available (Free Sample)

    • poidata.io
    csv
    Updated May 29, 2025
    Share
    FacebookFacebook
    TwitterTwitter
    Email
    Click to copy link
    Link copied
    Close
    Cite
    Poidata.io (2025). Pizza Takeouts in Maine, United States - 184 Available (Free Sample) [Dataset]. https://www.poidata.io/report/pizza-takeout/united-states/maine
    Explore at:
    csvAvailable download formats
    Dataset updated
    May 29, 2025
    Dataset provided by
    Poidata.io
    Area covered
    Maine, United States
    Description

    This dataset provides information on 184 in Maine, United States as of May, 2025. It includes details such as email addresses (where publicly available), phone numbers (where publicly available), and geocoded addresses. Explore market trends, identify potential business partners, and gain valuable insights into the industry. Download a complimentary sample of 10 records to see what's included.

  19. p

    Pizza Takeouts in Alabama, United States - 538 Available (Free Sample)

    • poidata.io
    csv
    Updated May 10, 2025
    Share
    FacebookFacebook
    TwitterTwitter
    Email
    Click to copy link
    Link copied
    Close
    Cite
    Poidata.io (2025). Pizza Takeouts in Alabama, United States - 538 Available (Free Sample) [Dataset]. https://www.poidata.io/report/pizza-takeout/united-states/alabama
    Explore at:
    csvAvailable download formats
    Dataset updated
    May 10, 2025
    Dataset provided by
    Poidata.io
    Area covered
    Alabama, United States
    Description

    This dataset provides information on 538 in Alabama, United States as of May, 2025. It includes details such as email addresses (where publicly available), phone numbers (where publicly available), and geocoded addresses. Explore market trends, identify potential business partners, and gain valuable insights into the industry. Download a complimentary sample of 10 records to see what's included.

  20. p

    Pizza Takeouts in Indiana, United States - 822 Available (Free Sample)

    • poidata.io
    csv
    Updated May 30, 2025
    Share
    FacebookFacebook
    TwitterTwitter
    Email
    Click to copy link
    Link copied
    Close
    Cite
    Poidata.io (2025). Pizza Takeouts in Indiana, United States - 822 Available (Free Sample) [Dataset]. https://www.poidata.io/report/pizza-takeout/united-states/indiana
    Explore at:
    csvAvailable download formats
    Dataset updated
    May 30, 2025
    Dataset provided by
    Poidata.io
    Area covered
    Indiana, United States
    Description

    This dataset provides information on 822 in Indiana, United States as of May, 2025. It includes details such as email addresses (where publicly available), phone numbers (where publicly available), and geocoded addresses. Explore market trends, identify potential business partners, and gain valuable insights into the industry. Download a complimentary sample of 10 records to see what's included.

Share
FacebookFacebook
TwitterTwitter
Email
Click to copy link
Link copied
Close
Cite
Shi Long Zhuang (2022). 🍕🍽️ Pizza Restaurant Sales [Dataset]. https://www.kaggle.com/datasets/shilongzhuang/pizza-sales/code
Organization logo

🍕🍽️ Pizza Restaurant Sales

Eyy Pizza Lovers out there! Here's some data for you.

Explore at:
CroissantCroissant is a format for machine-learning datasets. Learn more about this at mlcommons.org/croissant.
Dataset updated
Oct 21, 2022
Dataset provided by
Kagglehttp://kaggle.com/
Authors
Shi Long Zhuang
Description

Contents

This pizza sales dataset make up 12 relevant features: - order_id: Unique identifier for each order placed by a table - order_details_id: Unique identifier for each pizza placed within each order (pizzas of the same type and size are kept in the same row, and the quantity increases) - pizza_id: Unique key identifier that ties the pizza ordered to its details, like size and price - quantity: Quantity ordered for each pizza of the same type and size - order_date: Date the order was placed (entered into the system prior to cooking & serving) - order_time: Time the order was placed (entered into the system prior to cooking & serving) - unit_price: Price of the pizza in USD - total_price: unit_price * quantity - pizza_size: Size of the pizza (Small, Medium, Large, X Large, or XX Large) - pizza_type: Unique key identifier that ties the pizza ordered to its details, like size and price - pizza_ingredients: ingredients used in the pizza as shown in the menu (they all include Mozzarella Cheese, even if not specified; and they all include Tomato Sauce, unless another sauce is specified) - pizza_name: Name of the pizza as shown in the menu

🍕The Pizza Challenge

For the Maven Pizza Challenge, you’ll be playing the role of a BI Consultant hired by Plato's Pizza, a Greek-inspired pizza place in New Jersey. You've been hired to help the restaurant use data to improve operations, and just received the following note:

Welcome aboard, we're glad you're here to help!

Things are going OK here at Plato's, but there's room for improvement. We've been collecting transactional data for the past year, but really haven't been able to put it to good use. Hoping you can analyze the data and put together a report to help us find opportunities to drive more sales and work more efficiently.

Here are some questions that we'd like to be able to answer:

  1. What days and times do we tend to be busiest?
  2. How many pizzas are we making during peak periods?
  3. What are our best and worst-selling pizzas?
  4. What's our average order value?
  5. How well are we utilizing our seating capacity? (we have 15 tables and 60 seats)

That's all I can think of for now, but if you have any other ideas I'd love to hear them – you're the expert!

Thanks in advance,

Mario Maven (Manager, Plato's Pizza)

Colllection Methodology

The public dataset is completely available on the Maven Analytics website platform where it stores and consolidates all available datasets for analysis in the Data Playground. The specific individual datasets at hand can be obtained at this link below: https://www.mavenanalytics.io/blog/maven-pizza-challenge

📌I set up the data model to include all the related instances in one single table so obtaining data for analysis is made easier.

My Inspiration

Complete details were also provided about the challenge in the link if you are interested. The purpose of uploading here is to conduct exploratory data analysis about the dataset beforehand with the use of Pandas and data visualization libraries in order to have a comprehensive review of the data and translate my findings and insights in the form of a single page visualization.

Search
Clear search
Close search
Google apps
Main menu