Pizza Sales Dashboard
Table of Content
Overview
I'm eager to share my dashboards for pizza sales! These visualizations provide a glimpse into data-driven decision-making, ranging from order insights to comprehensive revenue breakdowns.
Dependencies
- Excel
- PowerBI
Analysis
Overview Section
First page has a simple, clean style and highlights four key KPIs that provide an overview of the whole report.
Order Section
Investigate order-specific analytics, looking at patterns and consumer behavior. For more in-depth information, I've included a drill-down page that allows you to explore sizes, total pizza sales, categories, and average orders per hour.
Revenue Section
Get insightful information quickly on important company metrics and performance indicators. Make informed judgments by delving deeper into top sellers, revenue by day, and category with the use of interactive elements.
Details Section
Obtain thorough revenue data for every pizza, keeping track of components, sold pizzas, and the categories containing the best and worst-performing products. This section provides a detailed evaluation by showcasing the most and lowest revenue-generating pizzas. It also shows the average order amount and the average number of pizzas sold during peak hours. Here, we're using the Edit Interaction tool to preserve important KPIs.
Additional Analysis section
This gives the reports more depth and provides insightful information on profitable tips. I created engaging and interactive tooltips to improve the dashboard's appearance.
Insights from Analysis
- Total Orders - 21.35K
- Total Pizza Sold - 21.70K
- Pizza Sold at Peek Hours - 23
- Pizza Sold at Peek Day - Friday
- Best Selling Pizza - Big Meat Pizza
- Worst Selling Pizza - Barbecue Chicken Pizza
- Total Revenue - 356.72K