POWER BI DASHBOARD
-
Dashboard of a pizza store’s operations, providing a detailed overview of the store’s transactions, prices, quantities, and total revenue. The store operates at various times of the day, with the highest number of orders occurring at 13:00 and the lowest at 22:00.
-
The “ Quantity by Day” graph reveals that Friday and Saturday see the highest sales, while the rest of the week records relatively lower sales. This could be due to customer habits or promotional activities conducted on these days.
-
The total revenue generated is ₹818K with a total of 49,574 pizzas sold across various categories and sizes. The average order value stands at ₹17. In terms of pizza categories, Classic leads with 14.58K (29.9%) pizzas sold, followed by Veggie at 11.45K (23.5%), Chicken at 10.82K (22%), and Supreme at 11.78K (24%).
From these observations, several strategies can be derived to improve the store’s performance. For instance, special offers or events could be organized during low-order times like post-19:00 hours to attract more customers and boost sales. Additionally, Sunday to Wednesday sees lower sales compared to the rest of the week; hence introducing weekday special offers or combo deals can stimulate sales growth on these days. The Supreme category, being the lowest-selling product, could benefit from targeted marketing strategies to increase its visibility and attractiveness to customers. This could be achieved through combo deals or highlighting it in-store displays. In conclusion, the data presented in the dashboard offers valuable insights into the store’s operations and performance. By leveraging this data, the store can devise effective strategies to improve its profitability and ensure the growth of low-performing products.