ANALISIS DAN PERANCANGAN DATA WAREHOUSE PADA SOFTWARE LABORATORY CENTER BINUS UNIVERSITY
SKRIPSI
Oleh
Johanes (0900792051) Al vin Chandra (0900802134) Irwan Chandra (0900832401) Kelas/Kelompok : 07PCT / 08
alaman Judul Luar
Uni versitas Bina Nusantara Jakarta 2009
ANALISIS DAN PERANCANGAN DATA WAREHOUSE PADA SOFTWARE LABORATORY CENTER BINUS UNIVERSITY
SKRIPSI
diajukan sebagai salah satu syarat untuk gelar kesarjanaan pada Jurusan Teknik Informatika Program Studi Database Jenjang Pendidikan Strata-1 Oleh Johanes (0900792051) Al vin Chandra (0900802134) Irwan Chandra (0900832401) Kelas/Kelompok : 07PCT / 08
BAB 1 Halaman Judul Dalam
Uni versitas Bina Nusantara Jakarta 2009
ANALISIS DAN PERANCANGAN DATA WAREHOUSE PADA SOFTWARE LABORATORY CENTER BINUS UNIVERSITY
S KRIPS I
Disusun Oleh :
Johanes
Alvin Chandra
Irwan Chandra
0900792051
0900802134
0900832401
Disetujui oleh : Pembimbing Halaman Persetujuan Hardcover
S atmoko Yudo, Drs., M.Eng. Kddsn : D1826
Universitas Bina Nusantara Jakarta 2009
PRAKATA
Puji dan syukur penulis panjatkan kepada Tuhan Yang M aha Esa, berkat karunia-Nya, sehingga kami dapat menyelesaikan skripsi dengan judul “Analisis Dan Perancangan Data Warehouse Pada Software Laboratory Center Binus University” ini tepat pada waktunya. Adapun skripsi ini dibuat sebagai salah satu syarat kelulusan pada jenjang pendidikan Strata-1 jurusan Teknik Informatika pada Binus University, Jakarta. Dalam penyusunan skripsi ini, penulis mendapatkan banyak dukungan dan bantuan dari berbagai pihak, baik secara langsung maupun tidak langsung. Oleh karena itu, penulis mengucapkan terima kasih yang sebesar-besarnya kepada: •
Bapak Prof. Dr. Gerardus Polla, M .App.Sc., selaku Rektor Universitas Bina Nusantara.
•
Bapak Ir. Sablin Yusuf, M .Sc., M .Comp.Sc., selaku Dekan Fakultas Ilmu Komputer Universitas Bina Nusantara.
•
Bapak Fredy Purnomo, S.Kom., M .Kom., selaku Ketua Jurusan Teknik Informatika Uniersitas Bina Nusantara.
•
Ibu Yen Lina Prasetio, S.Kom., M .CompSc., selaku Sekretaris Jurusan Teknik Informatika.
•
Bapak Satmoko Yudo, Drs., M .Eng., selaku dosen pembimbing yang telah banyak memberikan pengarahan, saran dan motivasi kepada kami dalam menyelesaikan skripsi ini.
•
Bapak Win Ce, S.Kom., MM ., selaku Software Laboratory Center manager yang telah memberikan izin kepada penulis untuk melakukan survei di Software Laboratory Center.
•
Seluruh staf Software Laboratory Center yang telah banyak membantu dalam memberikan informasi yang sangat bermanfaat dalam penulisan skripsi ini.
•
Seluruh staf pengajar Jurusan Teknik Informatika Bina Nusantara yang telah membimbing penulis selama kuliah.
•
Orang tua beserta keluarga yang telah memberi dukungan moral maupun material kepada penulis.
•
Seluruh rekan dan pihak yang telah banyak membantu penulis dalam penyusunan skripsi ini baik secara langsung maupun tidak langsung yang tidak dapat disebutkan satu persatu. Penulis menyadari bahwa penulisan skripsi ini masih jauh dari sempurna
karena keterbatasan pengetahuan dan pengalaman penulis. Oleh karena itu, kritik dan saran yang ditujukan untuk menyempurnakan skripsi ini sangat diperlukan dan diharapkan. Akhir kata, penulis mohon maaf jika ada kata-kata yang kurang berkenan di hati. Semoga skripsi ini bisa bermanfaat bagi Software Laboratory Center maupun pembaca.
Jakarta, 2 Februari 2009
Penulis
DAFTAR IS I
Halaman Judul Luar ....................................................................................................i Halaman Judul Dalam ................................................................................................ii Halaman Persetujuan Hard Cover .............................................................................iii Halaman Pernyataan Dewan Penguji ........................................................................iv Abstrak .....................................................................................................................vii PRAKATA ..............................................................................................................viii DAFTAR ISI ..............................................................................................................x DAFTAR TABEL ....................................................................................................xv DAFTAR GAM BAR ............................................................................................xxiii DAFTAR LAMPIRAN .........................................................................................xxvi BAB 1 PENDAHULUAN .........................................................................................1 1.1 Latar Belakang ...............................................................................................1 1.2 Ruang Lingkup ...............................................................................................2 1.3 Tujuan dan M anfaat .......................................................................................2 1.4 M etodologi Penelitian ....................................................................................3 1.5 Sistematika Penulisan ....................................................................................4 BAB 2 LANDASAN TEORI .....................................................................................6 2.1 Pengertian Data ..............................................................................................6 2.2 Pengertian Database .......................................................................................6 2.3 Database M anagement System (DBM S) .......................................................7 2.4 Data warehouse ..............................................................................................7 2.4.1
Pengertian Data warehouse ................................................................7
2.4.2
Karakteristik Data warehouse ............................................................8
2.4.3
Struktur data warehouse ...................................................................10
2.4.3.1
Current Detail Data .................................................................10
2.4.3.2
Older Detail Data ....................................................................11
2.4.3.3
Lightly Summarized Data .......................................................11
2.4.3.4
Highly Summarized Data ........................................................12
2.4.3.5
M etadata ..................................................................................12
2.4.3
Arsitektur Data Warehouse ..............................................................14
2.4.4
Aliran Data Pada Data Warehouse ...................................................16
2.4.5
Anatomi Data warehouse .................................................................18
2.4.6.1
Data warehouse Fungsional ....................................................18
2.4.6.2
Data Warehouse Terpusat .......................................................19
2.4.6.3
Data Warehouse Terdistribusi .................................................20
2.4.7
Fungsi Data warehouse ....................................................................21
2.4.8
Keuntungan Data warehouse ...........................................................23
2.4.9
Data M art .........................................................................................24
2.4.10 Teori Permodelan Data warehouse ..................................................24 2.4.10.1 Skema Bintang ........................................................................24 2.4.10.1.1 Pengertian Skema Bintang .............................................24 2.4.10.1.2 Keuntungan M enggunakan Skema Bintang ...................26 2.4.10.1.3 Skema Bintang Sederhana .............................................27 2.4.10.1.4 Skema Bintang Dengan Banyak Tabel Fakta ................29 2.4.10.1.5 Skema Bintang M ajemuk ...............................................29 2.4.10.2 Skema Snowflake ....................................................................30
2.4.10.3 Skema Starflake ......................................................................31 2.4.11 Teori Perancangan Data warehouse .................................................32 2.4.11.1 Identifikasi Proses ...................................................................32 2.4.11.2 Identifikasi Grain ....................................................................33 2.4.11.3 Identifikasi Dimensi ................................................................33 2.4.11.4 Identifikasi Fakta .....................................................................34 2.4.11.5 M enyimpan Pre-Calculation Dalam Tabel Fakta ....................34 2.4.11.6 Rounding Out Tabel Dimensi .................................................34 2.4.11.7 M emilih Durasi Database ........................................................34 2.4.11.8 M engawasi Perubahan Dimensi ..............................................35 2.4.11.9 M emutuskan Prioritas M ode Query ........................................35 2.4.12 ETL (Extract, Transform, Loading) .................................................36 2.4.12.1 Extract .....................................................................................36 2.4.12.2 Transform ................................................................................37 2.4.12.3 Loading ...................................................................................38 BAB 3 ANALISIS SISTEM YANG SEDANG BERJALAN .................................41 3.1 Latar Belakang Organisasi ...........................................................................41 3.2 Struktur Organisasi ......................................................................................42 3.3 Tata Laksana/Prosedur yang Sedang Berjalan .............................................87 3.3.1
Prosedur Persiapan Praktikum .........................................................88
3.3.2
Prosedur Pelaksanaan Praktikum .....................................................90
3.3.3
Prosedur Persiapan Ujian .................................................................91
3.3.4
Prosedur Pelaksanaan Ujian .............................................................93
3.3.5
Prosedur Penerimaan Asisten Baru ..................................................94
3.3.6
Prosedur Pengolahan Nilai Praktikum .............................................95
3.3.7
Prosedur Evaluasi Praktikum ...........................................................96
3.3.8
Prosedur Peminjaman Ruang Praktikum .........................................97
3.3.8.1
Peminjaman Rutin ...................................................................97
3.3.8.2
Peminjaman Non Rutin ...........................................................98
3.3.9
Prosedur Pengembangan Asisten .....................................................99
3.3.9.1
Tes Peningkatan Asisten (TPA) ..............................................99
3.3.9.2
Special Interest Group (SIG) .................................................100
3.4 Analisis Database .......................................................................................100 3.5 Analisis Kebutuhan Data dan Informasi ....................................................173 3.6 Permasalahan yang Dihadapi .....................................................................175 3.7 Alternatif Pemecahan M asalah ..................................................................175 BAB 4 IM PLEM ENTASI DAN EVALUASI .......................................................177 4.1 Arsitektur data warehouse ..........................................................................177 4.2 Perancangan Data warehouse .....................................................................178 4.2.1
M emilih proses ...............................................................................178
4.2.2
M emilih grain .................................................................................179
4.2.3
Identifikasi dan membuat dimensi yang sesuai ..............................180
4.2.4
M emilih fakta .................................................................................185
4.2.5
M enyimpan pre-kalkulasi dalam tabel fakta ..................................186
4.2.6
M elengkapi tabel dimensi ..............................................................192
4.2.7
M emilih durasi dari database .........................................................201
4.2.8
M elacak perubahan dari dimensi secara perlahan ..........................201
4.2.9
M emutuskan prioritas dan mode dari query ..................................202
4.3 M etadata .....................................................................................................231 4.4 Rencana Implementasi ...............................................................................261 4.4.1
Dukungan perangkat keras .............................................................261
4.4.2
Dukungan perangkat lunak ............................................................262
4.5 Transformasi Data ......................................................................................263 4.5.1
Proses transformasi tabel dimensi ..................................................264
4.5.2
Proses transformasi tabel fakta ......................................................267
4.6 Rancangan Layar ........................................................................................270 4.6.1.1.Rancangan layar halaman Pivot Table ...........................................270 4.6.1.2.Rancangan layar halaman Pivot Chart ...........................................271 4.7 Estimasi waktu implementasi data warehouse ...........................................272 4.8 Rencana backup .........................................................................................274 4.9 Analisis manfaat .........................................................................................274 4.10 Evaluasi ...................................................................................................276 BAB 5 KESIM PULAN DAN SARAN .................................................................277 5.1 Simpulan ....................................................................................................277 5.2 Saran ...........................................................................................................277 DAFTAR PUSTAKA ............................................................................................279 RIWAYAT HIDUP ................................................................................................280 LAMPIRAN ...........................................................................................................283 SURAT SURVEI ...................................................................................................291
DAFTAR TABEL
Tabel 2.1 Tabel Perbandingan Sistem OLTP dan Sistem Data Warehouse ...............9 Tabel 3.1 Tabel CourseEOJStudentAllowedTimes ................................................104 Tabel 3.2 Tabel StudentCourseOJProblemAnswers.............................................. 105 Tabel 3.3 Tabel CourseOJProblemInCourseOJM eetings ......................................105 Tabel 3.4 Tabel CourseM CProblemRandomInCourseM CM eetings .....................106 Tabel 3.5 Tabel Students ........................................................................................107 Tabel 3.6 Tabel StudentExamAnswers ..................................................................107 Tabel 3.7 Tabel StudentCourseOJProblemAnswerResults.....................................108 Tabel 3.8 Tabel FormalEducationLevels ................................................................109 Tabel 3.9 Tabel NARTrainees ................................................................................109 Tabel 3.10 Tabel NARStudents ..............................................................................110 Tabel 3.11 Tabel FormalEducations .......................................................................111 Tabel 3.12 Tabel NARSAProblemPackets .............................................................111 Tabel 3.13 Tabel NARSAProblemResultApprovals ..............................................112 Tabel 3.14 Tabel NARSAProblemPacketSchedules ..............................................112 Tabel 3.15 Tabel NARSAProblems ........................................................................113 Tabel 3.16 Tabel NARSAProblemResults..............................................................114 Tabel 3.17 Tabel NARSAPacketInSubjects ...........................................................114 Tabel 3.18 Tabel NARSAAnswers.........................................................................115 Tabel 3.19 Tabel NARSAResults ...........................................................................115 Tabel 3.20 Tabel ClassTransactionInCourseQEM eetings ......................................116 Tabel 3.21 Tabel CourseOJM eetings......................................................................117
Tabel 3.22 Tabel CourseM CProblems....................................................................117 Tabel 3.23 Tabel CourseM CProblemInCourseM CM eetings..................................118 Tabel 3.24 Tabel CourseM CM eetings ....................................................................119 Tabel 3.25 Tabel StudentM CProblemAnswers ......................................................119 Tabel 3.26 Tabel StudentExamAnswerDetails .......................................................120 Tabel 3.27 Tabel StudentGroupProjectAnswerDetails...........................................121 Tabel 3.28 Tabel CourseOJProblemResults ...........................................................121 Tabel 3.29 Tabel CourseOJProblemInCourseEOJM eetings...................................122 Tabel 3.30 Tabel NonFormalEducations ................................................................123 Tabel 3.31 Tabel NARStudentParents....................................................................123 Tabel 3.32 Tabel NARStudentEmergencyContacts................................................124 Tabel 3.33 Tabel NARM CPacketInSubjects ..........................................................125 Tabel 3.34 Tabel NARM CProblemPacketSchedules .............................................125 Tabel 3.35 Tabel NARSubjects ..............................................................................126 Tabel 3.36 Tabel NARTrainers...............................................................................126 Tabel 3.37 Tabel NAROJPacketInSubjects ............................................................127 Tabel 3.38 Tabel NAROJResults............................................................................127 Tabel 3.39 Tabel NAROJAnswerResults ...............................................................128 Tabel 3.40 Tabel NAROJAnswers..........................................................................128 Tabel 3.41 Tabel NAROJProblemSchedules ..........................................................129 Tabel 3.42 Tabel EmployeeM CProblemAnswers ..................................................130 Tabel 3.43 Tabel CourseEOJM eetings ...................................................................130 Tabel 3.44 Tabel Contracts .....................................................................................131 Tabel 3.45 Tabel ClassTransactionCourseEOJM eetingTimes ...............................131
Tabel 3.46 Tabel ClassTransactionStatus ...............................................................132 Tabel 3.47 Tabel SubjectInSubjectGroups .............................................................132 Tabel 3.48 Tabel StudentOJM eetingSchedules ......................................................133 Tabel 3.49 Tabel EmployeeInSubjectGroups.........................................................133 Tabel 3.50 Tabel SubjectGroups.............................................................................134 Tabel 3.51 Tabel StudentGroupProjectAnswers.....................................................134 Tabel 3.52 Tabel StudentInStudentGroups.............................................................135 Tabel 3.53 Tabel StudentInRoomTransactions.......................................................135 Tabel 3.54 Tabel StudentCourseEOJProblemAnswerResults ................................136 Tabel 3.55 Tabel StudentCourseEOJProblemAnswers ..........................................137 Tabel 3.56 Tabel Subjects .......................................................................................137 Tabel 3.57 Tabel M ajors .........................................................................................138 Tabel 3.58 Tabel NARBrotherhoods ......................................................................138 Tabel 3.59 Tabel NARStudentRelations.................................................................139 Tabel 3.60 Tabel NARM CProblemPackets ............................................................139 Tabel 3.61 Tabel NARM CProblems.......................................................................140 Tabel 3.62 Tabel NARM CAnswers........................................................................140 Tabel 3.63 Tabel NAROJProblemPacketSchedules ...............................................141 Tabel 3.64 Tabel NAROJProblemPackets..............................................................141 Tabel 3.65 Tabel NAROJProblems ........................................................................142 Tabel 3.66 Tabel NAROJUserSchedules ................................................................143 Tabel 3.67 Tabel CourseOJProblems......................................................................143 Tabel 3.68 Tabel Positions......................................................................................144 Tabel 3.69 Tabel EmployeeCourseEOJProblemAnswerResults ............................145
Tabel 3.70 Tabel EmployeeCourseEOJProblemAnswers ..................................... 145 Tabel 3.71 Tabel EmployeeCourseOJProblemAnswerResults...............................146 Tabel 3.72 Tabel ClassTransactionInCourseM CM eetings .....................................147 Tabel 3.73 Tabel RoomTransactionAssistants........................................................147 Tabel 3.74 Tabel CourseSAM eetings .....................................................................148 Tabel 3.75 Tabel Classes ........................................................................................148 Tabel 3.76 Tabel CourseSAProblems .....................................................................149 Tabel 3.77 Tabel EmployeeCourseOJProblemAnswers.........................................150 Tabel 3.78 Tabel StudentCourseSAProblemAnswers ............................................150 Tabel 3.79 Tabel StudentCourseSAProblemAnswerResults ..................................151 Tabel 3.80 Tabel ClassTransactionDetails..............................................................152 Tabel 3.81 Tabel RoomTransactions ......................................................................152 Tabel 3.82 Tabel ClassTransactions .......................................................................153 Tabel 3.83 Tabel CourseQEProblems .....................................................................153 Tabel 3.84 Tabel StudentCourseQEProblemAnswers ............................................154 Tabel 3.85 Tabel CourseQEProblemInCourseQEM eetings ...................................155 Tabel 3.86 Tabel CourseQEM eetings .....................................................................155 Tabel 3.87 Tabel Religions .....................................................................................156 Tabel 3.88 Tabel StudentCourseSAProblemAnswerDetails ..................................157 Tabel 3.89 Tabel TrPeminjamanLuar .....................................................................157 Tabel 3.90 Tabel Rooms .........................................................................................158 Tabel 3.91 Tabel ClassTransactionDetailRooms ....................................................158 Tabel 3.92 Tabel M sJenisAlokasi...........................................................................159 Tabel 3.93 Tabel TrPraktikum................................................................................160
Tabel 3.94 Tabel ClassTransactionDetailRoomAssistants.....................................160 Tabel 3.95 Tabel TrKoreksi....................................................................................161 Tabel 3.96 Tabel Employees...................................................................................162 Tabel 3.97 Tabel EmployeeCourseQEProblemAnswers ........................................163 Tabel 3.98 Tabel EmployeeSupervisors .................................................................163 Tabel 3.99 Tabel LecturerInEmployees..................................................................164 Tabel 3.100 Tabel EmployeeInSubjectPICs ...........................................................164 Tabel 3.101 Tabel TrProtesNilai.............................................................................165 Tabel 3.102 Tabel M sHari......................................................................................165 Tabel 3.103 Tabel M sShift......................................................................................166 Tabel 3.104 Tabel M sM id.......................................................................................166 Tabel 3.105 Tabel M sJenisKoreksi.........................................................................166 Tabel 3.106 Tabel TrUbahAbsensi.........................................................................167 Tabel 3.107 Tabel TrAlokasiAst.............................................................................168 Tabel 3.108 Tabel Resigns ......................................................................................168 Tabel 3.109 Tabel Lecturer.....................................................................................169 Tabel 3.110 Tabel TrNilaiM hs................................................................................169 Tabel 3.111 Tabel TrIjinM hs..................................................................................170 Tabel 3.112 Tabel TrAlokasiM hs...........................................................................170 Tabel 3.113 Tabel TrPertemuan..............................................................................171 Tabel 3.114 Tabel TrIkaa........................................................................................171 Tabel 3.115 Tabel StudentGroups ..........................................................................172 Tabel 3.116 Tabel TrBuatSoal ................................................................................172 Tabel 3.117 Tabel M sJenisSoal ..............................................................................173
Tabel 4.1 Tabel Grain VS Dimensi Pada Laporan Nilai M ahasiswa......................181 Tabel 4.2 Tabel Grain VS Dimensi Pada Laporan Absensi....................................182 Tabel 4.3 Tabel Grain VS Dimensi Pada Laporan Kelulusan ................................182 Tabel 4.4 Tabel Grain VS Dimensi Pada Laporan Utilisasi RuangPraktikum .......182 Tabel 4.5 Tabel Grain VS Dimensi Pada Laporan IKAA.......................................183 Tabel 4.6 Tabel Grain VS Dimensi Pada Laporan Koreksi....................................184 Tabel 4.7 Tabel Grain VS Dimensi Pada Laporan Pembuatan Soal.......................184 Tabel 4.8 Tabel Grain VS Dimensi Pada Laporan Perubahan Nilai.......................184 Tabel 4.9 Tabel Grain VS Dimensi Pada Laporan Kehadiran Trainee...................185 Tabel 4.10 Tabel Grain VS Dimensi Pada Laporan Nilai Trainee .........................185 Tabel 4.11 Tabel Daftar Deskripsi Tabel Dimensi .................................................192 Tabel 4.12 Tabel Dim_Ruang ................................................................................193 Tabel 4.13 Tabel Dim_Karyawan...........................................................................193 Tabel 4.14 Tabel Dim_Angkatan............................................................................193 Tabel 4.15 Tabel Dim_Group .................................................................................193 Tabel 4.16 Tabel Dim_AstSpv................................................................................194 Tabel 4.17 Tabel Dim_SubCo ................................................................................194 Tabel 4.18 Tabel Dim_M ataKuliah ........................................................................194 Tabel 4.19 Tabel Dim_Kelas ..................................................................................194 Tabel 4.20 Tabel Dim_Shift....................................................................................194 Tabel 4.21 Tabel Dim_Waktu.................................................................................195 Tabel 4.22 Tabel Dim_Trainee ...............................................................................195 Tabel 4.23 Tabel Durasi Basis Data........................................................................201 Tabel 4.24 Tabel Proses ETL (Extract, Transform, and Load) .............................202
Tabel 4.25 Tabel Proses Backup ............................................................................203 Tabel 4.26 Tabel Penggunaan Laporan Atau Kebutuhan Informasi.......................203 Tabel 2.27 Tabel Analisis Kapasitas M edia Penyimpanan Untuk Tabel Fakta......230 Tabel 2.28 Tabel Analisis Kapasitas M edia Penyimpanan Untuk Tabel Dimensi .230 Tabel 4.29 Tabel M etadata Dim_Ruang.................................................................232 Tabel 4.30 Tabel M etadata Dim_Karyawan...........................................................233 Tabel 4.31 Tabel M etadata Dim_Angkatan............................................................233 Tabel 4.32 Tabel M etadata Dim_Group .................................................................234 Tabel 4.33 Tabel M etadata Dim_AstSpv................................................................234 Tabel 4.34 Tabel M etadata Dim_SubCo.................................................................235 Tabel 4.35 Tabel M etadata Dim_M ataKuliah ........................................................235 Tabel 4.36 Tabel M etadata Dim_Kelas ..................................................................236 Tabel 4.37 Tabel M etadata Dim_Shift....................................................................236 Tabel 4.38 Tabel M etadata Dim_Waktu.................................................................237 Tabel 4.39 Tabel M etadata Dim_Trainee ...............................................................238 Tabel 4.40 Tabel M etadata Fakta_LaporanNilaiM ahasiswa..................................239 Tabel 4.41 Tabel M etadata Fakta_LaporanAbsensi ...............................................252 Tabel 4.42 Tabel M etadata Fakta_LaporanKelulusan............................................254 Tabel 4.43 Tabel M etadata Fakta_LaporanUtilisasiRuangPraktikum ....................255 Tabel 4.44 Tabel M etadata Fakta_LaporanIKAA ..................................................257 Tabel 4.45 Tabel M etadata Fakta_LaporanKoreksi................................................259 Tabel 4.46 Tabel M etadata Fakta_LaporanPembuatanSoal ...................................262 Tabel 4.47 Tabel M etadata Fakta_LaporanPerubahanNilai ...................................265 Tabel 4.48 Tabel M etadata Fakta_LaporanKehadiranTrainee ...............................267
Tabel 4.49 Tabel M etadata Fakta_LaporanNilaiTrainee ........................................269 Tabel 4.50 Tabel estimasi waktu implementasi data warehouse ............................272 Tabel 4.51 Tabel rencana backup ...........................................................................274
DAFTAR GAMBAR
Gambar 2.1 Struktur data warehouse ...................................................................... 14 Gambar 2.2 Gambar Arsitektur Data warehouse .....................................................15 Gambar 2.3 Gambar Aliran Data warehouse ..........................................................17 Gambar 2.4 Data warehouse Fungsional .................................................................18 Gambar 2.5 Data warehouse Terpusat ....................................................................20 Gambar 2.6 Data warehouse Terdistribusi ..............................................................21 Gambar 2.7 Skema Bintang .....................................................................................25 Gambar 2.8 Skema Bintang Sederhana ....................................................................28 Gambar 2.9 Skema Snowflake .................................................................................31 Gambar 2.10 Skema Starflake .................................................................................32 Gambar 2.11 Extract, Transform, Loading (ETL) ...................................................40 Gambar 3.1 Gambar struktur organisasi Software Laboratory Center ....................43 Gambar 3.2 Gambar prosedur persiapan praktikum ................................................88 Gambar 3.3 Prosedur Pelaksanaan Praktikum .........................................................90 Gambar 3.4 Gambar prosedur persiapan ujian .........................................................91 Gambar 3.5 Gambar prosedur pelaksanaan ujian ....................................................93 Gambar 3.6 Gambar prosedur penerimaan asisten baru ..........................................94 Gambar 3.7 Gambar prosedur pengolahan nilai praktikum .....................................95 Gambar 3.8 Gambar prosedur evaluasi praktikum ..................................................96 Gambar 3.9 Gambar prosedur peminjaman rutin .....................................................97 Gambar 3.10 Gambar prosedur peminjaman non rutin ............................................98 Gambar 3.11 Gambar prosedur pengembangan asisten ...........................................99
Gambar 3.12 Gambar prosedur tes peningkatan asisten (TPA) ...............................99 Gambar 3.13 Gambar prosedur peminjaman non rutin ..........................................100 Gambar 3.14 ERD bagian NAR .............................................................................101 Gambar 3.14 ERD bagian kuis online ...................................................................102 Gambar 3.16 ERD bagian Transaksi Praktikum ....................................................103 Gambar 4.1 Gambar Arsitektur data warehouse Terpusat pada Software Laboratory Center .....................................................................................................................178 Gambar 4.2 Gambar Skema Bintang Fakta_LaporanNilaiM ahasiswa ..................196 Gambar 4.3 Gambar Skema Bintang Fakta_LaporanAbsensi ...............................197 Gambar 4.4 Gambar Skema Bintang Fakta_LaporanKelulusan ............................197 Gambar 4.5 Gambar Skema Bintang Fakta_LaporanUtilisasiRuangPraktikum ....198 Gambar 4.6 Gambar Skema Bintang Fakta_LaporanIKAA ..................................198 Gambar 4.7 Gambar Skema Bintang Fakta_LaporanKoreksi ...............................199 Gambar 4.8 Gambar Skema Bintang Fakta_LaporanPembuatanSoal ...................199 Gambar 4.9 Gambar Skema bintang Fakta_LaporanPerubahanNilai ....................200 Gambar 4.10 Gambar Skema Bintang Fakta_LaporanKehadiranTrainee .............200 Gambar 4.11 Gambar Skema Bintang Fakta_LaporanNilaiTrainee ......................201 Gambar 4.12 Gambar penghubung database sumber dan database tujuan Dim_Ruang ............................................................................................................265 Gambar 4.13 Gambar pengaturan database sumber Dim_Ruang .........................266 Gambar 4.14 Gambar Pengaturan database tujuan Dim_Ruang ...........................266 Gambar 4.15 Gambar mapping tabel sumber terhadap tabel tujuan Dim_Ruang .267 Gambar 4.16 Gambar penghubung database sumber dan database tujuan Fakta_LaporanNilaiM ahasiswa .............................................................................268
Gambar 4.17 Gambar Pengaturan database sumber Fakta_LaporanNilaiM ahasiswa .............................................................................269 Gambar 4.18 Gambar Pengaturan database tujuan Fakta_LaporanNilaiM ahasiswa .............................................................................269 Gambar 4.19 Gambar mapping tabel sumber terhadap tabel tujuan Fakta_LaporanNilaiM ahasiswa .............................................................................270 Gambar 4.20 Gambar rancangan layar halaman Pivot Table ................................271 Gambar 4.21 Gambar Rancangan Layar Halaman Pivot Chart .............................272
DAFTAR LAMPIRAN
Lampiran 1 Tampilan Layar Pivot Table ............................................................... L1 Lampiran 2 Tampilan Layar Pivot Chart ................................................................ L3 Lampiran 3 Hasil Wawancara ................................................................................. L5 Lampiran 4 Hasil Evaluasi ...................................................................................... L8
