Pizza Sales Analysis
Leveraged SQL for data extraction and transformation, and Power BI for dynamic visualization to analyze a full year (2015) of pizza sales data. I created interactive dashboards that highlighted key business insights, including total revenue (~$818K), average order value, and sales trends by day, month, pizza category, and size. The analysis identified that classic pizzas and large sizes were the most popular, with peak orders occurring on weekends. Additionally, ranked best and worst-selling pizzas by revenue, quantity, and order frequency, enabling strategic decisions for product optimization.
Dashboard