Rancang Bangun Data Warehouse Untuk Pembuatan Laporan dan Analisis pada Data Kunjungan Pasien Rawat Jalan Rumah Sakit Universitas Airlangga Berbasis Online Analytical Processing (OLAP)

Ardista, Nur; Purbandini, Purbandini; Taufik, Taufik

doi:10.20473/jisebi.3.1.40-51

Jurnal SINTA 1

Rancang Bangun Data Warehouse Untuk Pembuatan Laporan dan Analisis pada Data Kunjungan Pasien Rawat Jalan Rumah Sakit Universitas Airlangga Berbasis Online Analytical Processing (OLAP)

Journal of Information Systems Engineering and Business Intelligence · Vol. 3 No. 1 (2017) · pp. 40–51

DOI: 10.20473/jisebi.3.1.40-51
ISSN: 2443-2555, 2598-6333
Published: 2017-04-28
Publisher: Universitas Airlangga
Language: eng

Abstract

Abstrak” Rumah Sakit Universitas Airlangga (RSUA) merupakan sarana pelayanan kesehatan yang dikelola di bawah naungan Universitas Airlangga. Seiring berjalannya proses bisnis, jumlah pasien RSUA yang semakin bertambah menyebabkan data kunjungan pasien rawat jalan yang harus dikelola oleh bagian rekam medis semakin banyak. Data tersebut dikelola untuk digunakan dalam pembuatan laporan. Informasi dalam laporan dihasilkan melalui perhitungan secara manual atau menggunakan formula Microsoft Excel menjadi kendala dalam pembuatan laporan selain adanya kebutuhan laporan dengan format beragam dan analisis multidimensional. Data warehouse berbasis Online Analytical Processing (OLAP) dapat diterapkan untuk menangani masalah tersebut. Tujuan penelitian ini adalah merancang dan membangun data warehouse berbasis OLAP agar dapat digunakan oleh bagian rekam medis RSUA dalam pembuatan laporan. Data warehouse dibangun melalui tujuh tahap yaitu analisis, desain, proses ETL (Extraction, Transformation, and Loading), penerapan OLAP, uji coba, eksplorasi untuk hasil laporan dan analisis, serta evalusi. Perancangan data warehouse menggunakan Nine Step Methodology dengan pemodelan berupa fact constellation schema. Hasil implementasi data warehouse adalah aplikasi OLAP yang dapat digunakan untuk membantu kinerja bagian rekam medis RSUA dalam pembuatan laporan, baik berupa tabel pivot maupun grafik. Penilaian pengguna terhadap sistem data warehouse menunjukkan kategori baik dengan hasil penilaian sebesar 73.61 persen. Kata Kunci” Data Warehouse, Rawat Jalan, ETL, Nine Step Methodology, OLAPAbstract” Airlangga University Hospital is a health care facilities managed by the auspices of Airlangga University. Increasing number of patients in RSUA caused more outpatients' visits data must be managed by the medical record unit. The data was used to report making. The information in the reports generated through manual calculation or used function of Microsoft Excel became a problem of report making in addition to their reporting needs with diverse formats and multidimensional analysis. Data warehouse based on Online Analytical Processing (OLAP) could implemented to solved the problem. The goal of this research were to designing and implementing the data warehouse based on OLAP so it could be used by medical record unit to making report. Data warehouse was implemented in seven process: analysis, design, ETL (Extraction, Transformation, and Loading), implementing OLAP, trial, explore the report and analysis, and evaluation. Design of data warehouse were using Nine Step Methodology and fact constellation schema model.The outcome of this research was an OLAP application that can used to help the task of RSUA medical record unit to making report using pivot table or chart. User ratings against the data warehouse system showed good category with the results of 73.61 percent in assessment. Keywords” Data Warehouse, Outpatient, ETL, Nine Step Methodology, OLAP

Keywords

Collaboration network of the authors

18 authors · 46 co-authorship links · 16 across different organisations

Hover or tap a name to highlight its co-authors. Double-click to open the author's page.

Universitas Airlangga
Universitas Muhammadiyah Parepare
King Abdulaziz University
Institut Agama Islam Negeri Kendari

Different organisations
Same organisation
Affiliation unknown
Thicker line = more joint articles · bigger circle = more articles

Show as table

Co-author	Organisation	Joint articles
Indra Kharisma Raharjana	Universitas Airlangga	4
Abd. Rahman Saleh	Universitas Muhammadiyah Parepare	2
Usnul Letari	Universitas Muhammadiyah Parepare	2
Irma Irma	Universitas Muhammadiyah Parepare	2
Tajuddin Tajuddin	Universitas Muhammadiyah Parepare	2
Vierdy Sulfianto Rahmadani	Universitas Airlangga	1
Muhammad Zaky Erdiansyah	Universitas Airlangga	1
Irfan Nur Aulia	Universitas Airlangga	1
Ahmad Hoirul Basori	King Abdulaziz University	1
Andi Besse Firdausiah Mansur	King Abdulaziz University	1
Ersalina Trisnawati	Universitas Airlangga	1
Nouf Atiahallah Alghanmi	King Abdulaziz University	1
Akib Akib	Institut Agama Islam Negeri Kendari	1
Rosmiati Ramli	Universitas Muhammadiyah Parepare	1
Andi Fitriani Djollong	Universitas Muhammadiyah Parepare	1

Affiliations come from OpenAlex; journal OAI-PMH metadata carries none. Authors without an OpenAlex ID are matched by name, which can merge or split people.

Metadata source: OAI-PMH (metadata jurnal) https://e-journal.unair.ac.id/JISEBI/oai, first harvested 29 Okt 2026, last seen 29 Okt 2026.

Original metadata (oai_dc)

<oai_dc:dc xmlns="http://www.openarchives.org/OAI/2.0/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:oai_dc="http://www.openarchives.org/OAI/2.0/oai_dc/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.openarchives.org/OAI/2.0/oai_dc/  http://www.openarchives.org/OAI/2.0/oai_dc.xsd">
	<dc:title xml:lang="en-US">Rancang Bangun Data Warehouse Untuk Pembuatan Laporan dan Analisis pada Data Kunjungan Pasien Rawat Jalan Rumah Sakit Universitas Airlangga Berbasis Online Analytical Processing (OLAP)</dc:title>
	<dc:creator>Ardista, Nur</dc:creator>
	<dc:creator>Purbandini, Purbandini</dc:creator>
	<dc:creator>Taufik, Taufik</dc:creator>
	<dc:subject xml:lang="en-US">Data Warehouse</dc:subject>
	<dc:subject xml:lang="en-US">Rawat Jalan</dc:subject>
	<dc:subject xml:lang="en-US">ETL</dc:subject>
	<dc:subject xml:lang="en-US">Nine Step Methodology</dc:subject>
	<dc:subject xml:lang="en-US">OLAP</dc:subject>
	<dc:description xml:lang="en-US">Abstrak” Rumah Sakit Universitas Airlangga (RSUA) merupakan sarana pelayanan kesehatan yang dikelola di bawah naungan Universitas Airlangga. Seiring berjalannya proses bisnis, jumlah pasien RSUA yang semakin bertambah menyebabkan data kunjungan pasien rawat jalan yang harus dikelola oleh bagian rekam medis semakin banyak. Data tersebut dikelola untuk digunakan dalam pembuatan laporan. Informasi dalam laporan dihasilkan melalui perhitungan secara manual atau menggunakan formula Microsoft Excel menjadi kendala dalam pembuatan laporan selain adanya kebutuhan laporan dengan format beragam dan analisis multidimensional. Data warehouse berbasis Online Analytical Processing (OLAP) dapat diterapkan untuk menangani masalah tersebut. Tujuan penelitian ini adalah merancang dan membangun data warehouse berbasis OLAP agar dapat digunakan oleh bagian rekam medis RSUA dalam pembuatan laporan. Data warehouse dibangun melalui tujuh tahap yaitu analisis, desain, proses ETL (Extraction, Transformation, and Loading), penerapan OLAP, uji coba, eksplorasi untuk hasil laporan dan analisis, serta evalusi. Perancangan data warehouse menggunakan Nine Step Methodology dengan pemodelan berupa fact constellation schema. Hasil implementasi data warehouse adalah aplikasi OLAP yang dapat digunakan untuk membantu kinerja bagian rekam medis RSUA dalam pembuatan laporan, baik berupa tabel pivot maupun grafik. Penilaian pengguna terhadap sistem data warehouse menunjukkan kategori baik dengan hasil penilaian sebesar 73.61 persen. Kata Kunci” Data Warehouse, Rawat Jalan, ETL, Nine Step Methodology, OLAPAbstract” Airlangga University Hospital is a health care facilities managed by the auspices of Airlangga University. Increasing number of patients in RSUA caused more outpatients' visits data must be managed by the medical record unit. The data was used to report making. The information in the reports generated through manual calculation or used function of Microsoft Excel became a problem of report making in addition to their reporting needs with diverse formats and multidimensional analysis. Data warehouse based on Online Analytical Processing (OLAP) could implemented to solved the problem. The goal of this research were to designing and implementing the data warehouse based on OLAP so it could be used by medical record unit to making report. Data warehouse was implemented in seven process : analysis, design, ETL (Extraction, Transformation, and Loading), implementing OLAP, trial, explore the report and analysis, and evaluation. Design of data warehouse were using Nine Step Methodology and fact constellation schema model.The outcome of this research was an OLAP application that can used to help the task of RSUA medical record unit to making report using pivot table or chart. User ratings against the data warehouse system showed good category with the results of 73.61 percent in assessment. Keywords” Data Warehouse, Outpatient, ETL, Nine Step Methodology, OLAP</dc:description>
	<dc:publisher xml:lang="en-US">Universitas Airlangga</dc:publisher>
	<dc:date>2017-04-28</dc:date>
	<dc:type>info:eu-repo/semantics/article</dc:type>
	<dc:type>info:eu-repo/semantics/publishedVersion</dc:type>
	<dc:format>application/pdf</dc:format>
	<dc:identifier>https://e-journal.unair.ac.id/JISEBI/article/view/1981</dc:identifier>
	<dc:identifier>10.20473/jisebi.3.1.40-51</dc:identifier>
	<dc:source xml:lang="en-US">Journal of Information Systems Engineering and Business Intelligence; Vol. 3 No. 1 (2017): April; 40-51</dc:source>
	<dc:source>2443-2555</dc:source>
	<dc:source>2598-6333</dc:source>
	<dc:language>eng</dc:language>
	<dc:relation>https://e-journal.unair.ac.id/JISEBI/article/view/1981/2790</dc:relation>
	<dc:rights xml:lang="en-US">Copyright (c) 2017 Nur Ardista, Purbandini Purbandini, Taufik Taufik</dc:rights>
</oai_dc:dc>