Control Systems and Computers, N2-3, 2021, Article 7

Control Systems and Computers, 2021, Issue 2-3 (292-293), pp. 

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.

  1. Santoso, L.W. and Yulia. (2017), “Data Warehouse with Big Data Technology for Higher Education”, Procedia Computer Science, Vol. 124, pp. 93–99.
  2. Inmon, B. (2005), Building the Data Warehouse, 3rd Editio., John Wiley & Sons, Inc, Canada.
  3. Sagala, M. (2018), “Implementasi Data Warehouse Pada Perpustakaan Universitas Katolik Santo Thomas”, Jurnal Teknik Informatika Unika Santo Thomas, Vol. 3 No. 1.
  4. Rukmana, S.H. (2017), “Sistem Pendukung Keputusan Tender Proyek Menggunakan Metode Benefit Cost Ratio”, JST (Jurnal Sains Dan Teknologi), available at:https://doi.org/10.23887/jst-undiksha.v5i2.8570.
  5. Ambara, M.P., Sudarma, M. and Kumara, I.N.S. (2016), “Desain Sistem Semantic Data Warehouse dengan Metode Ontology dan Rule Based untuk Mengolah Data Akademik Universitas XYZ di Bali”, Majalah Ilmiah Teknologi Elektro, available at:https://doi.org/10.24843/mite.2016.v15i01p02.
  6. Vajpayee, S.K., Sarder, M., Vajpayee, S.K. and Sarder, M. (2019), “Benefit-Cost Ratio”, Fundamentals of Economics for Applied EngineeringSecond Edition, available at:https://doi.org/10.1201/9780429199455-10.
  7. Ponniah, P. (2010), Data Warehousing: A Comprehensive Guide for IT Professional, 2nd Editio., The McGraw-Hill Companies, New York.
  8. Pratama, I.P.A.E. and Pradipta, I.G.A. (2019), “Desain dan Implementasi Data warehouse Untuk Prediksi Penjualan Produk pada Toko Mekarsari”, Jurnal Teknologi Informasi Dan Terapan, available at:https://doi.org/10.25047/jtit.v5i1.81.
  9. Vaisman, A. and Zimányi, E. (2014), Data Warehouse Systems: Design and Implementation, Data Warehouse Systems: Design and Implementation, available at:https://doi.org/10.1007/978-3-642-54655-6.
  10. Ardista, N., Taufik, T. and Purbandini, P. (2017), “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, pp. 40–51.
  11. Rainardi, V. (2008), Building a Data Warehouse: With Examples in SQL Server, Building a Data Warehouse: With Examples in SQL Server, available at:https://doi.org/10.1007/978-1-4302-0528-9.

Received 15.04.2021