SwiftBite | Business Performance, Delivery & Customer Experience Analysis
Q1 2026 | January – March | Variant SB-P21
Month
Cuisine
Zone
Total Orders
+31.46%
311
Net Payment Value
+33.47%
Rp 38.97M
Late Delivery Rate
+17.61%
28.21%
79 / 280 Delivered
Review Coverage
-2.40%
57.56%
179 / 311 Orders
Monthly Orders & Net Payment Trend
Orders (left axis)
Net Payment Value (right axis)
Net Payment by Cuisine
Late Delivery Rate by Zone
Review Sentiment Distribution
Positive
Neutral
Negative
Unknown
No Text: 13
No Review: 132
Key
Takeaways
Takeaways
Monitor monthly order and Net Payment trends.
Evaluate delivery performance in North & East zones.
Use rating and review insights to enhance customer experience.
Status Filter Terintegrasi:
Semua Data (Q1 2026)
Deep Dive Analytical Explorer — Analisis komparatif menyeluruh mencakup tiga pilar analitis: Performa Bisnis & Monetisasi Kategori (BQ-01), Operasional Pengantaran & Bottleneck Rute (BQ-02), serta Pengalaman Pelanggan & Sentimen Ulasan (BQ-03).
A. Business Performance & Monetization Deep Dive
Q1 2026 Net Payment
Rp 38.974.000
280 Successful Orders (100% Retained)
Net Revenue per Successful Order
Rp 139.193
Denominator: 280 Successful Orders
Platform Booked AOV
Rp 125.318
Denominator: 311 Total Booked Orders
Tren & Pertumbuhan Bulanan (Q1 2026)
| Bulan | Total Orders | MoM Orders | Net Payment | MoM Revenue | Net Rev / Order |
|---|---|---|---|---|---|
| Januari 2026 | 105 | - | Rp 13.895.000 | - | Rp 149.409 |
| Februari 2026 | 89 | -15,24% | Rp 10.742.000 | -22,69% | Rp 129.422 |
| Maret 2026 | 117 | +31,46% | Rp 14.337.000 | +33,47% | Rp 137.856 |
Distribusi Metode Pembayaran Final
| Metode Pembayaran | Pesanan | Porsi Pesanan | Net Payment | Share Pendapatan |
|---|---|---|---|---|
| Cash (Tunai) | 77 | 24,76% | Rp 10.775.000 | 27,65% |
| Credit Card | 78 | 25,08% | Rp 10.247.000 | 26,29% |
| E-Wallet | 78 | 25,08% | Rp 9.219.000 | 23,65% |
| Bank Transfer | 78 | 25,08% | Rp 8.733.000 | 22,41% |
Performa Komersial & Monetisasi per Kategori Kuliner
| Kategori Kuliner | Total Orders | Delivered | Net Payment Value | Revenue Share | Net Rev / Successful Order | AOV (All Booked) |
|---|---|---|---|---|---|---|
| Western | 62 | 56 | Rp 9.380.000 | 24,07% | Rp 167.500 | Rp 151.290 |
| Fast Food | 62 | 56 | Rp 8.352.000 | 21,43% | Rp 149.143 | Rp 134.710 |
| Asian | 62 | 56 | Rp 7.562.000 | 19,40% | Rp 135.036 | Rp 121.968 |
| Dessert | 63 | 56 | Rp 7.544.000 | 19,36% | Rp 134.714 | Rp 119.746 |
| Cafe & Beverage | 62 | 56 | Rp 6.136.000 | 15,74% | Rp 109.571 | Rp 98.968 |
B. Delivery Operations & Distance Bottlenecks Deep Dive
Kinerja Pengantaran Berdasarkan Kelompok Jarak
| Kelompok Jarak | Delivered | Porsi Rute | Late Orders | Late Rate | Avg Delay | Avg Jarak |
|---|---|---|---|---|---|---|
| Dekat (≤ 3 km) | 44 | 15,71% | 10 | 22,73% | -1,73 mnt | 2,08 km |
| Sedang (3 - 6 km) | 54 | 19,29% | 13 | 24,07% | -1,69 mnt | 4,45 km |
| Jauh (> 6 km) | 182 | 65,00% | 56 | 30,77% | +0,31 mnt | 10,41 km |
* Rute Jarak Jauh (>6 km) menyumbang 70,89% dari seluruh keterlambatan platform (56 dari 79 late orders).
Perbandingan Kinerja Pengantaran Antar-Zona
| Zona Restoran | Delivered | Late Orders | Late Rate | Avg Delay | Avg Jarak |
|---|---|---|---|---|---|
| Zona North | 56 | 19 | 33,93% | +1,50 mnt | 9,14 km |
| Zona East | 56 | 18 | 32,14% | +1,30 mnt | 8,33 km |
| Zona Central | 56 | 14 | 25,00% | -1,32 mnt | 8,23 km |
| Zona West | 112 | 28 | 25,00% | -1,72 mnt | 7,04 km |
* Zona North & East memiliki rata-rata jarak terpanjang (>8,3 km) dan rata-rata waktu keterlambatan positif.
C. Customer Experience & Rating-Sentiment Mismatch Deep Dive
Tabel Silang Rating Bintang vs Kategori Sentimen Teks
| Rating Bintang | Positive | Neutral | Negative | Unknown | No Text | Total Ulasan |
|---|---|---|---|---|---|---|
| Bintang 1.0 | 7 (Anomali) | 1 | 6 | 0 | 1 | 15 |
| Bintang 2.0 | 11 | 6 | 5 | 2 | 2 | 26 |
| Bintang 3.0 | 18 | 10 | 8 | 1 | 3 | 40 |
| Bintang 4.0 | 33 | 4 | 10 | 5 | 3 | 55 |
| Bintang 5.0 | 20 | 7 | 8 (Anomali) | 4 | 4 | 43 |
| Total | 89 | 28 | 37 | 12 | 13 | 179 |
Tingkat Partisipasi Ulasan per Segmen Pelanggan
| Segmen Pelanggan | Total Pesanan | Jumlah Ulasan | Review Coverage | Rata-rata Rating |
|---|---|---|---|---|
| Regular | 139 | 83 | 59,71% | 3,47 / 5.0 |
| New | 89 | 52 | 58,43% | 3,54 / 5.0 |
| Loyal | 83 | 44 | 53,01% | 3,41 / 5.0 |
* Segmen Loyal mencatatkan partisipasi ulasan terendah (53,01%), menunjukkan potensi inisiatif retensi umpan balik.
Temuan Anomali Rating-Sentiment Mismatch (15 Pesanan / 8,38% Ulasan): Teridentifikasi 7 ulasan berskor bintang 1.0 dengan teks apresiasi positif (misal: "porsinya banyak dan memuaskan") dan 8 ulasan berskor bintang 5.0 dengan keluhan negatif riil (misal: "pesanan datang terlambat dan makanan sudah dingin"). Oleh karena itu, antarmuka penanganan keluhan pelanggan SwiftBite wajib memprioritaskan pemindaian teks ulasan, bukan hanya bertumpu pada skor bintang numerik.
Tentang Proyek: SwiftBite Business Performance Dashboard
Dashboard ini dikembangkan sebagai artefak resmi Output 02 (Interactive Dashboard) dalam Capstone Project Data Analyst dengan AI Tools. Dashboard dirancang untuk menyajikan analisis terpadu atas kinerja transaksi bisnis, operasional logistik pengantaran, dan pengalaman pelanggan platform SwiftBite sepanjang kuartal pertama tahun 2026.
Identitas Proyek & Analis
| Nama Analis | Nadia |
| Peran | Junior Data Analyst, SwiftBite Analytics Team |
| Variant ID | SB-P21 |
| Periode Analisis | Q1 2026 (Januari – Maret 2026) |
| Ukuran Dataset | 311 Baris Pesanan (Grain: 1 baris per order) |
| Status Quality Gate | PASSED (Stage 01 s/d Stage 05) |
Standar Perhitungan & Definisi KPI
| Total Orders | COUNT DISTINCT order_id (311 orders) |
| Net Payment Value |
SUM(successful_payment_amount) − SUM(refunded_payment_amount) = Rp 40.165.000 − Rp 1.191.000 = Rp 38.974.000
• Successful Payment Amount (Rp40.165.000): total pembayaran yang berhasil diproses sebelum pengurangan refund, termasuk pembayaran yang kemudian dikembalikan.
• Refunded Payment Amount (Rp1.191.000): total dana yang dikembalikan kepada pelanggan dari 10 pesanan berstatus refunded. • Net Payment Value (Rp38.974.000): nilai pembayaran bersih setelah mengurangi refund dari total pembayaran yang berhasil diproses. • Distribusi Status: Sebanyak 280 pesanan berstatus successful menghasilkan Net Payment sebesar Rp38.974.000; sebanyak 10 pesanan refunded memiliki nilai Net Payment Rp0 setelah pengembalian dana penuh; sebanyak 21 pesanan failed tidak menghasilkan pembayaran berhasil. • Catatan Metodologis: Net Payment Value bukan rasio. Angka Rp40.165.000 adalah komponen penambah (+) dan Rp1.191.000 adalah komponen pengurang (−), bukan numerator dan denominator dari suatu pembagian. |
| Late Delivery Rate | (Late Delivered / Total Delivered) × 100% = 79 / 280 = 28,21% |
| Review Coverage | (Orders with Review / Total Orders) × 100% = 179 / 311 = 57,56% |
| Net Rev / Succ. Order | Net Payment / Successful Orders = Rp 38.974.000 / 280 = Rp 139.193 |
Arsitektur Data & Teknologi
Pipeline analitis dibangun melalui integrasi berjenjang yang aman dan terdokumentasi:
- Tahap PM1 (Data Readiness): Pembersihan, penanganan missing values, dan verifikasi struktur 5 tabel sumber mentah.
- Tahap PM2 (Safe Integration): Penggabungan multi-sumber level order tanpa kebocoran data sensitif (zero direct PII compliance).
- Tahap Capstone Stage 01–02: Penggabungan tabel ulasan (Reviews) dengan verifikasi zero fan-out (311 baris invariant).
- Tahap Capstone Stage 03–05: Perhitungan 4 KPI inti, 5 kategori sentimen teks resmi, dan sintesis bukti kuantitatif 4 Key Findings.
- Tahap Capstone Stage 06 (Interactive Dashboard): Implementasi antarmuka HTML interaktif mandiri (*offline-ready*) dengan integrasi Chart.js dan SVG vector graphics.