This dashboard provides a comprehensive overview of Pizza Sales Performance. Key insights and KPIs presented are: Total Revenue: $817.86K, reflecting overall sales performance. Total Orders: 21,350 total orders made within the reporting period. Average Order Value: $38.31, indicating the average spending per order. Average Pizzas Per Order: 2.32, highlighting the number of pizzas purchased per transaction. Total Pizzas Sold: 49,574 pizzas. The dashboard also shows: Top 5 and Bottom 5 Pizzas by Revenue, Quantity, and Total Orders, providing insights into the best and worst-performing pizzas. This data helps identify customer preferences and underperforming products for further analysis.
This dashboard focuses on Sales Trends and Performance Metrics for better decision-making. Key insights include: Monthly Trend for Total Orders : Displays the fluctuation of orders across months, highlighting peak months (July and May). Daily Trend for Total Orders : Shows which days of the week see the highest sales, with Friday and Thursday leading. Sales by Category : Classic and Supreme pizzas dominate sales, accounting for significant market share. Sales by Size : Large (45.9%) and Medium (30.5%) pizzas are the most popular sizes. Total Revenue Per Category : Classic pizzas generate the highest revenue at $220.05K, followed by Supreme at $208.19K.
These dashboards collectively provide a detailed analysis of sales performance, customer preferences, and product-level insights. They enable decision-makers to identify top-performing products, optimize offerings, and adjust strategies to boost revenue and efficiency.
View an interactive dashboard in my portfolio : https://mavenanalytics.io/project/23282