Melola Discovery

← Melola Discovery

Open access Jurnal SINTA 2

Pengembangan Data Warehouse Menggunakan Pendekatan Data-Driven untuk Membantu Pengelolaan SDM

IJCCS (Indonesian Journal of Computing and Cybernetics Systems) · Vol. 10 No. 1 (2016) · pp. 1–10

DOI
10.22146/ijccs.11184
ISSN
2460-7258, 1978-1520
Published
2016-01-31
Publisher
IndoCEISS in colaboration with Universitas Gadjah Mada, Indonesia.
Language
eng
License
creativecommons.org/licenses/by-sa/4.0

Abstract

The basis of bureaucratic reform is the reform of human resources management. One supporting factor is the development of an employee database. To support the management of human resources required including data warehouse and business intelligent tools. The data warehouse is an integrated concept of reliable data storage to provide support to all the needs of the data analysis. In this study developed a data warehouse using the data-driven approach to the source data comes from SIMPEG, SAPK and electronic presence. Data warehouses are designed using the nine steps methodology and unified modeling language (UML) notation. Extract transform load (ETL) is done by using Pentaho Data Integration by applying transformation maps. Furthermore, to help human resource management, the system is built to perform online analytical processing (OLAP) to facilitate web-based information. In this study generated BI application development framework with Model-View-Controller (MVC) architecture and OLAP operations are built using the dynamic query generation, PivotTable, and HighChart to present information about PNS, CPNS, Retirement, Kenpa and Presence

Keywords

Collaboration network of the authors

25 authors · 39 co-authorship links · 5 across different organisations

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

  • Universitas Gadjah Mada
  • Politeknik Negeri Ketapang
  • National Central University
  • Affiliation unknown
  • Different organisations
  • Same organisation
  • Affiliation unknown
  • Thicker line = more joint articles · bigger circle = more articles
Show as table
Co-authorOrganisationJoint articles
Anny Kartika SariUniversitas Gadjah Mada3
Sri T. HartatiUniversitas Gadjah Mada2
Fajar Ibnu TufeilAffiliation unknown1
Annisa MaulianiUniversitas Gadjah Mada1
Retantyo WardoyoUniversitas Gadjah Mada1
Ria AstriratmaUniversitas Gadjah Mada1
Agus HarjokoUniversitas Gadjah Mada1
Nelson RumuiPoliteknik Negeri Ketapang1
Maulida Ayu FitrianiUniversitas Gadjah Mada1
Damar RiyadiUniversitas Gadjah Mada1
Ilham UnggaraUniversitas Gadjah Mada1
Yessi YunitasariUniversitas Gadjah Mada1
Dias Aziz PramuditaUniversitas Gadjah Mada1
Abidah ElcholiqiUniversitas Gadjah Mada1
Wahyu SrimulyaniUniversitas Gadjah Mada1
Hans Satria KusumaUniversitas Gadjah Mada1
Yunita SariUniversitas Gadjah Mada1
Rayhan Naufal RamadhanUniversitas Gadjah Mada1
Faisal RamadhanUniversitas Gadjah Mada1
Muhammad Bintang BahyUniversitas Gadjah Mada1
Muhammad Fawwaz MaydaUniversitas Gadjah Mada1
Aditya PermanaUniversitas Gadjah Mada1
Timothy K. ShihNational Central University1

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://journal.ugm.ac.id/ijccs/oai, first harvested 26 Okt 2026, last seen 26 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">Pengembangan Data Warehouse Menggunakan Pendekatan Data-Driven untuk Membantu Pengelolaan SDM</dc:title>
	<dc:creator>Mujiono, Mujiono</dc:creator>
	<dc:creator>Musdholifah, Aina</dc:creator>
	<dc:subject xml:lang="en-US"></dc:subject>
	<dc:subject xml:lang="en-US">data warehouse, human resources management, Model-View-Controller (MVC), dynamic query</dc:subject>
	<dc:description xml:lang="en-US"> The basis of bureaucratic reform is the reform of human resources management. One supporting factor is the development of an employee database. To support the management of human resources required including data warehouse and business intelligent tools. The data warehouse is an integrated concept of reliable data storage to provide support to all the needs of the data analysis. In this study developed a data warehouse using the data-driven approach to the source data comes from SIMPEG, SAPK and electronic presence. Data warehouses are designed using the nine steps methodology and unified modeling language (UML) notation. Extract transform load (ETL) is done by using Pentaho Data Integration by applying transformation maps. Furthermore, to help human resource management, the system is built to perform online analytical processing (OLAP) to facilitate web-based information. In this study generated BI application development framework with Model-View-Controller (MVC) architecture and OLAP operations are built using the dynamic query generation, PivotTable, and HighChart to present information about PNS, CPNS, Retirement, Kenpa and Presence</dc:description>
	<dc:publisher xml:lang="en-US">IndoCEISS in colaboration with Universitas Gadjah Mada, Indonesia.</dc:publisher>
	<dc:contributor xml:lang="en-US">IndoCEISS</dc:contributor>
	<dc:date>2016-01-31</dc:date>
	<dc:type>info:eu-repo/semantics/article</dc:type>
	<dc:type>info:eu-repo/semantics/publishedVersion</dc:type>
	<dc:type xml:lang="en-US"></dc:type>
	<dc:format>application/pdf</dc:format>
	<dc:identifier>https://journal.ugm.ac.id/ijccs/article/view/11184</dc:identifier>
	<dc:identifier>10.22146/ijccs.11184</dc:identifier>
	<dc:source xml:lang="en-US">IJCCS (Indonesian Journal of Computing and Cybernetics Systems); Vol 10, No 1 (2016): January; 1-10</dc:source>
	<dc:source>2460-7258</dc:source>
	<dc:source>1978-1520</dc:source>
	<dc:language>eng</dc:language>
	<dc:relation>https://journal.ugm.ac.id/ijccs/article/view/11184/8424</dc:relation>
	<dc:rights xml:lang="en-US">Copyright (c) 2016 IJCCS - Indonesian Journal of Computing and Cybernetics Systems</dc:rights>
	<dc:rights xml:lang="en-US">http://creativecommons.org/licenses/by-sa/4.0</dc:rights>
</oai_dc:dc>