RANCANG BANGUN APLIKASI BUSINESS INTELLIGENCE PADA BIDANG PENELITIAN DOSEN BERBASIS DATA WAREHOUSE

Ariansyah, Ramdhan (2026) RANCANG BANGUN APLIKASI BUSINESS INTELLIGENCE PADA BIDANG PENELITIAN DOSEN BERBASIS DATA WAREHOUSE. Undergraduate thesis, UPN "Veteran" Jawa Timur.

	Text (COVER) COVER.pdf Download (735kB)
	Text (BAB 1) BAB 1.pdf Download (250kB)
	Text (BAB 2) BAB 2.pdf Restricted to Repository staff only until 20 July 2029. Download (512kB)
	Text (BAB 3) BAB 3.pdf Restricted to Repository staff only until 20 July 2029. Download (895kB)
	Text (BAB 4) BAB 4.pdf Restricted to Repository staff only until 20 July 2029. Download (2MB)
	Text (BAB 5) BAB 5.pdf Download (199kB)
	Text (LAMPIRAN) LAMPIRAN.pdf Restricted to Repository staff only until 20 July 2029. Download (1MB)
	Text (DAFTAR PUSTAKA) DAFTAR PUSTAKA.pdf Download (186kB)

Abstract

Lecturer research data at UPN "Veteran" Jawa Timur are currently managed across several independent operational systems, namely SIMARIS, SIMAKIN, and SIMPEG. This fragmented environment complicates data integration and limits university management in monitoring research performance comprehensively. This study aims to design and develop a Business Intelligence (BI) application based on a data warehouse to integrate lecturer research data into a centralized monitoring system. The data warehouse was developed using the Kimball Nine-Step Methodology, resulting in a fact constellation schema consisting of three main fact tables: fact_litdos, fact_publikasi, and fact_ajuan_haki within a PostgreSQL database. The data integration process was implemented through the Extract, Transform, Load (ETL) process using Pentaho Data Integration, supported by an incremental loading mechanism to automate data updates efficiently. Data visualization and multidimensional analysis were developed using Metabase and Mondrian OLAP Server and integrated into a web-based application built with Next.js and Laravel. The testing results showed that all ETL processes were executed successfully without errors, with loading times ranging from less than one to seven seconds per table. Furthermore, all Black Box Testing scenarios were successfully completed, while the User Acceptance Testing (UAT) achieved a score of 91.11%, indicating that the application is highly feasible for implementation. The resulting SADAYA application provides executive dashboards and multidimensional analysis to support evidence-based decision-making related to lecturer research, scientific publications, and intellectual property rights (IPR).

Item Type:

Thesis (Undergraduate)

Contributors:

Contribution	Contributors	NIDN/NIDK	Email
Thesis advisor	Afandi, Mohamad Irwan	NIDN0718077605	mohamadafandi.si@upnjatim.ac.id
Thesis advisor	Sugata, Tri Luhur Indayanti	NIDN8948770671230422	tri.luhur.fasilkom@upnjatim.ac.id

Subjects:

Q Science > QA Mathematics > QA76 Computer software
Q Science > QA Mathematics > QA76.6 Computer Programming
T Technology > T Technology (General) > T58.6-58.62 Management Information Systems

Divisions:

Faculty of Computer Science > Departemen of Information Systems

Depositing User:

Ramdhan Ariansyah

Date Deposited:

20 Jul 2026 06:19

Last Modified:

20 Jul 2026 06:19

URI:

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