DAFTAR GAMBAR
Gambar 2. 1 Arsitektur Data Warehouse.............................................................. 10 Gambar 2. 2 Contoh Star Schema ........................................................................ 12 Gambar 2. 3 Contoh Snowflake Schema .............................................................. 13 Gambar 2. 4 Contoh Starflake Schema ................................................................. 13 Gambar 2. 5 Relational to Relational Mapping .................................................... 14 Gambar 2. 6 Relational to Multidimensional Mapping ........................................ 15 Gambar 2. 7 Contoh Proses ETL dengan Pentaho Data Integration (PDI) ......... 17
Gambar 3. 1 Star Schema Calon Mahasiswa ....................................................... 35 Gambar 3. 2 Star Schema Mahasiswa .................................................................. 36 Gambar 3. 3 Star Schema Catatan Akademik Mahasiswa ................................... 36 Gambar 3. 4 Star Schema IPK Mahasiswa ........................................................... 37 Gambar 3. 5 Star Schema Lulusan ....................................................................... 37 Gambar 3. 6 Star Schema Catatan Akademik Dosen ........................................... 38 Gambar 3. 7 Star Schema Registrasi Mahasiswa ................................................. 38 Gambar 3. 8 Star Schema Pembayaran Mahasiswa ............................................. 38 Gambar 3. 9 Star Schema Dosen ......................................................................... 39 Gambar 3. 10 Star Schema Mengajar .................................................................. 39
Gambar 4. 1 Arsitektur Data Warehouse Universitas Widyatama ...................... 42 Gambar 4. 2 Rancangan Antarmuka Halaman Awal Dashboard ........................ 64 Gambar 4. 3 Rancangan Antarmuka Login Administrator .................................. 65 Gambar 4. 4 Rancangan Antarmuka Administrator ............................................. 66 Gambar 4. 5 Rancangan Antarmuka Koneksi ...................................................... 67 Gambar 4. 6 Rancangan Antarmuka Periode ....................................................... 67 Gambar 4. 7 Rancangan Antarmuka Team .......................................................... 68 Gambar 4. 8 Rancangan Antarmuka Home Akademik PDPT ............................. 69 Gambar 4. 9 Rancangan Antarmuka Grafik Akademik PDPT ............................ 69 Gambar 4. 10 Rancangan Antarmuka Tabel Akademik PDPT ............................ 70
xiv
xv
Gambar 4. 11 Rancangan Antarmuka Custon Chart Akademik PDPT ............... 70 Gambar 4. 12 Rancangan Antarmuka Home Akademik Borang ......................... 71 Gambar 4. 13 Rancangan Antarmuka Grafik Akademik Borang ........................ 71 Gambar 4. 14 Rancangan Antarmuka Tabel Akademik Borang .......................... 72 Gambar 4. 15 Rancangan Antarmuka Custom Chart Akademik Borang ............ 72 Gambar 4. 16 Rancangan Skema Transformasi Dim_Angkatan ......................... 73 Gambar 4. 17 Rancangan Skema Transformasi Dim_Calon_Mahasiswa ........... 73 Gambar 4. 18 Rancangan Skema Transformasi Dim_Dosen ............................... 73 Gambar 4. 19 Rancangan Skema Transformasi Dim_Lulusan ............................ 73 Gambar 4. 20 Rancangan Skema Transformasi Dim_Mahasiswa ....................... 74 Gambar 4. 21 Rancangan Skema Transformasi Dim_Periode ............................. 74 Gambar 4. 22 Rancangan Skema Transformasi Dim_Prodi ................................ 74 Gambar 4. 23 Rancangan Skema Transformasi Fact_Calon_Mahasiswa ........... 75 Gambar 4. 24 Rancangan Skema Transformasi Fact_Mahasiswa ....................... 75 Gambar 4. 25 Rancangan Skema Transformasi Fact_Lulusan ............................ 75 Gambar 4. 27 Rancangan Skema Transformasi Fact_Catatan_Akademik_Dosen ................................................. 76 Gambar 4. 27 Rancangan Skema Transformasi Fact_Catatan_Akademik_Mahasiswa ......................................... 76 Gambar 4. 28 Rancangan Skema Transformasi Fact_Ipk_Mahasiswa ................ 76 Gambar 4. 29 Rancangan Antarmuka Home Keuangan ...................................... 77 Gambar 4. 30 Rancangan Antarmuka Grafik Keuangan ..................................... 77 Gambar 4. 31 Rancangan Antarmuka Tabel Keuangan ....................................... 78 Gambar 4. 32 Rancangan Antarmuka Custom Chart Keuangan ......................... 78 Gambar 4. 33 Rancangan Skema Transformasi Dim_Mahasiswa ....................... 79 Gambar 4. 34 Rancangan Skema Transformasi Dim_Pembayaran ..................... 79 Gambar 4. 35 Rancangan Skema Transformasi Dim_Periode ............................. 79 Gambar 4. 36 Rancangan Skema Transformasi Dim_Prodi ................................ 79 Gambar 4. 37 Rancangan Skema Transformasi Fact_Jml_Mhs_Reg .................. 80 Gambar 4. 38 Rancangan Antarmuka Home SDM .............................................. 80 Gambar 4. 39 Rancangan Antarmuka Grafik SDM ............................................. 81 Gambar 4. 40 Rancangan Antarmuka Tabel SDM .............................................. 81
xvi
Gambar 4. 41 Rancangan Antarmuka Custom Chart SDM ................................. 82 Gambar 4. 42 Rancangan Skema Transformasi Dim_Dosen_Tetap ................... 82 Gambar 4. 43 Rancangan Skema Transformasi Dim_Prodi ................................ 83 Gambar 4. 44 Rancangan Skema Transformasi Dim_Tahun ............................... 83 Gambar 4. 45 Rancangan Skema Transformasi Fact_Dosen ............................... 83 Gambar 4. 46 Rancangan Skema Transformasi Fact_Mengajar .......................... 83 Gambar 4. 47 Rancangan Skema Job Schedule Data Warehouse ....................... 84
Gambar 5. 1 Tampilan Antarmuka Halaman Awal Dashboard .......................... 91 Gambar 5. 2 Tampilan Antarmuka Login Administrator ..................................... 92 Gambar 5. 3 Tampilan Antarmuka Administrator ............................................... 92 Gambar 5. 4 Tampilan Antarmuka Koneksi ........................................................ 93 Gambar 5. 5 Tampilan Antarmuka Periode ......................................................... 93 Gambar 5. 6 Tampilan Antarmuka Team ............................................................. 94 Gambar 5. 7 Tampilan Antarmuka Home Akademik PDPT ................................ 94 Gambar 5. 8 Tampilan Antarmuka Grafik Akademik PDPT ............................... 95 Gambar 5. 9 Tampilan Antarmuka Tabel Akademik PDPT ................................ 95 Gambar 5. 10 Tampilan Antarmuka Custom Chart Akademik PDPT ................. 96 Gambar 5. 11 Tampilan Antarmuka Home Akademik Borang ............................ 96 Gambar 5. 12 Tampilan Antarmuka Grafik Akademik Borang ........................... 97 Gambar 5. 13 Tampilan Antarmuka Tabel Akademik Borang ............................ 97 Gambar 5. 14 Tampilan Antarmuka Custom Chart Akademik Borang ............... 98 Gambar 5. 15 Tampilan Antarmuka Home Keuangan ......................................... 98 Gambar 5. 16 Tampilan Antarmuka Grafik Keuangan ........................................ 99 Gambar 5. 17 Tampilan Antarmuka Tabel Keuangan ......................................... 99 Gambar 5. 18 Tampilan Antarmuka Custom Chart Keuangan .......................... 100 Gambar 5. 19 Tampilan Antarmuka Home SDM .............................................. 100 Gambar 5. 20 Tampilan Antarmuka Grafik SDM ............................................. 101 Gambar 5. 21 Tampilan Antarmuka Tabel SDM ............................................... 101 Gambar 5. 22 Tampilan Antarmuka Custom Chart SDM ................................. 102 Gambar 5. 23 Transformasi Data Mart Akademik Dim_Angkatan .................. 103 Gambar 5. 24 Transformasi Data Mart Akademik Dim_Calon_Mahasiswa .... 103
xvii
Gambar 5. 25 Transformasi Data Mart Akademik Dim_Dosen ........................ 104 Gambar 5. 26 Transformasi Data Mart Akademik Dim_Lulusan ..................... 105 Gambar 5. 27 Transformasi Data Mart Akademik Dim_Mahasiswa ................ 106 Gambar 5. 28 Transformasi Data Mart Akademik Dim_Periode ...................... 106 Gambar 5. 29 Transformasi Data Mart Akademik Dim_Prodi ......................... 107 Gambar 5. 30 Transformasi Data Mart Akademik Fact_Calon_Mahasiswa .... 108 Gambar 5. 31 Transformasi Data Mart Akademik Fact_Mahasiswa ................ 109 Gambar 5. 32 Transformasi Data Mart Akademik Fact_Lulusan ..................... 110 Gambar 5. 33 Transformasi Data Mart Akademik Fact_Catatan_Akademik_Dosen ................................................ 111 Gambar 5. 34 Transformasi Data Mart Akademik Fact_Catatan_Akademik_Mahasiswa ........................................ 112 Gambar 5. 35 Transformasi Data Mart Akademik Fact_Ipk_Mahasiswa ......... 113 Gambar 5. 36 Transformasi Data Mart Keuangan Dim_Mahasiswa ................ 114 Gambar 5. 37 Transformasi Data Mart Keuangan Dim_Pembayaran .............. 115 Gambar 5. 38 Transformasi Data Mart Keuangan Dim_Periode ...................... 115 Gambar 5. 39 Transformasi Data Mart Keuangan Dim_Prodi ......................... 116 Gambar 5. 40 Transformasi Data Mart Keuangan Fact_Jml_Reg_Mhs ........... 117 Gambar 5. 41 Transformasi Data Mart SDM Dim_Dosen_Tetap .................... 118 Gambar 5. 42 Transformasi Data Mart SDM Dim_Prodi ................................. 118 Gambar 5. 43 Transformasi Data Mart SDM Dim_Tahun ................................ 119 Gambar 5. 44 Transformasi Data Mart SDM Fact_Dosen ................................ 120 Gambar 5. 45 Transformasi Data Mart SDM Fact_Mengajar ........................... 120 Gambar 5. 46 Job Schedule Data Warehouse Universitas Widyatama ............. 121 Gambar 5. 47 Task Scheduler 1 ......................................................................... 123 Gambar 5. 48 Task Scheduler 2 ........................................................................ 124 Gambar 5. 49 Task Scheduler 3 ........................................................................ 124 Gambar 5. 50 Task Scheduler 4 ........................................................................ 125 Gambar 5. 51 Task Scheduler 5 ........................................................................ 126 Gambar 5. 52 Task Scheduler 6 ........................................................................ 126 Gambar 5. 53 Task Scheduler 7 ........................................................................ 127 Gambar 5. 54 Task Scheduler 8 ........................................................................ 127
xiv
