Welcome to my Pizza Sales Analysis project! This repository contains SQL queries and analyses aimed at optimizing Pizza Hut's sales performance through data-driven insights.
- Analysis of pizza sales trends and revenue metrics.
- Insights for menu optimization and marketing strategies.
• MySQL
- Total Orders: Retrieval of the total number of orders placed provides a baseline for understanding customer demand and optimizing inventory management.
- Total Revenue: Calculation of total revenue generated from pizza sales offers a key metric for assessing financial performance and guiding strategic decisions.
- Highest-Priced Pizza: Identification of the highest-priced pizza helps optimize pricing strategies and enhance profitability.
- Most Common Pizza Size: Analysis of the most common pizza size ordered informs inventory planning and ensures customer satisfaction.
- Top 5 Pizza Types: Listing the top 5 most ordered pizza types along with their quantities guides menu optimization and marketing efforts.
- Category-Wise Pizza Distribution: Joining relevant tables to find the distribution of pizzas by category enables targeted menu optimization and marketing strategies.
- Orders Distribution by Hour: Determining the distribution of orders by hour of the day helps optimize staffing and resource allocation for efficient operations.
- Cumulative Revenue Analysis: Analyzing cumulative revenue generated over time provides insights into sales performance trends and informs strategic planning.
- Percentage Contribution of Pizza Types: Calculating the percentage contribution of each pizza type to total revenue guides menu optimization and pricing strategies.
- Top 3 Pizza Types by Revenue: Determining the top 3 most ordered pizza types based on revenue within each pizza category helps prioritize menu offerings and marketing efforts.
To access the analyses:
- Clone the Repository: Clone this GitHub repository to your local machine.
- Import SQL Files: Use MySQL or your preferred SQL client to import and execute the SQL files.
- Explore Insights: Review the results of the SQL queries to gain insights into pizza sales performance.
The data used in this analysis is sourced from Pizza Hut's sales database, containing information on pizza orders, revenue, and menu items.
If you have any feedback or suggestions for improving the analyses, feel free to open an issue or submit a pull request. Your input is valuable in enhancing the quality and relevance of this project.