Welcome to the Pizza Sales Data Analysis project for Warner & Spencer Italian Pizza Company. This project involves using Microsoft Excel to perform an in-depth analysis of sales data to uncover trends, customer preferences, and key performance metrics. The insights derived from this analysis will help inform strategic business decisions and improve overall performance.
Warner & Spencer Italian Pizza Company has been dedicated to serving delicious pizzas to customers. To enhance operations and better understanding of market, we conducted a detailed data analysis of sales records. This project leverages Excel’s powerful data analysis tool to provide actionable insights into pizza sales.
- Sales Performance Analysis: View sales performance across different time periods.
- Product Insights: Analyze which pizza products are performing best.
- Customer Insights: Understand customer preferences and purchasing behavior.
- Interactive Filters: Use slicers and filters for detailed analysis.
- Interactive Dashboards: Utilize Excel’s capabilities to create interactive and dynamic dashboards.
The data used in this project includes:
- Sales and Product Data: Detailed sales transactions including date, product, quantity, amount and pizza products offered by Warner & Spencer.
- Summary Dashboard: An overview of key metrics and trends.
- Sales KPI: Displays total sales, average sales, total units solds and total orders
- Weekly and hourly Trends: Provides insights into the peak purchasing hours and weekdays.
- Sales Metrics: Measuring sales performance by pizza category and sizes.
- Top Products: Shows the best-selling pizza products by quantity.
- Worst Products: Shows the worst-selling pizza products by quantity.