This project features an interactive Power BI dashboard designed to analyze pizza sales data. The goal was to transform raw sales data into actionable business insights, specifically focusing on product performance, order patterns, and revenue trends.
- Power BI Desktop: Used for data modeling, visualization, and report development.
- DAX (Data Analysis Expressions): Used to create custom measures for key performance indicators (KPIs) such as Total Revenue, Total Orders, and Total Pizzas Sold.
- Data Modeling: Established a Star Schema by creating relationships between sales, orders, and product lookup tables.
Based on the analysis, the following trends were identified:
- Product Performance: The Classic Deluxe Pizza is the top-performing item by revenue, followed closely by the Hawaiian and Pepperoni pizzas. This indicates a strong customer preference for traditional, established menu items.
- Category Trends: The Classic category is the primary driver of revenue, significantly outperforming other pizza categories in the current dataset.
- Operational Patterns: The dashboard highlights a clear correlation between order volume and revenue generation, enabling better inventory management based on high-demand items.
- Executive KPIs: Real-time visibility into Total Revenue, Total Orders, and Total Pizzas Sold via top-level cards.
- Interactive Filtering: Allows users to filter the entire report by Pizza Category to drill down into specific segments.
- Trend Analysis: A dynamic line-and-column chart that visualizes revenue and order trends over time.
- Top Performers: A ranked bar chart highlighting the top 5 best-selling pizzas by revenue.