Pizza Sales Report

Business Challenge:

The pizza chain faced challenges in understanding its sales dynamics, including identifying peak sales periods, determining the best and worst-selling products, and recognizing which factors drive revenue growth. The goal was to leverage data to make informed decisions that enhance profitability and customer satisfaction.

Dashboard Overview:

The Power BI dashboard provides a comprehensive view of sales data from January to December 2015. Here are some key insights:

Total Revenue: $817.86K

Average Order Value: $38.31

Total Pizzas Sold: 49,574

Total Orders: 21,350

Average Pizzas per Order: 2.32

Key Insights:

Sales Trends:

Daily Peak: Orders peak on Fridays, suggesting increased demand at the end of the workweek.

Monthly Peak: Sales are highest in July and January, indicating possible seasonal influences or successful marketing campaigns.

Top Performing Pizzas:

The Classic, Barbecue, and Hawaiian pizzas lead in quantity sold, while the Thai Chicken and California pizzas top the revenue charts.

Product Categories:

The Classic category contributes the most to sales, with large-sized pizzas being the most popular choice among customers.

Underperforming Products:

Pizzas like The Spinach and The Mediterranean have lower sales, presenting opportunities for recipe refinement or targeted marketing strategies.

Recommendations:

Maximize Peak Sales Periods: Leverage Fridays and Saturdays with targeted promotions and special offers to boost sales.

Seasonal Campaigns: Implement strategic marketing initiatives during July and January to capitalize on peak demand.

Product Optimization: Focus on expanding popular pizza categories and sizes while exploring improvements for underperforming products.

Customer Feedback: Engage with customers to gather insights on preferences, enabling product improvements and personalized offerings.

Data-Driven Strategies: Continuously monitor sales data and adjust business strategies to align with evolving customer demands and market trends.