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
- Total Revenue
- Average Order Value
- Total Pizzas Sold
- Total Order
- Average Pizzas Per Order
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:
- Daily Trend for Total Orders
- Monthly Trends 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 Revenue, Total Quantity and Total Orders
- Bottom 5 Best Sellers by Revenue, Total Quantity and Total Orders
