Order Fulfillment Performance Analysis
Introduction
This report presents a data-driven analysis of order fulfillment performance for different Pizza bun Products Between June 2022 to September 2022. Key metrics include total orders, total revenue, average revenue per order, and average discount given. The dashboard also visualizes the most ordered products, revenue trends by product, day wise total sales, and day wise total revenue. This analysis aims to provide a high-level overview of order fulfillment activity and identify areas for potential improvement.
Description in a form of Visualization :
-
Most Ordered Products
Graph Type: Bar Chart
Information: This chart displays the products that have been ordered most frequently. The x-axis lists the product names, and the y-axis represents the number of orders. By visually comparing the bar heights, you can easily identify the top-selling products.
Conclusion: This graph illustrates the relative popularity of different pizza varieties. Paneer Tikka Pizzabun emerges as a clear favorite, followed closely by Crispy Chole Pizzabun and Large Paneer Tikka Pizzabun. In contrast, Aloo Shots Pizzabun appears to be the least popular among the options shown.
-
Trend of Order Count for Each Day
Graph Type: Line Chart
Information: This chart shows how the number of orders has changed over time. The x-axis represents the days, and the y-axis represents the number of orders placed on each day. The line on the chart illustrates the trend of order volume, highlighting any peaks or dips in sales activity. This helps to understand daily order patterns.
Conclusion: This line chart illustrates the daily fluctuations in sales volume over the period shown. It reveals periods of high sales activity interspersed with periods of lower sales. The overall trend appears to be downward, indicating a decline in sales volume over time.
3. Trend of Revenue Generated for Each Day
Graph Type: Area Chart
Information: Similar to the previous chart, this line chart tracks the revenue generated each day. The x-axis represents the days, and the y-axis represents the total revenue generated on each day. The line shows the trend of revenue generation over time, revealing any fluctuations or patterns in daily revenue.
4. Trend of Revenue Generated for Each Product
Graph Type: Stacked Bar Chart (or potentially multiple line charts)
Information: This chart provides a comparison of revenue generated by each product. If it's a stacked bar chart, each bar represents a product, and the different segments within the bar represent revenue generated over different periods (e.g., daily, weekly, monthly). This allows for easy comparison of the revenue contribution of each product over time. If multiple line charts are used, each line represents a product, and the y-axis represents revenue. This also shows the revenue trend for each product over time.
Overall Conclusion
This analysis provides a detailed view of order fulfillment performance, revealing key trends and insights. A total of 403 orders were processed, generating a total revenue of 122,152.8 units. Paneer Tikka Pizza bun emerged as the top-selling product, both in terms of order volume and revenue contribution. The dashboard highlights significant fluctuations in daily sales and revenue, indicating the influence of factors like promotions, seasonality, or day-of-the-week effects. The ability to filter by order type allows for a granular analysis of online and offline sales performance, enabling data-driven decisions to optimize order fulfillment processes.