Pizza Sales Report and Dashboard Overview
Created by: Shubham Vaishnav Date: Aug 2023
Report Summary: The following overview provides insights into the pizza sales report and dashboard created using SQL Server, Power BI, and MS Excel. The objective of this project was to analyze key performance indicators (KPIs) related to pizza sales, allowing the business to gain valuable insights into its performance. The report addresses specific KPIs, such as total revenue, average order value, total pizzas sold, total orders, and average pizzas per order. Additionally, the dashboard presents a variety of charts and visualizations to help understand trends and patterns within the pizza sales data.
Software Used:
- MS Office Suite: Excel for data manipulation and preliminary analysis.
- MS SQL Server 19.0: Database management and data retrieval.
- SQL Server Management Studio: Query development and execution.
- Power BI (June 2023): Data visualization and dashboard creation.
Problem Statement and KPIs Requirement: The project aimed to analyze pizza sales data and provide insights into key performance indicators. The problem statement revolved around calculating and visualizing various metrics to gauge business performance.
The specific KPIs included:
- Total Revenue
- Average Order Value
- Total Pizzas Sold
- Total Orders
- Average Pizzas Per Order
Charts Requirement: The report and dashboard include various charts to visualize different aspects of the pizza sales data:
- Daily Trend for Total Orders: A stack column chart illustrating the daily trend in the total number of orders, helping to identify patterns and spikes in order volume.
- Monthly Trend for Total Orders: In this we are using an Area chart to display the monthly variation in total orders, aiding in understanding larger sales trends over time.
- Percentage of Sales by Pizza Category: A donut chart showcasing the distribution of sales revenue among different pizza categories, revealing which categories are more popular among customers.
- Percentage of Sales by Pizza Size: Another donut chart that highlights the sales distribution across various pizza sizes, offering insights into customer preferences.
- Total Pizzas Sold by Pizza Category: A funnel chart depicting the total number of pizzas sold for each pizza category, helping to understand the volume of sales for different types of pizzas.
- Top 5 Best Sellers: Three bar charts revealing the top 5 best-selling pizzas based on revenue, total quantity, and total orders, respectively.
- Bottom 5 Best Sellers: Similar to the top sellers, these charts showcase the bottom 5 performers based on revenue, total quantity, and total orders.
Screenshots:
Value Delivered: The report and dashboard provide actionable insights into the pizza sales data, allowing the business to make informed decisions. By analyzing the KPIs and visualizing trends, the company can identify successful products, understand customer preferences, and make strategic choices to enhance overall business performance. The interactive nature of the Power BI dashboard also allows users to drill down into specific data points for deeper analysis, making it a powerful tool for decision-making..
In conclusion, the pizza sales report and dashboard represent a comprehensive approach to analyzing and visualizing key metrics and trends in pizza sales data, enabling the business to gain valuable insights for growth and optimization.