📊 Key Performance Indicators
Total Orders
—
all time
Delivery Rate
—
delivered
—
Avg KPT
—
mins (kitchen prep)
—
Avg Rider Wait
—
mins at outlet
—
Avg Rating
—
rated orders only
—
Rejection Rate
—
of total orders
—
🚨 Business Problem Alerts
🔴 High KPT Stores (>30 mins avg)
🟡 High Rider Wait Stores (>10 mins avg)
🔴 High Cancellation Rate (>10%)
📈 Order & Operations Analytics
🏙️ Orders by City
🍽️ Orders by Brand
⏰ Orders by Slot
📊 Hourly Order Volume
📋 Order Status Mix
⭐ Customer Feedback & Issue Analysis
🏷️ Review Tag Distribution
Quality⭐ Rating Distribution
⏱️ Avg KPT by Brand (mins)
Ops🏍️ Avg Rider Wait by Brand (mins)
❌ Cancellation by City
Risk🏪 Store-Level Performance
📋 Store Performance Summary (sorted by Orders)
| Store | City | Brand | Orders | Delivered | Rejected | Delivery% | Avg KPT | Avg RWT | Avg Rating | Neg Reviews |
|---|