Executive Dashboard

Laporan Eksekutif Bulanan

CEO membutuhkan dashboard ringkasan performa bulanan. Buatlah laporan dengan kolom:

1. bulan: nama bulan
2. total_orders: jumlah order
3. total_revenue: total pendapatan
4. avg_order_value: rata-rata nilai order
5. fulfillment_rate: persentase order completed (format: angka tanpa %)
6. performance_status:
   • 'Excellent' jika total_revenue >= 50000000 DAN fulfillment_rate >= 90
   • 'Good' jika total_revenue >= 30000000
   • 'Needs Improvement' sisanya

Output yang diharapkan

| bulan | total_orders | total_revenue | avg_order_value | fulfillment_rate | performance_status |