Pizzas Sales Dashboard

Tools Used:

MS SQL Server

MS Power BI

Dataset Overview:

This dataset encompasses pizza sales data spanning from January 1, 2023, to December 31, 2023. It includes key attributes such as pizza name, size, category, order date, unit price, total price, and more, providing a comprehensive view of sales performance.

Key Insights:

*Peak Order Periods – The highest number of orders were placed in January and July.

*Top-Performing Pizzas – The Classic Deluxe Pizza recorded the highest number of orders, while The Thai Chicken Pizza generated the highest revenue.

*Lowest Sales Performance – The Brie Carri Pizza had the lowest revenue and order count.

*Category Performance – The Classic category leads in both total sales and order volume.

*Size Contribution – Large-sized pizzas account for the highest revenue share, highlighting customer preference for larger portions.

This analysis provides valuable insights into consumer preferences, seasonal trends, and revenue drivers, aiding in strategic decision-making for inventory management, marketing, and pricing strategies.