View Power BI Dashboard View on GitHub

Project Overview

Conducted a pizza sales report challenge from Maven Analytics.I'm supposed to be a business intelligence consultant employed by for a Greek-inspired pizza shop in New Jersey, focusing on data analysis to enhance operations. The restaurant hired me to assist in using data to boost operations. Analyzed a real-world business case for a Pizza restaurant to enhance the restaurant's operations.

Key Insights

• Analyzed over 50,000 records to identify patterns in customer demand, operational bottlenecks, and efficiency improvements.
• Constructed ETL pipelines, transforming sales data into Power BI insights with advanced DAX measures.
• Utilized Microsoft Power BI and MSSQL for data processing and visualization.
• Constructed ETL pipelines to transform sales data into actionable insights.
• Employed Power Query for data extraction, transformation, and loading.
• Developed a dynamic dashboard displaying 15+ KPIs, including sales trends and customer demographics.
• Addressed 5 key business questions on inventory management, peak hours, and operations to improve efficiency.
• Recommended 7 key improvements projected to increase revenue by 3%, optimizing inventory, labor, and service.

Key Findings

• Busiest Days and Times: Peak order volume occurs at 12 PM & 1 PM (lunch) and 5 PM - 6 PM (evening), with Thursdays, Fridays, and Saturdays being the busiest days.
• Pizzas Made During Peak Periods: On Thursdays at noon, the restaurant produces 2,520 pizzas.
• Best and Worst-Selling Pizzas: The best-selling pizza is the Classic Delux Pizza, while the worst is the Brie Carre Pizza.
• Average Order Value: The average order value is approximately $38.30.
• Proposed seven strategic improvements projected to increase revenue by 3%, focusing on optimizing inventory, labor, and service.

Tools Used