Pizza Sales Data Analysis for Business Growth
Budget: $2 – $8 USD
I conducted sales analysis project for a pizza restaurant chain to help them understand customer preferences, optimize menu offerings, and increase revenue. The project involved analyzing transaction data, customer orders, and sales trends over a 12-month period.
Key Actions Taken:
Collected and cleaned order data, including pizza types, sizes, toppings, and order times.
Built dynamic Excel dashboards showing daily, weekly, and monthly sales performance.
Identified the best-selling pizza types, peak sales hours, and customer ordering patterns.
Used data validation and automated calculations to ensure accurate, real-time tracking.
Recommended menu changes based on profit margin analysis for different pizza items.
Business Problems Solved:
Increased overall sales by 17% by optimizing promotional offers based on peak demand times.
Reduced food waste by 20% through better inventory planning linked to sales forecasts.
Identified underperforming menu items, leading to a more profitable and simplified menu.
Improved delivery time efficiency by analyzing and adjusting kitchen workflow based on order volume patterns.
Skills Used:
Advanced Excel (PivotTables, Charts, Conditional Formatting, Formulas)
Data Cleaning and Validation
Sales Trend Analysis and Forecasting
Business Intelligence Reporting
Key Actions Taken:
Collected and cleaned order data, including pizza types, sizes, toppings, and order times.
Built dynamic Excel dashboards showing daily, weekly, and monthly sales performance.
Identified the best-selling pizza types, peak sales hours, and customer ordering patterns.
Used data validation and automated calculations to ensure accurate, real-time tracking.
Recommended menu changes based on profit margin analysis for different pizza items.
Business Problems Solved:
Increased overall sales by 17% by optimizing promotional offers based on peak demand times.
Reduced food waste by 20% through better inventory planning linked to sales forecasts.
Identified underperforming menu items, leading to a more profitable and simplified menu.
Improved delivery time efficiency by analyzing and adjusting kitchen workflow based on order volume patterns.
Skills Used:
Advanced Excel (PivotTables, Charts, Conditional Formatting, Formulas)
Data Cleaning and Validation
Sales Trend Analysis and Forecasting
Business Intelligence Reporting