PIZZA Sales Dashboard
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
- Daily Trend for total Orders
- Hourly trend for Total Orders
- Percentage of sales by Pizza Category
- Percentage of sales by pizza size
- Total pizzas sold by pizza Category
- Top 5 Best sellers by total Pizzas sold
- Bottom 5 worst sellers
11 Nov 2023
Keywords
Data visualization
Dashboard Report
Problem solving
Data Manipulation
MySQL
