RANCANG BANGUN APLIKASI BUSINESS INTELLIGENCE PADA BIDANG AKADEMIK MAHASISWA DAN DOSEN BERBASIS DATA WAREHOUSE

Pratiwi, Adelia Putri (2026) RANCANG BANGUN APLIKASI BUSINESS INTELLIGENCE PADA BIDANG AKADEMIK MAHASISWA DAN DOSEN BERBASIS DATA WAREHOUSE. Undergraduate thesis, UPN "Veteran" Jawa Timur.

	Text (Cover) COVER_organized_compressed.pdf Download (454kB)
	Text (BAB I) BAB 1.pdf Download (195kB)
	Text (BAB II) BAB 2.pdf Restricted to Repository staff only until 20 July 2029. Download (459kB)
	Text (BAB III) BAB 3.pdf Restricted to Repository staff only until 20 July 2029. Download (897kB)
	Text (BAB IV) BAB 4.pdf Restricted to Repository staff only until 20 July 2029. Download (2MB)
	Text (BAB V) BAB 5.pdf Download (131kB)
	Text (DAFTAR PUSTAKA) DAFTAR PUSTAKA.pdf Download (160kB)
	Text (LAMPIRAN) DAFTAR LAMPIRAN.pdf Restricted to Repository staff only until 20 July 2029. Download (1MB)

Abstract

The advancement of information technology has encouraged higher education institutions to utilize academic data as a basis for effective decision-making. However, academic data are often distributed across multiple operational systems, making integrated analysis difficult. This study aims to develop a Business Intelligence system based on a data warehouse to support the analysis of student academic and lecturer performance data at UPN "Veteran" Jawa Timur. The system was developed using the Kimball Nine-Step Methodology for data warehouse design and the Waterfall method for application development. Data were collected from the Academic Information System (SIAKAD), SILATURAHMI, and the Lecturer Performance Application (APP Kinerja Dosen). Data integration was performed through the Extract, Transform, Load (ETL) process using Pentaho Data Integration and stored in a PostgreSQL data warehouse. Multidimensional analysis was implemented using the Mondrian OLAP Server, while data visualization was provided through Metabase dashboards and a web application developed with Laravel and Next.js. The results show that the system successfully integrated academic data into a data warehouse consisting of three fact tables and nine dimension tables. The system supports multidimensional analysis through drill-down and roll-up operations. Testing results indicate that all system functionalities operated as expected, data quality met the accuracy, completeness, uniqueness, and consistency criteria, and User Acceptance Testing (UAT) achieved a user acceptance score of 87.78%. The developed system supports monitoring, evaluation, and data-driven decision-making at UPN "Veteran" Jawa Timur.

Item Type:

Thesis (Undergraduate)

Contributors:

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

Subjects:

H Social Sciences > HG Finance > HG1709 Data processing
Q Science > QA Mathematics > QA76.6 Computer Programming
T Technology > T Technology (General)

Divisions:

Faculty of Computer Science > Departemen of Information Systems

Depositing User:

Adelia Putri Pratiwi

Date Deposited:

20 Jul 2026 06:31

Last Modified:

20 Jul 2026 06:31

URI:

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