ANALISIS DAN PERANCANGAN PORTAL BUSINESS INTELLIGENCE PADA PT. HUTCHISON CP TELECOMMUNICATIONS
SKRIPSI
Oleh
DENISE HARLAND
1100024903
WINDA CENDRAWATI
1100032685
ANDY SETIAWAN SUDIANTO
1100047812
Kelas / Kelompok
:
BINUS UNIVERSITY Jakarta 2011
07 PBT / 01
ANALISIS DAN PERANCANGAN PORTAL BUSINESS INTELLIGENCE PADA PT. HUTCHISON CP TELECOMMUNICATIONS SKRIPSI diajukan sebagai salah satu syarat untuk gelar kesarjanaan pada Jurusan Teknik Informatika Jenjang Pendidikan Strata-1
Oleh
DENISE HARLAND
1100024903
WINDA CENDRAWATI
1100032685
ANDY SETIAWAN SUDIANTO
1100047812
Kelas / Kelompok
:
BINUS UNIVERSITY Jakarta 2011
07 PBT / 01
ANALISIS DAN PERANCANGAN PORTAL BUSINESS INTELLIGENCE PADA PT. HUTCHISON CP TELECOMMUNICATIONS
SKRIPSI
Disusun oleh :
Denise Harland
Winda Cendrawati
Andy Setiawan Sudianto
1100024903
1100032685
1100047812
Disetujui oleh : Pembimbing
Suharjito, S.Si., MT. Kddsn : D2346
Universitas Bina Nusantara Jakarta 2011 iii
PERNYATAAN Dengan ini kami, Nama
: Denise Harland
NIM
: 1100024903
Nama
: Winda Cendrawati
NIM
: 1100032685
Nama
: Andy Setiawan Sudianto
NIM
: 1100047812
Judul skripsi
: Analisis dan Perancangan Portal Business Intelligence pada PT. Hutchison CP Telecommunications
Memberikan kepada Universitas Bina Nusantara hak non-eksklusif untuk menyimpan, memperbanyak, dan menyebarluaskan skripsi karya kami, secara keseluruhan atau hanya sebagian atau hanya ringkasannya saja, dalam bentuk format tercetak dan atau elektronik.
Menyatakan bahwa kami, akan mempertahankan hak exclusive kami, untuk menggunakan seluruh atau sebagian isi skripsi kami, guna pengembangan karya di masa depan, misalnya bentuk artikel, buku, perangkat lunak, ataupun sistem informasi.
Jakarta, 14 Februari 2011
Denise Harland 1100024903
Winda Cendrawati 1100032685 vii
Andy Setiawan Sudianto 1100047812
KATA PENGANTAR
Puji dan syukur kami panjatkan kepada Tuhan Yang Maha Esa atas segala berkat dan rahmat-Nya, sehingga kami dapat menyelesaikan penulisan skripsi yang berjudul “ANALISIS DAN PERANCANGAN PORTAL BUSINESS INTELLIGENCE PADA PT. HUTCHISON CP TELECOMMUNICATIONS” tepat pada waktunya. Skripsi ini disusun sebagai salah satu syarat guna mencapai gelar kesarjanaan jenjang pendidikan Strata-1 pada jurusan Teknik Informatika di Binus University, Jakarta. Dalam penyusunan skripsi ini, kami mendapatkan banyak dukungan dan bantuan dari berbagai pihak, baik secara langsung maupun tidak langsung. Oleh karena itu, pada kesempatan ini kami ingin menyampaikan ucapan terima kasih kepada : 1. Bapak Prof. Dr. Ir. Harjanto Prabowo, MM, selaku Rektor Binus University. 2. Bapak Ir. Sablin Yusuf, M.Sc., M.Comp.Sc., selaku Dekan Fakultas Ilmu Komputer di Binus University. 3. Bapak Fredy Purnomo, S.Kom., M.Kom., selaku Ketua Jurusan Teknik Informatika. 4. Ibu Yen Lina Prasetio, S.Kom., M.Kom., M.CompSc, selaku Sekretaris Jurusan Teknik Informatika. 5. Bapak Suharjito, S.Si., MT., selaku dosen pembimbing yang telah banyak memberikan waktu, pikiran, petunjuk, pengarahan, dan bimbingan kepada kami dari awal hingga selesainya skripsi ini. 6. Seluruh dosen di Universitas Bina Nusantara yang telah mendidik dan memberikan perkuliahan kepada kami selama masa kuliah kami di Binus University. ix
7. Bapak Yendra Tirta Perdana Go, S.Kom., MM., yang telah banyak mendukung dan membantu kami dalam penyusunan skripsi ini. 8. Orang tua, saudara-saudara, dan teman-teman penulis yang selama ini telah banyak memberikan dorongan baik moril maupun material. 9. Semua pihak yang tidak dapat kami sebutkan satu-persatu yang telah banyak membantu kami menyelesaikan skripsi ini. Akhir kata, kami mohon maaf sebesar-besarnya jika terdapat kekurangan pada skripsi ini. Kami dengan senang hati akan menerima segala saran dan kritik yang membangun untuk penyempurnaan skripsi ini. Semoga penulisan skripsi ini dapat bermanfaat bagi pembaca pada umumnya dan bagi penulis khususnya.
Jakarta, 14 Februari 2011
Penulis
x
DAFTAR ISI
Halaman judul luar ....................................................................................................... i Halaman judul dalam ................................................................................................... ii Halaman persetujuan hard cover ................................................................................. iii Halaman pernyataan dewan penguji ............................................................................ iv Halaman pemberian hak cipta non eksklusif dari mahasiswa ke Universitas Bina Nusantara .................................................................. vii Abstrak ......................................................................................................................... viii Kata Pengantar ............................................................................................................. ix Daftar Isi ...................................................................................................................... xi Daftar Tabel ................................................................................................................. xvii Daftar Gambar .............................................................................................................. xxi Daftar Lampiran .......................................................................................................... xxvii
BAB 1 PENDAHULUAN ............................................................................................. 1 1.1 Latar belakang .............................................................................................. 1 1.2 Ruang lingkup .............................................................................................. 4 1.3 Tujuan dan manfaat ...................................................................................... 5 1.3.1 Tujuan ................................................................................................ 5 1.3.2 Manfaat .............................................................................................. 5 1.4 Metodologi penelitian .................................................................................. 6 1.5 Sistematika penulisan ................................................................................... 9
xi
BAB 2 LANDASAN TEORI ......................................................................................... 11 2.1 Teori-teori umum ......................................................................................... 11 2.1.1 Pengertian data .................................................................................. 11 2.1.2 Pengertian metadata .......................................................................... 11 2.1.3 Pengertian informasi .......................................................................... 12 2.1.4 Pengertian sistem ............................................................................... 13 2.1.5 Pengertian sistem informasi............................................................... 13 2.1.6 Pengertian basis data ......................................................................... 14 2.1.7 Pengertian sistem basis data .............................................................. 14 2.1.8 Pengertian DBMS (database management system)........................... 15 2.1.9 Pengertian state transition diagram .................................................. 15 2.1.10 Pengertian data flow diagram.......................................................... 17 2.1.11 Pengertian data mart ....................................................................... 19 2.1.12 Pengertian data warehouse .............................................................. 20 2.1.13 Pengertian OLAP (Online Analitical Processing)........................... 21 2.1.14 Diagram ........................................................................................... 22 2.1.15 Pengertian business intelligence ...................................................... 27 2.1.16 Pengertian portal .............................................................................. 29 2.2 Teori-teori khusus ........................................................................................ 30 2.2.1 Pendekatan data warehouse .............................................................. 30 2.2.1.1 Karakteristik data warehouse ................................................ 30 2.2.1.2 Komponen data warehouse ................................................... 34 2.2.1.3 ETL (Extract, transform, load).............................................. 37 2.2.1.4 Dimensional modeling ........................................................... 38 xii
2.2.1.5 Skema bintang (Star schema) ................................................ 40 2.2.1.6 Jenis-jenis skema bintang ...................................................... 41 2.2.1.7 Variasi skema bintang ........................................................... 43 2.2.2 Corporate portal ................................................................................ 45 2.2.3 Pendekatan business intelligence (BI) ............................................... 47 2.2.3.1 Arsitektur business intelligence ............................................. 47 2.2.3.2 Jenis-jenis business intelligence ............................................ 49 2.2.3.3 Siklus hidup business intelligence ......................................... 51 2.2.3.4 Manfaat business intelligence ................................................ 51 2.2.4 Executive dashboard.......................................................................... 54 2.2.5 Pengertian sistem prepaid ................................................................. 55 2.2.6 Bisnis telekomunikasi ........................................................................ 56 2.2.6.1 Jenis-jenis teknologi telekomunikasi ..................................... 56 2.2.6.2 Jenis-jenis layanan telekomunikasi ....................................... 57 2.2.6.3 Generasi teknologi telekomunikasi ....................................... 58 2.2.7 Oracle................................................................................................. 60 2.2.7.1 Definisi OBIEE...................................................................... 60 2.2.7.2 Arsitektur OBIEE .................................................................. 61 2.2.7.3 Komponen OBIEE ................................................................. 64 2.2.8 Konsep data modeling pada OBIEE .................................................. 66 2.2.8.1 Physical layer ........................................................................ 67 2.2.8.2 Business model and mapping layer ....................................... 68 2.2.8.3 Presentation layer.................................................................. 68
xiii
BAB 3 ANALISIS SISTEM YANG BERJALAN ........................................................ 69 3.1 Gambaran umum perusahaan ....................................................................... 69 3.1.1 Sejarah perusahaan ............................................................................ 69 3.1.2 Visi dan misi ...................................................................................... 69 3.1.3 Produk ................................................................................................ 70 3.1.4 Struktur organisasi ............................................................................. 73 3.1.5 Tugas dan tanggung jawab ................................................................ 74 3.2 Analisis sistem yang berjalan ....................................................................... 75 3.2.1 Analisis sistem report request dari head office .................................. 75 3.2.2 Analisis sistem report request dari branch office .............................. 77 3.3 Arsitektur sistem informasi yang berjalan ................................................... 79 3.4 Data warehouse perusahaan ........................................................................ 80 3.5 Software dan hardware .............................................................................. 100 3.5.1 Software ........................................................................................... 100 3.5.2 Hardware ......................................................................................... 103 3.6 Permasalahan yang sedang dihadapi .......................................................... 104 3.7 Analisis kebutuhan sistem terhadap sistem berjalan .................................. 105 3.7.1 Business intelligence portal ............................................................. 105 3.7.2 Business intelligence portal application requirements .................... 106 3.8 Pemecahan masalah ................................................................................... 108
BAB 4 PERANCANGAN SISTEM ............................................................................ 109 4.1 Sistem yang akan dibuat............................................................................. 109 4.2 Skema bintang ............................................................................................ 110 xiv
4.3 Mapping Database ..................................................................................... 117 4.3.1 Metadata data warehouse portal ...................................................... 117 4.3.2 Proses mapping database…………………………………………...125 4.3.3 Bagan mapping database…………………………………………...140 4.4 Arsitektur sistem informasi yang akan dibuat ............................................ 144 4.5 Perancangan aplikasi business intelligence................................................ 145 4.5.1 Physical layer……………………………………………………….145 4.5.2 Business model and mapping layer .................................................. 147 4.5.3 Presentation layer ............................................................................ 163 4.5.4 Pembuatan repository variable ........................................................ 164 4.5.4 Pembuatan session variable ............................................................. 170 4.6 Perancangan dashboard ............................................................................. 174 4.7 Perancangan layar aplikasi ......................................................................... 192 4.7.1 Struktur menu ................................................................................... 192 4.7.2 State transition diagram ................................................................... 193 4.7.3 Rincian tampilan aplikasi ................................................................. 194 4.8 Rencana implementasi ............................................................................... 219 4.8.1 Spesifikasi kebutuhan perangkat keras dan lunak ............................ 219 4.8.1.1 Spesifikasi perangkat keras yang dibutuhkan ...................... 219 4.8.1.2 Spesifikasi perangkat lunak yang dibutuhkan ..................... 220 4.9 Evaluasi sistem ........................................................................................... 220 4.10 Evaluasi hasil kuesioner untuk software .................................................. 222
xv
BAB 5 SIMPULAN DAN SARAN ............................................................................. 226 5.1 Simpulan…………………………………………………………………...226 5.2 Saran…………………………………………………………………….....227 DAFTAR PUSTAKA .................................................................................................. 228 DAFTAR RIWAYAT HIDUP..................................................................................... 231 LAMPIRAN ................................................................................................................. L1
xvi
DAFTAR TABEL
Halaman Tabel 2.1 Tabel notasi pada state transition diagram .................................................... 16 Tabel 2.2 Tabel notasi pada data flow diagram ............................................................. 18 Tabel 3.1 Tabel CHARGED_EVENT_FCT .................................................................. 83 Tabel 3.2 Tabel TOPUP_FCT ....................................................................................... 85 Tabel 3.3 Tabel TOPUP_MNTLY_FCT ....................................................................... 86 Tabel 3.4 Tabel CUST_ACCT_SBSCRPTN_STAT_FCT ........................................... 87 Tabel 3.5 Tabel ACCT_DIM ......................................................................................... 88 Tabel 3.6 Tabel SBSCRPTN_DIM ................................................................................ 89 Tabel 3.7 Tabel POC_DIM ............................................................................................ 90 Tabel 3.8 Tabel PROMO_CD_DIM .............................................................................. 90 Tabel 3.9 Tabel EVENT_TYPE_DIM........................................................................... 91 Tabel 3.10 Tabel CALL_PLAN_DIM ........................................................................... 91 Tabel 3.11 Tabel PRICING_PLAN_DIM ..................................................................... 92 Tabel 3.12 Tabel BONUS_DIM .................................................................................... 92 Tabel 3.13 Tabel COUNTRY_DIM .............................................................................. 93 Tabel 3.14 Tabel REVENUE_CD_DIM........................................................................ 93 Tabel 3.15 Tabel REGION_GRP_DIM ......................................................................... 94 Tabel 3.16 Tabel REGION_NM_DIM .......................................................................... 94 Tabel 3.17 Tabel TRAFICC_DIM ................................................................................. 95 Tabel 3.18 Tabel DATE_DIM ....................................................................................... 95 Tabel 3.19 Tabel CUST_DIM........................................................................................ 97 Tabel 3.20 Tabel CHANNEL_DIM............................................................................... 97
xvii
Tabel 3.21 Tabel TOPUP_SOURCE_DIM ................................................................... 98 Tabel 3.22 Tabel DENOMINATION_DIM .................................................................. 98 Tabel 3.23 Tabel ACCT_LIFECYCLE_STATUS_DIM .............................................. 99 Tabel 3.24 Tabel software ............................................................................................ 100 Tabel 3.25 Tabel ETL server ....................................................................................... 103 Tabel 3.26 Tabel database server ................................................................................ 103 Tabel 4.1 Tabel prepaid_revenue_fact ......................................................................... 112 Tabel 4.2 Tabel contoh data prepaid_revenue_fact ..................................................... 113 Tabel 4.3 Tabel prepaid_recharge_fact ........................................................................ 113 Tabel 4.4 Tabel contoh data prepaid_recharge_fact .................................................... 113 Tabel 4.5 Tabel prepaid_subs_fact .............................................................................. 113 Tabel 4.6 Tabel contoh data prepaid_subs_fact ........................................................... 114 Tabel 4.7 Tabel time_dim ............................................................................................ 114 Tabel 4.8 Tabel contoh data time_dim......................................................................... 115 Tabel 4.9 Tabel region_dim ......................................................................................... 115 Tabel 4.10 Tabel contoh data region_dim.................................................................... 116 Tabel 4.11 Tabel starter_pack_dim .............................................................................. 116 Tabel 4.12 Tabel contoh data starter_pack_dim .......................................................... 116 Tabel 4.13 Tabel channel_dim ..................................................................................... 116 Tabel 4.14 Tabel contoh data channel_dim ................................................................. 117 Tabel 4.15 Tabel event_dim......................................................................................... 117 Tabel 4.16 Tabel contoh data event_dim ..................................................................... 117 Tabel 4.17 Tabel metadata time_dim .......................................................................... 119 Tabel 4.18 Tabel metadata region_dim ....................................................................... 120 Tabel 4.19 Tabel metadata starter_pack_dim .............................................................. 120
xviii
Tabel 4.20 Tabel metadata channel_dim ..................................................................... 121 Tabel 4.21 Tabel metadata event_dim ......................................................................... 121 Tabel 4.22 Tabel metadata prepaid_revenue_fact ....................................................... 122 Tabel 4.23 Tabel metadata prepaid_recharge_fact ...................................................... 123 Tabel 4.24 Tabel metadata prepaid_subs_fact............................................................. 124 Tabel 4.25 Tabel deskripsi fungsi GET_HUTCHISON .............................................. 125 Tabel 4.26 Tabel deskripsi fungsi CEK_TIME_DIM.................................................. 125 Tabel 4.27 Tabel deskripsi fungsi CEK_REGION_DIM ............................................ 126 Tabel 4.28 Tabel deskripsi fungsi CEK_STARTER_PACK_DIM ............................. 126 Tabel 4.29 Tabel deskripsi fungsi CEK_CHANNEL_DIM ........................................ 127 Tabel 4.30 Tabel deskripsi fungsi CEK_EVENT_DIM .............................................. 127 Tabel 4.31 Tabel deskripsi fungsi CEK_REVENUE_FACT ...................................... 128 Tabel 4.32 Tabel deskripsi fungsi CEK_RECHARGE_FACT ................................... 128 Tabel 4.33 Tabel deskripsi fungsi CEK_SUBS_FACT ............................................... 129 Tabel 4.34 Tabel deskripsi prosedur GET_TIME_DIM .............................................. 130 Tabel 4.35 Tabel deskripsi prosedur LOAD_TIME_DIM .......................................... 130 Tabel 4.36 Tabel deskripsi prosedur GET_REGION_DIM ........................................ 131 Tabel 4.37 Tabel deskripsi prosedur LOAD_REGION_DIM ..................................... 132 Tabel 4.38 Tabel deskripsi prosedur GET_STARTER_PACK_DIM ......................... 132 Tabel 4.39 Tabel deskripsi prosedur LOAD_STARTER_PACK_DIM ...................... 133 Tabel 4.40 Tabel deskripsi prosedur GET_CHANNEL_DIM .................................... 133 Tabel 4.41 Tabel deskripsi prosedur LOAD_CHANNEL_DIM ................................. 134 Tabel 4.42 Tabel deskripsi prosedur GET_EVENT_DIM .......................................... 134 Tabel 4.43 Tabel deskripsi prosedur LOAD_EVENT_DIM ....................................... 135 Tabel 4.44 Tabel deskripsi prosedur GET_REVENUE_FACT .................................. 135 xix
Tabel 4.45 Tabel deskripsi prosedur LOAD_REVENUE_FACT ............................... 136 Tabel 4.46 Tabel deskripsi prosedur GET_RECHARGE_FACT................................ 137 Tabel 4.47 Tabel deskripsi prosedur LOAD_RECHARGE_FACT ............................ 137 Tabel 4.48 Tabel deskripsi prosedur GET_SUBS_FACT ........................................... 139 Tabel 4.49 Tabel deskripsi prosedur LOAD_SUBS_FACT ........................................ 139 Tabel 4.50 Tabel mapping database ............................................................................. 141 Tabel 4.51 Tabel kolom tambahan pada tabel recharge fact ........................................ 158 Tabel 4.52 Tabel kolom tambahan pada tabel Revenue Fact....................................... 159 Tabel 4.53 Tabel kolom tambahan pada tabel Subscriber Fact ................................... 161 Tabel 4.54 Tabel syarat minimal Oracle Business Intelligence pada Windows .......... 219 Tabel 4.55 Tabel komponen server.............................................................................. 220 Tabel 4.56 Tabel komponen client ............................................................................... 220 Tabel 4.57 Tabel waktu yang diperlukan untuk memproses data ................................ 221
xx
DAFTAR GAMBAR
Halaman Gambar 1.1 Flowchart metodologi penelitian ............................................................... 8 Gambar 2.1 Contoh state transition diagram ................................................................ 17 Gambar 2.2 Contoh data flow diagram.......................................................................... 19 Gambar 2.3 Diagram batang .......................................................................................... 23 Gambar 2.4 Diagram lingkar.......................................................................................... 24 Gambar 2.5 Diagram lambang ....................................................................................... 25 Gambar 2.6 Diagram peta .............................................................................................. 26 Gambar 2.7 Diagram garis ............................................................................................. 26 Gambar 2.8 Diagram wilayah ........................................................................................ 27 Gambar 2.9 What business intelligence means in practice ............................................ 28 Gambar 2.10 Contoh orientasi subjek terhadap data ..................................................... 31 Gambar 2.11 Persoalan mengenai integrasi data ........................................................... 32 Gambar 2.12 Persoalan mengenai time variant ............................................................. 33 Gambar 2.13 Persoalan mengenai nonvolotile ............................................................... 34 Gambar 2.14 Elemen-elemen dasar dari data warehouse.............................................. 35 Gambar 2.15 Contoh tabel fakta .................................................................................... 39 Gambar 2.16 Contoh tabel dimensi................................................................................ 40 Gambar 2.17 Illustration of a simple star schema ......................................................... 41 Gambar 2.18 Simple star schema ................................................................................... 42 Gambar 2.19 Multiple fact star schema ......................................................................... 43 Gambar 2.20 Contoh skema snowflake .......................................................................... 44 Gambar 2.21 Komponen utama dari business intelligence ............................................ 49
xxi
Gambar 2.22 Tabel manfaat business intelligence ........................................................ 54 Gambar 2.23 Struktur jaringan GSM ............................................................................. 56 Gambar 2.24 Struktur jaringan CDMA.......................................................................... 57 Gambar 2.25 Arsitektur OBIEE ..................................................................................... 63 Gambar 2.26 Komponen OBIEE ................................................................................... 66 Gambar 2.27 Data modeling pada OBIEE..................................................................... 67 Gambar 3.1 Struktur organisasi PT. Hutchison CP Telecommunications ..................... 73 Gambar 3.2 Rich picture sistem berjalan report request dari head office ..................... 75 Gambar 3.3 Rich picture sistem berjalan report request dari branch office .................. 77 Gambar 3.4 Arsitektur sistem informasi yang berjalan ................................................. 79 Gambar 3.5 Skema bintang revenue .............................................................................. 80 Gambar 3.6 Skema bintang topup .................................................................................. 81 Gambar 3.7 Skema bintang topup bulanan .................................................................... 82 Gambar 3.8 Skema bintang subscription ....................................................................... 82 Gambar 4.1 Rich picture sistem yang akan dibuat ....................................................... 109 Gambar 4.2 Skema bintang prepaid revenue ............................................................... 111 Gambar 4.3 Skema bintang prepaid recharge ............................................................. 111 Gambar 4.4 Skema bintang prepaid subscriber........................................................... 112 Gambar 4.5 Arsitektur sistem informasi yang akan dibuat .......................................... 144 Gambar 4.6 Perancangan physical layer ...................................................................... 146 Gambar 4.7 Desain skema bintang pada physical layer .............................................. 147 Gambar 4.8 Perancangan business model and mapping layer tahap awal................... 148 Gambar 4.9 Desain skema bintang pada business model and mapping layer ............. 149 Gambar 4.10 Desain tabel dimensi dan tabel fakta pada business model and mapping layer ............................................... 149
xxii
Gambar 4.11 Pemilihan agregasi data pada kolom TOTAL RECHARGE ................. 150 Gambar 4.12 Pemilihan agregasi data pada kolom TOTAL REVENUE .................... 151 Gambar 4.13 Pemilihan agregasi data pada kolom ACTIVATION ............................ 151 Gambar 4.14 Pemilihan agregasi data pada kolom CHURN ....................................... 152 Gambar 4.15 Pemilihan agregasi pada kolom NET ADD ........................................... 152 Gambar 4.16 Pemilihan agregasi data pada kolom POPULATION ............................ 153 Gambar 4.17 Perancangan struktur dimensi dan drill down pada business model and mapping layer ............................................... 154 Gambar 4.18 Struktur drill down pada tabel CHANNEL DIM ................................... 154 Gambar 4.19 Struktur drill down pada tabel EVENT DIM ......................................... 155 Gambar 4.20 Struktur drill down pada tabel REGION DIM ....................................... 155 Gambar 4.21 Struktur drill down pada tabel STARTER PACK DIM......................... 156 Gambar 4.22 Struktur drill down pada tabel TIME DIM ............................................ 157 Gambar 4.23 Kolom-kolom pada tabel Recharge Fact ................................................ 158 Gambar 4.24 Kolom-kolom pada tabel Revenue Fact ................................................. 159 Gambar 4.25 Kolom-kolom pada tabel Subscriber Fact .............................................. 160 Gambar 4.26 Perancangan presentation layer .............................................................. 164 Gambar 4.27 Variable Manager pada inizialization block getMaxDate dan getYearMonthAgo ..................................................... 165 Gambar 4.28 Menu pengaturan initialization block getMaxYear ................................ 166 Gambar 4.29 Layar edit data source untuk getMaxDate.............................................. 167 Gambar 4.30 Layar edit data target dari getMaxDate .................................................. 167 Gambar 4.31 Menu pengaturan initialization block getYearMonthAgo ..................... 168 Gambar 4.32 Layar edit data source untuk getYearMonthAgo ................................... 169 Gambar 4.33 Layar edit data target dari getYearMonthAgo ....................................... 169
xxiii
Gambar 4.34 List variabel yang terbentuk ................................................................... 170 Gambar 4.35 Variabel manager pada inizialization block getRegion.......................... 170 Gambar 4.36 Menu pengaturan initialization block getRegion ................................... 171 Gambar 4.37 Layar edit data source untuk getRegion ................................................. 172 Gambar 4.38 Layar edit data target untuk getRegion .................................................. 173 Gambar 4.39 List variable yang terbentuk ................................................................... 173 Gambar 4.40 Perancangan halaman login awal ........................................................... 174 Gambar 4.41 Perancangan halaman home prepaid last 3 months ................................ 174 Gambar 4.42 Perancangan halaman home top five prepaid ......................................... 175 Gambar 4.43 Perancangan halaman revenue by time .................................................. 176 Gambar 4.44 Perancangan halaman revenue by event................................................. 177 Gambar 4.45 Perancangan halaman revenue by starter pack ....................................... 178 Gambar 4.46 Perancangan halaman revenue by channel ............................................. 179 Gambar 4.47 Perancangan halaman revenue by region ............................................... 180 Gambar 4.48 Perancangan halaman revenue by all dimensions .................................. 181 Gambar 4.49 Perancangan halaman recharge by time ................................................. 182 Gambar 4.50 Perancangan halaman recharge by starter pack...................................... 183 Gambar 4.51 Perancangan halaman recharge by channel ............................................ 184 Gambar 4.52 Perancangan halaman recharge by region .............................................. 185 Gambar 4.53 Perancangan halaman recharge by all dimensions ................................. 186 Gambar 4.54 Perancangan halaman subscriber by time .............................................. 187 Gambar 4.55 Perancangan halaman subscriber by starter pack ................................... 188 Gambar 4.56 Perancangan halaman subscriber by channel ......................................... 189 Gambar 4.57 Perancangan halaman subscriber by region ........................................... 190 Gambar 4.58 Perancangan halaman subscriber by all dimensions .............................. 191
xxiv
Gambar 4.59 Struktur menu halaman dashboard home ............................................... 192 Gambar 4.60 Struktur menu halaman home ................................................................ 192 Gambar 4.61 Struktur menu halaman revenue ............................................................. 192 Gambar 4.62 Struktur menu halaman recharge............................................................ 192 Gambar 4.63 Struktur menu halaman subscriber ......................................................... 193 Gambar 4.64 State trantition diagram ......................................................................... 193 Gambar 4.65 Background 3 ......................................................................................... 194 Gambar 4.66 Header 3 ................................................................................................. 194 Gambar 4.67 Menu utama ............................................................................................ 194 Gambar 4.68 Grafik garis activation - churn last 3 months berdasarkan bulan .......... 196 Gambar 4.69 Grafik batang activation - churn last 3 months berdasarkan bulan........ 196 Gambar 4.70 Grafik activation - churn last 3 months berdasarkan minggu ................ 197 Gambar 4.71 Grafik activation – churn last 3 months berdasarkan hari ..................... 198 Gambar 4.72 Grafik population last 3 months ............................................................. 198 Gambar 4.73 Grafik revenue-recharge last 3 months .................................................. 199 Gambar 4.74 Grafik top five activation berdasarkan starter pack name .................... 199 Gambar 4.75 Tabel dan grafik total revenue per year ................................................. 200 Gambar 4.76 Tabel dan grafik total revenue by event per year ................................... 201 Gambar 4.77 Tabel dan grafik total revenue by starter pack per year ....................... 202 Gambar 4.78 Tabel dan grafik total revenue by channel per year.............................. 204 Gambar 4.79 Tablel dan grafik total revenue by region per year ............................... 205 Gambar 4.80 Tabel dan grafik total revenue by all dimensions .................................. 206 Gambar 4.81 Tabel dan grafik total recharge per year ............................................... 207 Gambar 4.82 Tabel dan grafik total recharge by starter pack per year ...................... 208 Gambar 4.83 Tabel dan grafik total recharge by channel per year ............................ 209
xxv
Gambar 4.84 Tabel dan grafik total recharge by region per year .............................. 211 Gambar 4.85 Tabel dan grafik total recharge by all dimensions ................................. 212 Gambar 4.86 Tabel dan grafik activation per year ...................................................... 213 Gambar 4.87 Tabel dan grafik activation by starter pack per year ............................. 214 Gambar 4.88 Tabel dan grafik activation by channel per year.................................... 215 Gambar 4.89 Tabel dan grafik activation by region per year ...................................... 216 Gambar 4.90 Tabel dan grafik activation by all dimensions ....................................... 218
xxvi
DAFTAR LAMPIRAN
Lampiran 1-Wawancara user requirement................................................................... L1 Lampiran 2-Testing aplikasi portal .............................................................................. L4
xxvii