Food Delivery Service Analytics

This is a PowerBI dashboard created for a Food Delivery Service company. I have answered a few business questions in this analysis. The questions were as follows -

Q1. What is the total number of orders catered by the firm? Add a date filter in the dashboard. Analysis - 120M

Q2. What is the revenue earned by the firm? Analysis - $31.92bn

Q3. What is the total discounted value? What is the overall discount percentage? Analysis - Total Discounted Value = $3.9 bn, Total Discount percentage = 11.04%

Q4. Is the business following the Pareto principle? Analysis - More than 20% of the centres are generating 80% of the revenue. Hence, the business is not following Pareto's Principle.

Q5. What are the top 5 selling categories? Analysis - Beverages, Rice bowls, Sandwich, Salad, Pizza.

Q6. Does the operational area of the store influence number of orders? Analysis - With the increase in the operational area, the number of orders increases.

Q7. Are Emails & product features on the Homepage an effective mode of promotion? Analysis - I can see that 8% of email promotions generate 20% of the revenue, and 11% of homepage-featured promotions generate 23% of the revenue. Hence, these two are effective modes of promotion.

Q8. What will be the next 5 weeks forecasted weekly quantity sold for each centre, city, and meal category? Analysis - The predicted sales range from 0.6 to 1.0 million for the next 5 weeks.