RANCANG BANGUN APLIKASI BUSINESS INTELLIGENCE PADA BIDANG PENGABDIAN KEPADA MASYARAKAT BERBASIS DATA WAREHOUSE

Hasanah, Nurul Hidayatul (2026) RANCANG BANGUN APLIKASI BUSINESS INTELLIGENCE PADA BIDANG PENGABDIAN KEPADA MASYARAKAT BERBASIS DATA WAREHOUSE. Undergraduate thesis, Universitas Pembangunan Nasional Veteran Jawa Timur.

	Text (Cover) 22082010013_Cover.pdf Download (1MB)
	Text (Bab 1) 22082010013_Bab_1.pdf Download (187kB)
	Text (Bab 2) 22082010013_Bab_2.pdf Restricted to Registered users only until 19 July 2029. Download (499kB)
	Text (BAB 3) 22082010013_Bab_3.pdf Restricted to Registered users only until 20 July 2029. Download (768kB)
	Text (Bab 4) 22082010013_Bab_4.pdf Restricted to Registered users only until 20 July 2029. Download (2MB)
	Text (Bab 5) 22082010013_Bab_5.pdf Download (137kB)
	Text (Daftar Pustaka) 22082010013_Daftar_Pustaka.pdf Download (148kB)
	Text (Lampiran) 22082010013_Lampiran.pdf Restricted to Registered users only until 20 July 2029. Download (2MB)
	Text 22082010013_Cover.pdf Download (491kB)

Abstract

The management of community service data at universities generates an ever-increasing volume of data each period. However, this data is generally used only as an administrative archive and has not been optimized to support analysis or decision-making. As a result, university leadership faces difficulties in obtaining integrated information regarding the implementation of community service activities. This study aims to develop a Business Intelligence system to support the analysis of faculty community service data through the implementation of a data warehouse, Online Analytical Processing (OLAP), and dashboards. The data warehouse was developed using the Kimball approach with an Extract, Transform, Load (ETL) process to integrate data from operational systems. Multidimensional analysis was implemented using the Mondrian OLAP Server, while data visualization was presented through Metabase.The results of the study show that the developed system can store community service data in a single centralized repository and provide multidimensional analysis features based on the dimensions of time, faculty member, role, faculty, and funding source. The resulting dashboard presents information concisely and interactively. Data warehouse quality testing showed a completeness rate of 90.58% for the fact pengabdian table, 90.57% for the fact anggota pkm table, and 89.93% for the fact kerjasama table. Furthermore, functional testing of the system using black-box testing showed that 18 system test scenarios ran as required, while the User Acceptance Test (UAT) results achieved an acceptance rate of 91.11%, indicating that the system was very well received by users.

Item Type:

Thesis (Undergraduate)

Contributors:

Contribution	Contributors	NIDN/NIDK	Email
Thesis advisor	Afandi, Mohamad Irwan	NIDN197607182021211003	mohamadafandi.si@upnjatim.ac.id
Thesis advisor	Najaf, Abul Rezha Efrat	NIDN199409292022031008	rezha.efrat.sifo@upnjatim.ac.id

Subjects:

H Social Sciences > HG Finance > HG1709 Data processing

Divisions:

Faculty of Computer Science > Departemen of Information Systems

Depositing User:

Nurul Hidayatul Hasanah

Date Deposited:

21 Jul 2026 01:45

Last Modified:

22 Jul 2026 10:28

URI:

https://repository.upnjatim.ac.id/id/eprint/56139