A Power BI and SQL Project that analyzes key indicators of pizza sales data to gain valuable insights. KPI's Requirement:
- Total Revenue: The sum of the total price of all pizza orders.
- Average Order Value: The average amount spent per order, calculated by dividing the total revenue by the total number of orders.
- Total pizzas sold: The sum of the quantities of all pizzas sold.
- Total Orders: The total number of orders placed.
- Average Pizzas per Order: The average number of pizzas sold per order, calculted by dividing the total number of pizzas sold by the total number of orders.
Chart's Requirement:
- Daily trend for total orders: A bar chart that displays the daily trend of total orders over a specific time period. This chart will help us identify any patterns or fluctuations in order volumes on a daily basis.
- Monthly Trend for total orders: A line chart that illustrates the hourly trend of total orders throughout the day. This chart will allow us to identify peak hours or periods of high order activity.
- 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 contrubution to overall sales.
- Percentage of sales by pizza size: A pie chart that represents the percentage of sales attributed to different pizza sizes. This chart will help us understand customer preferences for pizza sizes and their impact on sales.
- Total pizzas sold by pizza category: 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 categories.
#Snapshots!!