Pizza Sales Analysis

Problem & background

Problem: - Pizza restaurant has recently seen a decline in sales and plans to increase them by looking at customer and order data. To do this, the management plans to perform a thorough analysis of order data and consumer behaviour in order to spot important trends and areas for improvement.

Background: - An overview of pizza sales data from January 2015 to December 2015 is given in this report. To find trends and patterns in pizza sales, data was gathered from pizza joints across the United States and analyzed. Solution In response to declining sales, we propose an integrated solution that combines data analysis, data-driven insights, and stakeholder engagement.

Data Analysis: -

➢ Conducted an in-depth analysis of pizza sales data to identify critical patterns and opportunities for improvement.

➢ Leverage Excel to create data tables that can be used to store and analyze sales data.

➢ Utilize Excel to create dynamic dashboards that can be used to visualize sales data and identify trends.

Data Driven Insights: -

➢ Using the insights gained from data analysis to identify the factors that are driving declining pizza sales.

➢ Develop targeted strategies to address the identified factors.

➢ For example, if data analysis reveals that sales are declining on weekdays, the pizzeria could offer discounts or promotions on weekdays to encourage more orders.

➢ If data analysis reveals that customers are unhappy with the quality of the ingredients, the pizzeria could take steps to improve the quality of the ingredients or the cooking process.