07-31-2023 00:27 AM - last edited 09-13-2023 12:27 PM
FP20 ANALYTICS CHALLENGE 6 " Restaurant Food Delivery Analysis"
we delve into the world of food
delivery services, a rapidly evolving market that is shaping the future of the restaurant industry.
As more and more people opt for the convenience of having food delivered right to their
doorstep, understanding the underlying dynamics of this industry becomes increasingly
Task is to analyze this data and uncover insights that could help improve efficiency,
profitability, and customer satisfaction. You will need to interpret the data, identify key trends
and patterns, and present your findings in a clear, comprehensive, and compelling way.
While it's encouraged to explore the dataset and come up with unique and innovative KPIs, here
are a few potential metrics that participants could consider for our client:
1. Average Delivery Time: The time it takes from when an order is placed to when it is
delivered. This KPI is crucial for measuring the efficiency of the delivery service.
2. Driver Efficiency: This can be determined by calculating the number of deliveries
completed per hour by each driver.
3. Order Completion Rate: The percentage of orders that are successfully delivered versus
those that are refunded. This can be a measure of customer satisfaction and operational
4. Average Tip per Delivery: This can serve as a proxy for customer satisfaction and could
be used to reward high-performing drivers.
5. Peak Ordering Times: Understanding when most orders are placed can help with
resource allocation and planning
It seems like such an intriguing report! We're curious on how you did the visual with delivery times (screenshot included), could you, please, share the pbix file or just give us some instructions on how you created this visualization?