PIZZA Sales Dashboard 
 

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

Client Requirement

1. Daily Trend for total Orders
2. Hourly trend for Total Orders
3. Percentage of sales by Pizza Category
4. Percentage of sales by pizza size
5. Total pizzas sold by pizza Category
6. Top 5 Best sellers by total Pizzas sold
7. Bottom 5 worst sellers