Data Analysis on Pizza Sales Using SQL
Dataset ->
The dataset used for this analysis contains information about pizza orders, including customer details, order dates, pizza types, quantities ordered, prices, and delivery information. It may also include additional data such as delivery times, and order statuses.
SQL Queries ->
The analysis involves writing SQL queries to extract, transform, and analyze data from the dataset. Sample SQL queries for various objectives include:
Retrieve Basic Information:
- Retrieve the total number of orders placed.
- Calculate the total revenue generated from pizza sales. Pizza Analysis:
- Identify the highest-priced pizza.
- Identify the most common pizza size ordered.
- List the top 5 most ordered pizza types along with their quantities.
- Join tables to find the total quantity of each pizza category ordered.
- Determine the top 3 most ordered pizza types based on revenue.
- Calculate the percentage contribution of each pizza type to total revenue. Order Analysis:
- Determine the distribution of orders by hour of the day.
- Group orders by date and calculate the average number of pizzas ordered per day.
- Analyze the cumulative revenue generated over time.
