Oven Joy Pizzeria Sales Report

Welcome to the Oven Joy Pizzeria Sales Report project! This repository contains SQL queries and corresponding visualizations created using Power BI for analyzing the sales data of Oven Joy Pizzeria and gain impactful insights from it.

You can Check out the dashboard here

Key Performance Indicators (KPIs)

1. Total Revenue Generates

   select sum(total_price) as total_revenue
   from pizza_sales;

   

2. Average Order Value

   select (sum(total_price)/count(distinct order_id)) as average_order_value
   from pizza_sales;

   

3. Total Pizza Sold

   select sum(quantity) as total_pizza_sold
   from pizza_sales;

   

4. Total Pizza Sold

   select count(distinct order_id) as total_order_placed
   from pizza_sales;

   ...

5. Daily Trend

   SELECT to_char(order_date, 'Day') AS order_day, COUNT(DISTINCT order_id) AS total_orders
   FROM pizza_sales
   GROUP BY to_char(order_date, 'Day');

   

6. Monthly Trend

   SELECT to_char(order_date, 'Month') AS order_month,
   COUNT(DISTINCT order_id) AS total_orders
   FROM pizza_sales
   GROUP BY to_char(order_date, 'Month');

   
   

...

Pizza Type Analysis

1. Total Revenue Percentage by Pizza category

   select pizza_category,
   sum(total_price) *100 / (select sum(total_price) from pizza_sales)
   as pizza_cat_percent
   from pizza_sales
   group by pizza_category;

   

2. Total Revenue Percentage by Pizza size

   select pizza_category,
   sum(total_price) *100 / (select sum(total_price) from pizza_sales)
   as pizza_cat_percent
   from pizza_sales
   group by pizza_category;

   

3. Total Pizza Sold by Pizza category

   select pizza_category,
   sum(total_price) *100 / (select sum(total_price) from pizza_sales)
   as pizza_cat_percent
   from pizza_sales
   group by pizza_category;

   ...

Bestsellers and Worst sellers

1. Top 5 Pizzas by Revenue

   select pizza_name,
   sum(total_price) as pizza_revenue,
   count(pizza_id) as no_of_orders
   from pizza_sales
   group by pizza_name
   order by pizza_revenue desc
   limit 5;

   

2. Top 5 Pizzas by Total Quantity

   select pizza_name, sum(quantity) as pizza_qnt
   from pizza_sales
   group by pizza_name
   order by pizza_qnt desc
   limit 5;

   

3. Top 5 Pizzas by Total Order

   SELECT pizza_name, COUNT(DISTINCT order_id) AS Total_Orders
   FROM pizza_sales
   GROUP BY pizza_name
   ORDER BY Total_Orders DESC
   limit 5;

   

4. Bottom 5 Pizzas by Revenue

   select pizza_name,
   sum(total_price) as pizza_revenue,
   count(pizza_id) as no_of_orders
   from pizza_sales
   group by pizza_name
   order by pizza_revenue
   limit 5;

   

5. Bottom 5 Pizzas by Total Quantity

   select pizza_name, sum(quantity) as pizza_qnt
   from pizza_sales
   group by pizza_name
   order by pizza_qnt
   limit 5;

   

6. Bottom 5 Pizzas by Total Order

   SELECT pizza_name, COUNT(DISTINCT order_id) AS Total_Orders
   FROM pizza_sales
   GROUP BY pizza_name
   ORDER BY Total_Orders
   limit 5;

   

...

Power BI Dashboard

The dashboard allows you to filter the analysis based on Pizza category, offering a comprehensive view of sales performance for each category. Additionally, you can leverage the sliders to narrow down the data within specific date ranges, providing you with the flexibility to analyze trends and patterns over time.

Insights

• Orders are highest on weekends, i.e. on Friday/Saturday evenings.
• There are maximum orders from month of July and January.
• Classis Category of Pizzas contributes the most to total order and maximum sale.
• The Thai Chicken Pizza generates the most revenue.
• The Chicken Deluxe Pizza contributes the most to total order and total quantity.
• The Brie Carre Pizza contributes the least to total order & total quantity and generates the least revenue.

Feel free to navigate through the dashboard and uncover more valuable insights. Should you have any questions or suggestions, please don't hesitate to reach out. Happy exploring!