Pengembangan Sistem Business Intelligence Dalam Monitoring Performa Perusahaan Multi Company

Authors

  • I Dewa Gde Deva Baskara Muku Teknologi Informasi, Fakultas Teknik, Universitas Udayana
  • I Putu Agung Bayupati Teknologi Informasi, Fakultas Teknik, Universitas Udayana
  • Anak Agung Ngurah Hary Susila Teknologi Informasi, Fakultas Teknik, Universitas Udayana

DOI:

https://doi.org/10.31598/sintechjournal.v6i2.1394

Keywords:

Information, Business Intelligence, ETL Process, Data Warehouse, Power BI

Abstract

Multi-company companies have challenges in managing subsidiary data into performance information of all subsidiaries in one window. This is due to the variation of data dimensions according to the business processes of each subsidiary. CV. XYZ is a holding company engaged in the food & beverage business. CV. XYZ currently manages three companies consisting of restaurants, catering, and tent and decoration rental. The problem faced by the company owner is the limited access to company performance in one information window. Each company has working papers in Excel format to record expenditure and income transactions. This article proposes the development of a website-based business intelligence system to overcome the problems of CV. XYZ. The purpose of developing a business intelligence system in this article is to provide access to the performance of each subsidiary in one website media. The business intelligence system is developed through the stages of data collection and analysis, data warehouse design, ETL process, and data visualization with Microsoft Power BI. The data warehouse design uses Kimball's nine-step method which produces a data warehouse with a star scheme. The developed Business Intelligence system was tested using the UAT method. The UAT test results show that the system development is following the company's needs as indicated by the UAT score of 92%

Downloads

Download data is not yet available.

References

A. Zikri, J. Adrian, A. Soniawan, R. Azim, R. Dinur, and R. Akbar, “Implementasi Business Intelligence untuk Menganalisis Data Persalinan Anak di Klinik Ani Padang dengan Menggunakan Aplikasi Tableau Public,” J. Online Inform., vol. 2, no. 1, p. 20, 2017, doi: 10.15575/join.v2i1.70.

P. N. Nwinyokpugi, “Business Intelligence Applications; sustaining Retail Businesses in Rivers State, Nigeria,” Int. J. Multidiscip. Res. Anal., vol. 04, no. 03, Mar. 2021, doi: 10.47191/ijmra/v4-i3-13.

S. Jun, “Business Intelligence Visualization Technology and Its Application in Enterprise Management,” in Proceedings of the 2020 2nd International Conference on Big Data Engineering and Technology, Jan. 2020, pp. 45–48, doi: 10.1145/3378904.3378909.

G. A. Udayana, I. M. Y. Mahendra, I. K. A. Sukawirasa, G. D. Dimastawan Saputra, and I. B. M. Mahendra, “Implementasi Data Warehouse Dan Penerapannya Pada PHI-Minimart Dengan Menggunakan Tools Pentaho dan Power BI,” JELIKU (Jurnal Elektron. Ilmu Komput. Udayana), vol. 10, no. 1, p. 163, 2021, doi: 10.24843/jlk.2021.v10.i01.p19.

W. Hu, H. Xie, M. Nakas, W. Shi, and M. Wang, “Power BI for Impacts Analysis on Cost of Living Caused by Industry Prevalence in Smart Cities,” in 2019 3rd International Conference on Smart Grid and Smart Cities (ICSGSC), Jun. 2019, pp. 134–139, doi: 10.1109/ICSGSC.2019.000-6.

A. Berhane, M. Nabeel, and C. Grose, “The Impact of Business Intelligence on Decision-Making in Public Organisations,” in 2020 IEEE International Conference on Industrial Engineering and Engineering Management (IEEM), Dec. 2020, pp. 435–439, doi: 10.1109/IEEM45057.2020.9309763.

I. Shakir Nasir, A. H. Mousa, and I. L. Hussein Alsammak, “SMUPI-BIS: a synthesis model for users’ perceived impact of business intelligence systems,” Indones. J. Electr. Eng. Comput. Sci., vol. 21, no. 3, p. 1856, Mar. 2021, doi: 10.11591/ijeecs.v21.i3.pp1856-1867.

B. I. Helgheim, R. Maia, J. C. Ferreira, and A. L. Martins, “Merging Data Diversity of Clinical Medical Records to Improve Effectiveness,” Int. J. Environ. Res. Public Health, vol. 16, no. 5, p. 769, Mar. 2019, doi: 10.3390/ijerph16050769.

D. J. Sari, S. K. Gusti, E. Haerani, and F. Syafria, “DESAIN ARSITEKTUR DATA WAREHOUSE PADA DATA TRANSAKSI PENJUALAN ROTTE BAKERY,” J. Tek. Inf. dan Komput., vol. 5, no. 2, p. 253, Dec. 2022, doi: 10.37600/tekinkom.v5i2.605.

A. Susanto, C. E. Nugraheni, and M. Widyarini, “Aplikasi Pengelolaan Persediaan Bahan Pada Usaha Kecil Menengah Pakaian Jadi,” J. Tek. Inform. dan Sist. Inf., vol. 7, no. 3, Dec. 2021, doi: 10.28932/jutisi.v7i3.4125

Downloads

Published

2023-08-31

Issue

Vol. 6 No. 2 (2023): SINTECH Journal Edition Agustus 2023

Section

Articles

License

Copyright (c) 2023 I Dewa Gde Deva Baskara Muku, I Putu Agung Bayupati, Anak Agung Ngurah Hary Susila

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

Copyright in each article belongs to the author.

  1. The authors admit that SINTECH Journal as a publisher who published the first time under   Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0) License.
  2. Authors can include writing separately, regulate distribution of non-ekskulif of manuscripts that have been published in this journal into another version (eg sent to respository institution author, publication into a book, etc.), by recognizing that the manuscripts have been published for the first time in SINTECH Journal