PERANCANGAN DATA WAREHOUSE dan DASHBOARD PT. JAYA TEKNIK
Keywords:
Data Warehouse, Dashboard, Kimball Methodology , Pentaho, ETLAbstract
A contractor is a company that contracts with another person or government or company to supply goods or complete certain services. PT. XYZ has a lot of project contract data and it has not yet been processed into information. To facilitate the employees of PT. XYZ in analyzing and evaluating past or future projects requires a Data Warehouse. The purpose of this research is to design and analyze the data warehouse needed to provide information regarding project contract data at PT. XYZ. The data warehouse design method uses 4 stages (Four-Step Methodology) proposed by Ralph Kimball in designing a data warehouse system. The final result to be achieved is the design of a data warehouse and dashboard is a visualization that will provide significant information about the project contract data at PT. XYZ which can be seen from different perspectives and facilitates related parties in making decisions.
References
S. Hansen, Manajemen kontrak konstruksi. Gramedia Pustaka Utama, 2015.
K. Sivaganesh, P. Srinivasu, and S. C. Satapathy, “Optimization of ETL Work Flow in Data Warehouse,” Int. J. Comput. Sci. Eng., vol. 4, no. 9, p. 1579, 2012.
Girsang, Ganda & Prakoso, Candrauji. "Data Warehouse Development for Customer WIFI Access Service at a Telecommunication Company". International Journal on Communications Antenna and Propagation (IRECAP). 7. 114. 10.15866/irecap.v7i2.11736, 2017.
I. H. William and H. D. Richard, “Using the Data Warehouse.” John Wiley & Son’s, 1994.
V. Poe, S. Brobst, and P. Klauer, Building a data warehouse for decision support. Prentice-Hall, Inc., 1997.
M. Bird, P. Lane, M. van de Wiel, M. M. Lumpkin, M. Townsend, and M. Thiyagarajan, “Oracle Database 2 Day+ Data Warehousing Guide, 11g Release 1 (11.1) B28314-01,” 2007.
R. Kimball and J. Caserta, The data warehouse ETL toolkit. John Wiley & Sons, 2004.
T. C. Ong et al., “Dynamic-ETL: a hybrid approach for health data extraction, transformation and loading,” BMC Med. Inform. Decis. Mak., vol. 17, no. 1, pp. 1–12, 2017.
A. P. Pereira, B. P. Cardoso, and R. M. S. Laureano, “Business intelligence: Performance and sustainability measures in an ETL process,” in 2018 13th Iberian Conference on Information Systems and Technologies (CISTI), 2018, pp. 1–7.
Y. Wibisono, “Modul Pengantar Pentaho Kettle,” Ilmu Komput. UPI, 2012.
R. Bouman, M. Casters, and J. Van Dongen, Pentaho Kettle solutions: building open source ETL solutions with Pentaho Data Integration. John Wiley & Sons, 2010.
Published
How to Cite
Issue
Section
Copyright (c) 2022 I Dewa Bagus Gde Khrisna Jayanta Nugraha, Agus Susanto, Abba Suganda Girsang
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
