This Pizza Place Sales Analysis project focuses on identifying key factors behind a decline in sales and offering actionable, data-driven strategies to improve performance and customer satisfaction. By analyzing sales data from January to December 2015, we uncovered crucial insights into customer preferences, peak ordering times, popular pizza choices, and pricing trends.

The project explores the restaurant's operational metrics using Excel functions like Pivot Tables, COUNT, and AVERAGE, helping the business identify underperforming menu items, optimize promotions, and adjust pricing strategies. Our analysis revealed key insights, such as peak sales periods, customer behavior, and the impact of promotions on sales. Based on these findings, we proposed solutions like weekday deals, seasonal pizza offerings, and improved staff training and loyalty programs to drive customer engagement and boost sales.

The 5Ps framework—Product, Pricing, Promotion, Place, and People—guided our recommendations, ensuring a well-rounded approach to revamping the restaurant’s operations and driving sustainable growth.