L1 Lampiran Lampiran 1-Wawancara user requirement Berikut merupakan hasil wawancara user requirement: 1. Bergerak di bidang apakah PT. Hutchison CP Telecommunications? PT. Hutchison CP Telecommunications bergerak di bidang telekomunikasi. 2. Produk apa saja yang dihasilkan oleh PT. Hutchison CP Telecommunications? PT. Hutchison CP Telecommunications menghasilkan produk 3. 3. Apakah system data sudah terkomputerisasi? Jika iya, software apa yang digunakan untuk sistem data tersebut? Sistem data sudah terkomputerisasi, database yang digunakan adalah oracle. 4. Apakah PT. Hutchison CP Telecommunications telah menerapkan penggunaan Business Inteligence? Iya. 5. Aplikasi apa yang digunakan untuk penggunaan Business Inteligence pada PT. Hutchison CP Telecommunications? Sekarang menggunakan data mining dan ad hoc analytical based on excel sebagai bahan analisa. L2 6. Apakah aplikasi Business Inteligence telah memberikan keuntungan yang signifikan? Iya. 7. Bagian mana yang sudah menggunakan aplikasi Business Intelligence? Marketing, sales, revenue assurance, scm, dan accounting(semua head office). 8. Bagian mana yang belum menggunakan aplikasi Business Intelligence? Regional sales dan marketing. 9. Apa yang dimaksud dengan prepaid? Pembayaran atas layanan yang dibayarkan di muka. Prepaid ini meliputi aktivasi(pemakai yang mengaktifkan kartu 3), churn(kartu yang mati misalnya karena masa tenggang habis), netadd(selisih antara aktivasi dan churn), dan subscriber(populasi pemakai 3). 10. 11. Bagaimana cara menghitung netadd, subscriber? • Netadd = aktivasi-churn • Subscriber = current subscriber + netadd Mengapa portal dibutuhkan? L3 Portal ini dibuat dengan harapan agar setiap bagian perusahaan pada setiap tingkat, dengan mudah memahami pelaporan status kemajuan dan mengukur status kemajuan setiap harinya, sehingga setiap tingkat dapat menetapkan keputusan yang harus diambil demi kemajuan perusahaan. 12. Masalah apa yang dihadapi bila tidak ada portal ini? Kesulitan mendapatkan data secara cepat karena harus menunggu dari head office. 13. Bagaimana data prepaid diperoleh saat ini? Data prepaid di dapat dari billing system yang disimpan di data warehouse. L4 Lampiran 2-Testing aplikasi portal Halaman Home Prepaid Last 3 Months - Activation - Churn - Population Last 3 Months - Revenue - Recharge Last 3 Months L5 Halaman Home Top Five Prepaid - Top Five Activation – Churn - Top Five Population L6 - Top Five Revenue – Recharge Halaman Revenue By Time - Total Revenue Per Year – Tabel L7 - Total Revenue Per Year – Grafik - Total Revenue Per Month - Tabel(1) L8 - Total Revenue Per Month - Tabel(2) - Total Revenue Per Month – Grafik L9 Halaman Revenue By Starter Pack - Total Revenue By Starter Pack Per Year – Tabel - Total Revenue By Starter Pack Per Year – Grafik L10 - Total Revenue By Starter Pack Per Month - Tabel(1) - Total Revenue By Starter Pack Per Month - Tabel(2) L11 - Total Revenue By Starter Pack Per Month – Grafik Halaman Revenue By Region - Total Revenue By Region Per Year – Tabel L12 - Total Revenue By Region Per Year – Grafik - Total Revenue By Region Per Month - Tabel(1) L13 - Total Revenue By Region Per Month - Tabel(2) - Total Revenue By Region Per Month – Grafik L14 Halaman Revenue By Event - Total Revenue By Event Per Year – Tabel - Total Revenue By Event Per Year – Grafik L15 - Total Revenue By Event Per Month - Tabel(1) - Total Revenue By Event Per Month - Tabel(2) L16 - Total Revenue By Event Per Month – Grafik Halaman Revenue By Channel - Total Revenue By Channel Per Year – Tabel L17 - Total Revenue By Channel Per Year – Grafik - Total Revenue By Channel Per Month - Tabel(1) L18 - Total Revenue By Channel Per Month - Tabel(2) - Total Revenue By Channel Per Month – Grafik L19 Halaman Revenue By All Dimensions - Total Revenue By All Dimensions Halaman Recharge By Time - Total Recharge Per Year – Table L20 - Total Recharge Per Year – Grafik - Total Recharge Per Month - Tabel(1) L21 - Total Recharge Per Month - Tabel(2) - Total Recharge Per Month – Grafik L22 Halaman Recharge By Starter Pack - Total Recharge By Starter Pack Per Year – Tabel - Total Recharge By Starter Pack Per Year – Grafik L23 - Total Recharge By Starter Pack Per Month - Tabel(1) - Total Recharge By Starter Pack Per Month - Tabel(2) L24 - Total Recharge By Starter Pack Per Month – Grafik Halaman Recharge By Region - Total Recharge By Region Per Year – Tabel L25 - Total Recharge By Region Per Year – Grafik - Total Recharge By Region Per Month - Tabel(1) L26 - Total Recharge By Region Per Month - Tabel(2) - Total Recharge By Region Per Month – Grafik L27 Halaman Recharge By Channel - Total Recharge By Channel Per Year – Tabel - Total Recharge By Channel Per Year – Grafik L28 - Total Recharge By Channel Per Month - Tabel(1) - Total Recharge By Channel Per Month - Tabel(2) L29 - Total Recharge By Channel Per Month – Grafik Halaman Recharge By All Dimensions - Total Recharge By All Dimensions L30 Halaman Subscriber By Time - Activation - Churn Per Year – Tabel - Activation - Churn Per Year – Grafik L31 - Population Per Year – Tabel - Population Per Year – Grafik L32 - Activation - Churn Per Month - Tabel(1) - Activation - Churn Per Month - Tabel(2) L33 - Activation - Churn Per Month – Grafik - Population Per Month - Tabel(1) L34 - Population Per Month - Tabel(2) - Population Per Month – Grafik L35 Halaman Subscriber By Starter Pack - Activation - Churn By Starter Pack Per Year – Tabel - Activation - Churn By Starter Pack Per Year – Grafik L36 - Population By Starter Pack Per Year – Tabel - Population By Starter Pack Per Year – Grafik L37 - Activation - Churn By Starter Pack Per Month - Tabel(1) - Activation - Churn By Starter Pack Per Month - Tabel(2) L38 - Activation - Churn By Starter Pack Per Month – Grafik - Population By Starter Pack Per Month - Tabel(1) L39 - Population By Starter Pack Per Month - Tabel(2) - Population By Starter Pack Per Month – Grafik L40 Halaman Subscriber By Region - Activation - Churn By Region Per Year – Tabel - Activation - Churn By Region Per Year – Grafik L41 - Population By Region Per Year – Tabel - Population By Region Per Year – Grafik L42 - Activation - Churn By Region Per Month - Tabel(1) - Activation - Churn By Region Per Month - Tabel(2) L43 - Activation - Churn By Region Per Month – Grafik - Population By Region Per Month - Tabel(1) L44 - Population By Region Per Month - Tabel(2) - Population By Region Per Month – Grafik L45 Halaman Subscriber By Channel - Activation - Churn By Channel Per Year – Tabel - Activation - Churn By Channel Per Year – Grafik L46 - Population By Channel Per Year – Tabel - Population By Channel Per Year – Grafik L47 - Activation - Churn By Channel Per Month - Tabel(1) - Activation - Churn By Channel Per Month - Tabel(2) L48 - Activation - Churn By Channel Per Month – Grafik - Population By Channel Per Month - Tabel(1) L49 - Population By Channel Per Month - Tabel(2) - Population By Channel Per Month – Grafik L50 Halaman Subscriber By All Dimensions - Activation By All Dimensions - Churn By All Dimensions L51 - Population By All Dimensions