Control Systems and Computers, N2-3, 2021, Article 8
https://doi.org/10.15407/csc.2021.02.084
Control Systems and Computers, 2021, Issue 2-3 (292-293), pp. 84-91.
UDC 004.06:336.6
MUHAMMAD QUSYAIRI, Postgraduate Student, Management
of Information Systems and Computers, Faculty of Engineering, Udayana University,
Denpasar, Bali, 80361, Indonesia, erictk.rrtrq@gmail.com
MADE SUDARMA, Lecturer, Postgraduate Program, Master of Electrical Engineering,
Faculty of Engineering, Udayana University, Denpasar, Bali, 80361, Indonesia
AGUS DHARMA, Lecturer, Postgraduate Program, Master of Electrical Engineering,
Faculty of Engineering, Udayana University, Denpasar, Bali, 80361, Indonesia
DESIGNING DATA WAREHOUSE MODEL USING BENEFIT COST RATIO ANALYSIS METHOD
The data warehouse has the function to make the spread company’s data to be integrated and concise, thereby it helps executives in analyzing the existing data to obtain a quick and accurate strategic decision. This research has the objective to design a data warehouse within the scope of application of the benefit-cost ratio. As a solution to the feasibility of the company’s business, the unity of different data enables it to be combined with the results of the company’s in-depth analysis. In designing the model, this research succeeded in designing a data warehouse with the application of benefit-cost-ratio method which is used to carry out an in-depth analysis of the financial sector by providing the feasibility and percentage results of the current business. In summary, the source data that is processed into the process of extracting, transforming, and loading which built by the star schema will affect the quality of generated data for the process of queries. In addition, the results of the data warehouse used for the decision-making process and feasible business strategy.
Download full text! (In English)
Keywords: data warehouse, ETL, BCR, OLAP, decision making.
- Santoso L. W., Yulia, 2017. “Data Warehouse with Big Data Technology for Higher Education”, Procedia Computer Science, 124, pp. 93-99. DOI: https://doi.org/10.1016/j.procs.2017.12.134.
https://doi.org/10.1016/j.procs.2017.12.134 - Inmon W. H., 2002. Building the Data Warehouse, 3rd ed., John Wiley & Sons, Inc., Canada.
- Sagala M., 2018. “Implementasi Data Warehouse PadaPerpustakaanUniversitasKatolik Santo Thomas”, JurnalTeknikInformatikaUnika Santo Thomas, 3 (1), pp. 33-39.
- Rukmana S. H., 2017. “SistemPendukungKeputusan Tender ProyekMenggunakanMetode Benefit Cost Ratio”, JST (JurnalSains&Teknologi), 5 (2). DOI: https://doi.org/10.23887/jst-undiksha.v5i2.8570.
https://doi.org/10.23887/jst-undiksha.v5i2.8570 - Ambara M. P., Sudarma M., Kumara I. N. S., 2016. “DesainSistem Semantic Data Warehouse denganMetode Ontology dan Rule Based untukMengolah Data AkademikUniversitas XYZ di Bali”, MajalahIlmiahTeknologiElektro, 15 (1). DOI: https://doi.org/10.24843/mite.2016.v15i01p02.
https://doi.org/10.24843/MITE.2016.v15i01p02 - Vajpayee S. K., Sarder M., Vajpayee S. K., Sarder M., 2019. “Benefit-Cost Ratio”, Fundamentals of Economics for Applied EngineeringSecond Edition, CRC Press. DOI: https://doi.org/10.1201/9780429199455-10.
https://doi.org/10.1201/9780429199455-10 - Ponniah P., 2010. Data Warehousing : A Comprehensive Guide for IT Professional, 2nd ed., The McGraw-Hill Companies, New York.
- Pratama I. P. A. E., Pradipta I. G. A., 2019. “DesaindanImplementasi Data warehouse UntukPrediksiPenjualanProdukpadaTokoMekarsari”, JurnalTeknologiInformasi Dan Terapan, 5 (1), pp. 65-71. DOI: https://doi.org/10.25047/jtit.v5i1.81.
https://doi.org/10.25047/jtit.v5i1.81 - Vaisman A., Zimányi E., 2014. Data Warehouse Systems : Design and Implementation. DOI: https://doi.org/10.1007/978-3-642-54655-6.
https://doi.org/10.1007/978-3-642-54655-6 - Ardista N., Taufik T., Purbandini P., 2017. “RancangBangun Data Warehouse UntukPembuatanLaporandanAnalisispada Data KunjunganPasienRawatJalanRumahSakitUniversitasAirlanggaBerbasis Online Analytical Processing (OLAP)”, Journal of Information Systems Engineering and Business Intelligence, 3 (1), pp. 40-51.DOI: http://dx.doi.org/10.20473/jisebi.3.1.40-51.
https://doi.org/10.20473/jisebi.3.1.40-51 - Rainardi V., 2008. Building a Data Warehouse : With Examples in SQL Server. DOI:https://doi.org/10.1007/978-1-4302-0528-9.
https://doi.org/10.1007/978-1-4302-0528-9
Received 15.04.2021
