Problem Statement

The objective of this project is to analyze the sales data of a pizza company to gain insights into their sales performance, customer behavior, and popular pizza types.

Project Steps:

1. Data Collection: Collect sales data from the pizza company, including information such as order date, pizza type, quantity, price, and customer details.
2. Data Cleaning: Clean the data to remove any inconsistencies, missing values, or duplicates. Ensure that the data is in a format suitable for analysis.
3. Data Storage: Store the cleaned data in a MySQL database to facilitate easy access and management.
4. Data Analysis: Use Power BI to connect to the MySQL database and create visualizations to analyze the sales data.
5. Data Visualization: Create interactive dashboards and reports in Power BI to visualize the analysis results. Use charts, graphs, and tables to present the data in a clear and insightful manner.
6. Insights and Recommendations: Based on the analysis, derive insights into the sales performance and customer behavior. Provide recommendations to improve sales and customer satisfaction.
7. Final Presentation: Prepare a final presentation summarizing the analysis findings, insights, and recommendations. Present the findings to stakeholders for decision-making.

KPI’s Requirement

We need to analyze key indicators for our pizza sales data to gain insights into our business performance. Specifically, we want to calculate the following metrics:

1. Total Revenue: The sum of total price of all pizza orders.
2. Average Order Value: The amount spent per order, calculated by dividing the total revenue by the total number of orders.
3. Total Pizza Sold: The sum of quantities of all pizza sold.
4. Total Orders: Total number of orders placed.
5. Average Pizza Per Order: The average number of pizzas sold per order, calculated by dividing the total number of pizzas sold by the total number of orders.

Charts Requirement

We would like to visualize various aspects of our pizza sales data to gain insights and understand key trends. We have identified the following requirements for creating charts:

1. Daily Trend for Total Orders: Create a bar chart that displays the daily trend of total orders over a specific time period. This chart will help us identity any patterns or fluctuations in order volumes on a daily basis.
2. Monthly Trend for Total Orders: Create a line chart that illustrate the hourly trend of total orders throughout the day. This chart will allow us to identify peak hours or periods of high order activity.
3. Percentage of Sales by Pizza Category: Create a pie chart that shows the distribution of sales across different pizza categories. This chart will provide insights into the popularity of various pizza categories and their contribution to overall sales.
4. Percentages of Sales by Pizza Size: Generate a pie chart that represent the percentage of sales attributed to different pizza sizes. This chart will help us understand customer preference for pizza sizes and their impact on sales.
5. Total Pizzas Sold by Pizza Category: Create a funnel chart that presents the total number of pizzas sold for each pizza category. This chart will allow us to compare the sales performance of different pizza category
6. Top 5 Best Sellers by Revenue, Total Quality and Total Orders: Create bar chart highlighting the top 5 best-selling pizzas based on revenue, total quality and total orders. This chart will help us identify the most popular pizza option.
7. Bottom 5 Worst Sellers by Revenue, Total Quality and Total Orders: Create bar chart highlighting the Bottom 5 worst-selling pizzas based on revenue, total quality and total orders. This chart will help us identify the underperforming of less popular pizza option.

Benefits:

This project will help the pizza company understand its sales trends, customer preferences, and areas for improvement. It will enable data-driven decision-making to drive business growth and customer satisfaction.