Broadway Pizza Analytics

Developed a specialized Power BI analytics solution for Broadway Pizza across multiple locations. The platform included dashboards for real-time sales tracking, inventory management, staff performance, and customer behavior. Integrated Python and Excel for data transformation and automation to streamline reporting and insights generation for key stakeholders.

Key Features

• Multi-location sales analytics
• Inventory tracking and wastage insights
• Employee and outlet performance dashboards
• Customer behavior and retention analysis

Challenges

• Unifying multi-location data sources
• Real-time reporting and refresh schedules
• Modeling complex business KPIs

Results

• 25% reduction in operational costs
• Enabled real-time visibility across branches
• 15% increase in average revenue per outlet