Vikas Dhakad

pizzahut sales project

**Summary of Pizza Hut Sales Report **

• Introduction

  • Presented by Vikas Dhakad.
  • Overview of pizza sales performance, including successes, challenges, and strategic insights.
  • Emphasis on the narrative behind the numbers and the impact of sales strategies.

• Key Queries Addressed

  1. Total number of orders placed.
  2. Total revenue generated from pizza sales.
  3. Highest-priced pizza identified.
  4. Most common pizza size ordered.
  5. Top 5 most ordered pizza types with their quantities.
  6. Total quantity of each pizza category ordered through table joins.
  7. Distribution of orders by hour of the day.
  8. Category-wise distribution of pizzas through relevant table joins.
  9. Average number of pizzas ordered per day, grouped by date.
  10. Percentage contribution of each pizza type to total revenue.
  11. Cumulative revenue generated over time.
  12. Top 3 most ordered pizza types based on revenue for each pizza category.

• Conclusion

  • The report encapsulates a comprehensive analysis of sales data, providing insights into customer preferences and revenue generation strategies.
  • Acknowledgment of the collective efforts that contributed to the sales performance.

• Thank You for showing intrest