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, is calculated by dividing the total number of pizzas sold by the total number of orders.
• Tableau dashboard for Pizza Franchise Sales with 45k+ rows w.r.to different KPIs and Problem statement.

The identified requirements for creating charts:

• Hourly Trend for Total Pizzas Sold: Created a stacked bar chart that displays the hourly trend of total orders over a specific time period. This chart will help us identify any patterns or fluctuations in order volumes on an hourly basis.
• Weekly Trend for Total Orders: Created a line chart that illustrates the weekly trend of total orders throughout the year. This chart will allow us to identify peak weeks or periods of high-order activity.
• Percentage of Sales by Pizza Category: Created 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.
• Percentage of Sales by Pizza Size: Generated 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: Created 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.
• Top and bottom 5 Best Sellers by Revenue, Total Quantity and Total Orders

Thanks for visiting!!