power Bi pizza sales performance
This Power BI dashboard explores pizza sales data to better understand customer ordering behavior, product performance, and operational patterns. Key metrics include total orders, average pizzas per order, revenue, top-selling pizza types, and peak demand periods. The dashboard also looks at seasonality, popular days of the week, and most frequent ordering times, offering a clear picture of when and what customers are ordering. These patterns provide valuable information for both strategic planning and daily operations.
(Summary of dashboard insights below visualization, as well as the ERD Diagram and process)
Dashboard Key Insights
The dashboard provides a clear view into customer ordering habits and sales performance across time, product type, and order size. By combining sales volume, timing, and product preferences, it helps explain when demand is highest and which items contribute most to overall revenue.
Friday and Saturday see the highest order counts, with peak activity between 12 PM and 3 PM, followed by 6 PM to 9 PM. These time blocks account for a large share of daily sales and are important windows for staffing and service planning.
Chicken pizzas lead in sales, with the Barbecue Chicken Pizza consistently holding the top spot. Large and medium pizzas are the most common sizes, suggesting a customer preference for shared meals or better value per order.
Sales remain fairly consistent throughout the year, with slight increases in the summer and slower months in early fall. Filtering by day or hour shows that top-selling items and size preferences hold steady across different customer segments.
Together, these patterns give a practical view of what sells, when, and in what form—supporting better decisions around operations, promotions, and product planning.
Data selection slice, seeing the stats for Friday, the best performing day
Seeing the data change for peak ordering hour between 12 – 3pm
Seeing the data change or medium sized pizzas and what time of day they are predominantly ordered
Process
Checking data quality
ERD Diagram
ERD Diagram tuning, adding a table for dates
Updated ERD Diagram, before relationships
Updated ERD Diagram, with newly formed relationship
We want to answer,
How many customers do we have each day?
We don’t have a customers column, so we’ll create a measure for count distinct.
Now, creating a measure for total sales
We also want to calculate peak times based on time slots that we have from orders
So we’ll create a calculated column for time slots first:
I need to create a manual time sorting column as there is only one column that can be automatically sorted by time by PBI. The one that’s sorted is the time stamp from which we derive the time slots column.
We’ll also create a measure for average orders/day
If we want to know that average pizzas per order, we’ll create a new measure for that:
The rest is styling the dashboard…
