Claim Missing Document
Check
Articles

Found 14 Documents
Search

Design of Real-Time Project Monitoring Dashboard Using Kimball’s Data Warehouse Approach and Google Data Studio Savitri, Ni Kadek Wiliya; Sandhiyasa, I Made Subrata; Fittryani, Yuri Prima; Sudipa, I Gede Iwan; Putra, Desak Made Dwi Utami
Sinkron : jurnal dan penelitian teknik informatika Vol. 9 No. 3 (2025): Article Research July 2025
Publisher : Politeknik Ganesha Medan

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.33395/sinkron.v9i3.14801

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.
Financial Data Warehousing at Village Credit Institution xyz Using a Star Schema Sandhiyasa, I Made Subrata; Nopianti, Ni Kadek Winda; Nugraha, Putu Gede Surya Cipta
Jurnal Galaksi Vol. 2 No. 1 (2025): Galaksi – May 2025
Publisher : Yayasan Sraddha Panca Widya Nusantara

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.70103/galaksi.v2i1.54

Abstract

The role of information technology is the main focus in financial management, especially in supporting the data analysis process for effective decision making.  Village Credit Institution xyz, as a financial institution owned by Pekraman Villages in Bali, faces obstacles in presenting financial data that is still in the form of tables. The presentation is not effective in providing a clear and adequate picture to support management decision-making. Makes it difficult to identify customers with bad or current credit. This research aims to build a financial data visualization system at  Village Credit Institution  xyz using Looker Studio, with a data warehouse design implemented using Kimball's Nine Steps method. The ETL process is carried out using Pentaho Data Integration (PDI) to compile data from various sources. The final result of this research is data visualization in the form of 9 main menus. This system allows the presentation of data in the form of interactive graphs, thus facilitating data analysis, accelerating the decision-making process, and increasing the efficiency of financial data management in  Village Credit Institution. System testing was conducted using the User Acceptance Testing (UAT) method with a result of 92.48% or strongly agree, indicating that the developed system has met the needs of users.
PENDAMPINGAN DAN PELATIHAN SISTEM INFORMASI BANK SAMPAH DI TPS 3R BAWANA LESTARI DESA PANGKUNGKARUNG Kartini, Ketut Sepdyana; Saraswati, Ni Wayan Sumartini; Sandhiyasa, I Made Subrata; Putra, I Nyoman Tri Anindia; Pramest, Ni Luh Gede Sintia
Jurnal Widya Laksmi: Jurnal Pengabdian Kepada Masyarakat Vol. 3 No. 2 (2023): Jurnal WIDYA LAKSMI (Jurnal Pengabdian Kepada Masyarakat)
Publisher : Yayasan Lavandaia Dharma Bali

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.59458/jwl.v3i2.62

Abstract

Bank Sampah merupakan suatu lembaga yang digunakan untuk mengelola kegiatan pengumpulan, pemilahan dan pengolahan sampah dari masyarakat setempat dengan tujuan mendaur ulang dan dijual atau diolah menjadi produk yang memiliki nilai ekonomi. Penulisan ini dilakukan di Bank Sampah Bawana Lestari Desa Pangkungkarung, Kecamatan Kerambitan, Kabupaten Tabanan. Pengolahan data di Bank Sampah masih dilakukan secara manual dengan menggunakan buku. Oleh karena itu, penulis membuat sebuah sistem informasi berbasis web yang dapat membantu proses pencatatan di Bank Sampah. Pengembangan sistem menggunakan metode waterfall Sedangkan pengumpulan data penulis menggunakan metode wawancara, observasi, kepustakaan, dokumen dan arsip. Pengujian sistem menggunakan black box testing dan user experience quisioner (UEQ). Hasil dari penulisan ini adalah sebuah sistem berbasis web yang dapat membantu petugas dalam melakukan pencatatan dan nasabah dapat melakukan pengecekan saldo dan penjualan sampah secara mandiri.
Sentiment Analysis on Rupiah Depreciation Against USD Using XGBoost Indrayuni, Ni Komang Purnama; Desmayani, Ni Made Mila Rosa; Pramawati, I Dewa Ayu Agung Tantri; Sandhiyasa, I Made Subrata; Widiartha, Komang Kurniawan
Journal of Applied Informatics and Computing Vol. 9 No. 5 (2025): October 2025
Publisher : Politeknik Negeri Batam

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.30871/jaic.v9i5.10751

Abstract

The depreciation of the rupiah against the United States dollar (USD) affects purchasing power and economic stability. Public responses are widely expressed through social media such as X and Instagram. This study aims to analyze public sentiment using the Extreme Gradient Boosting (XGBoost) algorithm. Data were collected through crawling and scraping, consisting of 13,443 X comments and 11,287 Instagram comments between January 2024 until April 2025. Preprocessing included emoji conversion, cleaning, case folding, normalization, tokenization, stopwords removal, and Stemming. Sentiment labeling was performed using the InSet Lexicon, TF-IDF weighting, and data splitting   into 70:30, 80:20, and 90:10. The XGBoost model was trained with parameters: 100 estimators, learning rate 0.1, max depth 6, and subsample 0.8. Results showed accuracies of 74–76% on X data and stable 77% on Instagram. Model evaluation using precision, recall, and F1-score confirmed consistency: precision 0.76% – 0.84%, recall 0.86%–0.88%, and F1-score 0.82%–0.86%, reflecting a balance between accuracy and robustness in detecting sentiments. Sentiment distribution revealed that X is dominated by negative opinions (38%), while Instagram is more positive (41%). These findings confirm the effectiveness of XGBoost in sentiment classification and provide valuable insights for policymakers to design adaptive communication and monetary strategies based on digital public opinion.