Tools Used: Power BI | Excel | SQL | Data Cleaning
Project Overview
I transformed a complex dataset of pizza transactions into a high-impact, interactive dashboard designed to optimize restaurant operations. The goal was to identify peak ordering times, popular products, and sales trends to improve inventory management and staffing.
Key Features & Insights
Sales Performance Tracking: Real-time visibility into Total Sales ($152K) and order volumes to track growth against business goals.
Peak Time Analysis: Identified that orders peak significantly during the evening hours (51.87%), allowing for better staff scheduling.
Product Popularity: Segmented sales by category, showing that "Classic" pizzas drive the highest volume (15K orders).
Customer Behavior: Analyzed order patterns by day of the week, pinpointing high-demand days to optimize marketing spend.
The Technical Edge
To build this, I performed extensive Data Cleaning and transformation to ensure accuracy across thousands of rows. I focused on a "clean-UI" design approach to ensure that even non-technical stakeholders can find answers in seconds.
Why this matters for your business:
"Data is just numbers until you can see the story. I build dashboards that help you stop guessing and start growing based on facts."
Project Title: Pizza Sales Insights Dashboard
Tools Used: Power BI | Excel | SQL | Data Cleaning
Project Overview
I transformed a complex dataset of pizza tr...