A food delivery platform aims to improve customer satisfaction and operational efficiency. The objective of this analysis is to identify key revenue drivers, evaluate delivery performance, and understand customer behavior patterns.
The analysis focuses on:
The dataset contains 1,898 food delivery orders with details on customer behavior, restaurant performance, and operational metrics.
| Column | Description |
|---|---|
| Order ID | Unique order identifier |
| Customer ID | Unique customer |
| Restaurant Name | Restaurant |
| Cuisine Type | Type of cuisine |
| Cost of Order | Order value |
| Day of Week | Order timing |
| Rating | Customer satisfaction |
| Food Preparation Time | Prep time |
| Delivery Time | Delivery duration |
Data loaded in Power Query
Cleaning column names
Created a new column combining preparation and delivery time to analyze total service efficiency.
Created a Conditional column of order value category
This analysis highlights which cuisines contribute the most to overall revenue, helping identify key business drivers.
Revenue By Cuisine