Daviarsyah, Muhammad Alarik (2026) Rancang Bangun Data Warehouse dan Dashboard Business Intelligence untuk Analisis Prestasi dan Alumni di MAN 2 Kota Malang. Other thesis, Institut Teknologi Sepuluh Nopember.
![[thumbnail of 5026221015-Undergraduate_Thesis.pdf]](http://repository.its.ac.id/style/images/fileicons/text.png) |
Text
5026221015-Undergraduate_Thesis.pdf Restricted to Repository staff only Download (9MB) | Request a copy |
Abstract
Pengelolaan data di MAN 2 Kota Malang masih dilakukan secara parsial sehingga data alumni dan prestasi tersebar pada berbagai sumber dengan format yang berbeda. Kondisi tersebut menyebabkan proses integrasi data, penyusunan laporan, dan pengambilan keputusan menjadi kurang efisien. Penelitian ini bertujuan merancang dan membangun Data Warehouse serta dashboard Business Intelligence yang mampu mengintegrasikan data alumni dan prestasi ke dalam satu sistem terpusat guna mendukung pengambilan keputusan berbasis data di MAN 2 Kota Malang. Data Warehouse dirancang menggunakan Kimball's Nine-Step Methodology dengan arsitektur Galaxy Schema, sedangkan proses Extract, Transform, and Load (ETL) dibangun menggunakan Pentaho Data Integration dan dashboard dikembangkan menggunakan Microsoft Power BI berdasarkan kebutuhan pengguna yang diperoleh melalui tahap requirement gathering. Evaluasi sistem dilakukan melalui Data Quality Check (DQC), User Acceptance Test (UAT), dan pengujian usability menggunakan System Usability Scale (SUS). Hasil pengujian menunjukkan bahwa DQC memperoleh tingkat kelulusan 100% pada 70 test case, UAT memperoleh tingkat kelulusan 100% pada 24 requirement, dan SUS menghasilkan skor rata-rata 88,33 yang termasuk kategori Acceptable, Grade A, dan Excellent. Hasil tersebut menunjukkan bahwa sistem yang dikembangkan mampu menghasilkan data yang berkualitas, memenuhi kebutuhan pengguna, serta layak digunakan sebagai pendukung pengambilan keputusan berbasis data di MAN 2 Kota Malang.
====================================================================================================================================
Data management at MAN 2 Kota Malang is still conducted separately, resulting in alumni and student achievement data being stored across multiple sources with different formats. This condition leads to inefficient data integration, report generation, and information provision to support decision-making. This study aims to design and develop a Data Warehouse and Business Intelligence dashboard that integrate alumni and student achievement data into a centralized system. The Data Warehouse was designed using Kimball's Nine-Step Methodology with a Galaxy Schema architecture, while the Extract, Transform, and Load (ETL) process was implemented using Pentaho Data Integration. The Business Intelligence dashboard was developed using Microsoft Power BI based on user requirements identified during the requirement gathering stage. System evaluation was conducted through Data Quality Check (DQC), User Acceptance Test (UAT), and usability testing using the System Usability Scale (SUS). The evaluation results showed that the DQC achieved a 100% pass rate across 70 test cases, the UAT achieved a 100% pass rate across 24 requirements, and the SUS yielded an average score of 88.33, which falls into the Acceptable category, with Grade A and an Excellent adjective rating. These findings indicate that the developed system produces high-quality data, satisfies user requirements, and demonstrates excellent usability, making it suitable for supporting data-driven decision-making at MAN 2 Kota Malang.
| Item Type: | Thesis (Other) |
|---|---|
| Uncontrolled Keywords: | Business Intelligence, Dashboard, Data Warehouse, ETL, Metodologi Nine-Step Kimball, Business Intelligence, Dashboard, Data Warehouse, ETL, Kimball’s Nine-Step Methodology |
| Subjects: | T Technology > T Technology (General) T Technology > T Technology (General) > T385 Visualization--Technique T Technology > T Technology (General) > T57.5 Data Processing T Technology > T Technology (General) > T58.62 Decision support systems |
| Divisions: | Faculty of Intelligent Electrical and Informatics Technology (ELECTICS) > Information System > 57201-(S1) Undergraduate Thesis |
| Depositing User: | Muhammad Alarik Daviarsyah |
| Date Deposited: | 29 Jul 2026 02:59 |
| Last Modified: | 29 Jul 2026 02:59 |
| URI: | http://repository.its.ac.id/id/eprint/139329 |
Actions (login required)
 |
View Item |