Design of Real-Time Project Monitoring Dashboard Using Kimball’s Data Warehouse Approach and Google Data Studio

Authors

  • Ni Kadek Wiliya Savitri Informatika, Fakultas Teknologi dan Informatika, Institut Bisnis dan Teknologi Indonesia, Bali, Indonesia
  • I Made Subrata Sandhiyasa Informatika, Fakultas Teknologi dan Informatika, Institut Bisnis dan Teknologi Indonesia, Bali, Indonesia
  • Yuri Prima Fittryani Informatika, Fakultas Teknologi dan Informatika, Institut Bisnis dan Teknologi Indonesia, Bali, Indonesia
  • I Gede Iwan Sudipa Informatika, Fakultas Teknologi dan Informatika, Institut Bisnis dan Teknologi Indonesia, Bali, Indonesia
  • Desak Made Dwi Utami Putra Informatika, Fakultas Teknologi dan Informatika, Institut Bisnis dan Teknologi Indonesia, Bali, Indonesia

DOI:

10.33395/sinkron.v9i3.14801

Keywords:

Data Visualization, Google Data Studio, Project Management, Interactive Dashboard, Data Warehouse

Abstract

The growth of the construction industry in Indonesia triggers an increasing need for an efficient project management system, especially in presenting project data accurately and in real-time. PT Dream Island Development (PT DID), a specialist MEP contractor company, faces challenges in presenting project reports to executives because the data is still presented in the form of Excel tabulations which require up to three days of processing time and are difficult to interpret quickly. This research aims to design an interactive dashboard-based project data visualization system using Google Data Studio (Looker Studio) to present project information intuitively and responsively. The method used includes a software engineering approach with five main stages: requirements analysis, data warehouse design, ETL process using Pentaho Data Integration, visualization using Google Data Studio, and testing using User Acceptance Test (UAT). Project data from 2022-2024 was modeled using a star schema and displayed in four main dashboards: project cost, project value, project progress, and details per project. The test results showed a high level of user satisfaction with a functionality score of 93.5%, reliability 91.33%, usability 96%, and efficiency 94.66%. These findings indicate that the developed system effectively supports PT DID's needs in project monitoring and data-based decision-making. The system also has the potential to be replicated in other construction companies as an efficient and scalable business intelligence solution.

This research contributes to the growing body of construction informatics by integrating Kimball’s nine-step methodology with modern data visualization tools to enhance project transparency and decision-making.

GS Cited Analysis

Downloads

Download data is not yet available.

References

Akbar, R., Silvana, M., Hersyah, M. H., & Jannah, M. (2020). Implementation of business intelligence for sales data management using interactive dashboard visualization in XYZ stores. 2020 International Conference on Information Technology Systems and Innovation (ICITSI), 242–249. https://doi.org/10.1109/ICITSI50517.2020.9264984

Allaymoun, M. H., Khaled, M., Saleh, F., & Merza, F. (2022). Data visualization and statistical graphics in big data analysis by Google Data Studio–Sales Case Study. 2022 IEEE Technology and Engineering Management Conference (TEMSCON EUROPE), 228–234. https://doi.org/10.1109/TEMSCONEUROPE54743.2022.9801964

Anagha, C. S., & Urolagin, S. (2021). Design and Development of Data Warehousing for Bookstore Using Pentaho BI Tools. Data Science and Computational Intelligence: Sixteenth International Conference on Information Processing, ICInPro 2021, Bengaluru, India, October 22–24, 2021, Proceedings 16, 195–210. https://doi.org/10.1007/978-3-030-91244-4_16

Fernández, M., Duran-Heras, A., Castilla-Alcala, G., & Ramos, S. (2022). On-Premise Free Data Visualization Tools Within the Design of a Business Intelligence (BI) Learning Activity. In Ensuring Sustainability: New Challenges for Organizational Engineering (pp. 331–338). Springer. https://doi.org/10.1007/978-3-030-95967-8_29

Intan, D., Saputra, S., Subarkah, P., Luthfi, E., & Muflikhatun, S. (2022). Design of a Sales Performance System for SMEs based on Business Intelligence and Data Warehouse. Indonesian Journal of Data and Science, 3(3), 107–114. https://doi.org/https://doi.org/10.56705/ijodas.v3i3.58

Madyatmadja, E. D., Ridho, M. N., Pratama, A. R., Fajri, M., & Novianto, L. (2022). Penerapan Visualisasi Data Terhadap Klasifikasi Tindak Kriminal Di Indonesia. Infotech: Journal of Technology Information, 8(1), 61–68. https://doi.org/10.37365/jti.v8i1.127

Mohd, F., Yahya, W. F. F., Jalil, M. A., Ismail, S., Noor, N. M. M., & Hasan, M. N. (2019). User acceptance testing (UAT) for the development and evaluation of an automated learning style detection system. AIP Conference Proceedings, 2138(1). https://doi.org/10.1063/1.5121098

Mucchetti, M. (2020). Google data studio. In BigQuery for Data Warehousing: Managed Data Analysis in the Google Cloud (pp. 401–416). Springer. https://doi.org/10.1007/978-1-4842-6186-6_18

Nurul Rival, D., Ikhlas Ramadhan, T., & Supriatman, A. (2024). Visualisasi Data Penerimaan Santri Baru Sebagai Media Informasi Menggunakan Looker Studio. Prosiding Seminar Ilmiah Sistem Informasi Dan Teknologi Informasi, 13(1), 151–157.

Oslan, Y., & Kristanto, D. H. (2019). Proses ETL (Extract Transformation Loading) Data Warehouse Untuk Peningkatan Kinerja Biodata Dalam Menyajikan Profil Mahasiwa Dari Dimensi Asal Sekolah Studi Kasus: Biodata Mahasiswa UKDW. Research Fair Unisri, 3(1).

Riani, N. K. I. C., Wiguna, K. A. G., & Ratnaningrum, L. P. R. A. (2024). Descriptive Analytics Sales Data Visualization at Kebab Made Using Google Data Studio. TECHNOVATE: Journal of Information Technology and Strategic Innovation Management, 1(3), 141–147. https://doi.org/https://doi.org/10.52432/technovate.1.3.2024.141-147

Sakti, I., Mareta, A., & Wasito, I. (2025). Fraud Detection in Mobile Phone Recharge Transactions Using K-Means and T-SNE Visualization. Sinkron: Jurnal Dan Penelitian Teknik Informatika, 9(1), 248–258. https://doi.org/10.33395/sinkron.v9i1.14330

Saputro, J., Saini, K., & Valentine, H. M. (2024). Data Visualization of Higher Education Participation Rates in Indonesia Provinces. Jurnal Galaksi, 1(2), 101–109. https://doi.org/https://doi.org/10.70103/galaksi.v1i2.20

Syafe’I, I., Wibowo, D. R., & Yordan, V. (2023). Penggunaan Aplikasi Sisense Untuk Pengolahan Data & Visualisasi Business Intelligence. INTECOMS: Journal of Information Technology and Computer Science, 6(1), 463–469. https://doi.org/10.31539/intecoms.v6i1.6086

Widjaja, F., Trisnawarman, D., & Arisandi, D. (2023). Development of goods import notification data mart (case study PT. Bollore Logistic). AIP Conference Proceedings, 2680(1). https://doi.org/10.1063/5.0126978

Downloads


Crossmark Updates

How to Cite

Savitri, N. K. W., Sandhiyasa, I. M. S. ., Fittryani, Y. P. ., Sudipa, I. G. I., & Putra, D. M. D. U. . (2025). Design of Real-Time Project Monitoring Dashboard Using Kimball’s Data Warehouse Approach and Google Data Studio. Sinkron : Jurnal Dan Penelitian Teknik Informatika, 9(3), 1050-1061. https://doi.org/10.33395/sinkron.v9i3.14801

Issue

Vol. 9 No. 3 (2025): Article Research July 2025

Section

Articles

License

Copyright (c) 2025 Ni Kadek Wiliya Savitri, I Made Subrata Sandhiyasa, Yuri Prima Fittryani, I Gede Iwan Sudipa, Desak Made Dwi Utami Putra

Creative Commons License

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

Crossref
Scopus
Google Scholar
Europe PMC

Most read articles by the same author(s)

1 2 > >>