Claim Missing Document
Check
Articles

Found 18 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.
Analysis Of Optimising Cooperative Performance Through Digital-Based Reporting Management System Suandana, Ni Putu Widantari; Sandhiyasa, I Made Subrata; Aditama, Putu Wirayudi; Adnyana, I Nyoman Widhi
Jurnal Scientia Vol. 13 No. 03 (2024): Education and Sosial science, June - August 2024
Publisher : Sean Institute

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.58471/scientia.v13i03.2521

Abstract

This research aims to examine the optimization of Cooperative performance through a digital-based reporting management system. The case study method is used to analyze user needs and design relevant system features. The needs analysis is useful in identifying constraints and needs in the current reporting system. Based on this analysis, features such as interactive dashboards, real-time reporting, digital financial management, and member management were designed and tested. The results show an increase in operational efficiency, transparency, and accountability of the cooperative. The implementation of this system successfully met user needs and improved the cooperative's performance
Optimising Double Exponential Smoothing for Sales Forecasting Using The Golden Section Method Pradnyani, Kadek Dian; Sandhiyasa, I Made Subrata; Gunawan, I Made Agus Oka
Jurnal Galaksi Vol. 1 No. 2 (2024): Galaksi - August 2024
Publisher : Yayasan Sraddha Panca Widya Nusantara

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

Abstract

To achieve maximum profits and a satisfying impression on consumers, companies are required to have the right strategy in selling their products. In determining the right strategy, it requires the availability of accurate information that can be analyzed to determine a sales strategy so that it can increase the number of sales and generate large profits, namely by forecasting. In the Double Exponential Smoothing method, the problem that arises is determining the optimum α parameter value to provide the smallest size of forecasting error, which is sought using the trial and error method, so it requires quite a lot of time. To overcome this problem, a non-linear optimization algorithm using the Golden Section algorithm is used. The Golden Section algorithm is an algorithm that uses the principle of reducing the boundary area α which might produce a minimum objective function value. It is hoped that this forecasting design will be able to provide information that will help the company take decisions or steps in providing stock of goods for sale so that there will be no overstock in the warehouse and can increase Dewaayu Shop's profits.  based on the test results, the value of  MAPE value is obtained of 21.59579369% and RMSE value of 2.42465034.
Pendampingan Instagram Marketing dalam Membangun Ketrampilan Pemasaran Digital dan Brand Awareness Produk UMKM Suandana, Ni Putu Widantari; Aditama, Putu Wirayudi; Sandhiyasa, I Made Subrata; Prabhawa , I Kadek Angga Surya; Atmaja, Ketut Jaya; Sarasvananda , Ida Bagus Gde; Anandita, Ida Bagus Gede
Jurnal KOMET Vol 1 No 1 (2024): Jurnal Komet: Kolaborasi Masyarakat Berbasis Teknologi : Volume 1 Nomor 1, Juni 2
Publisher : Yayasan Sinergi Widya Nusantara

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.70103/komet.v1i1.11

Abstract

UMKM di Desa Geluntung, Bali memiliki produk unggulan contohnya produk keripik, meskipun populer secara lokal, menghadapi tantangan dalam memanfaatkan Instagram untuk memperluas jangkauan pasar dan meningkatkan brand awareness. Keterbatasan pengetahuan digital, manajemen konten yang kurang efektif, pemanfaatan fitur Instagram yang tidak optimal, dan pengukuran performa yang lemah adalah beberapa tantangan utama yang dihadapi. Untuk mengatasi masalah ini, kegiatan pelatihan dan pendampingan dalam pemasaran digital melalui Instagram dilakukan. Metode pelaksanaan meliputi pengaturan profil bisnis, pembuatan konten yang menarik, pemanfaatan fitur-fitur Instagram seperti Stories dan Highlights, serta analisis data melalui Instagram Insights. Hasil kegiatan menunjukkan peningkatan pemahaman dan keterampilan digital, serta peningkatan engagement dan brand awareness produk UMKM.
Pengembangan Virtual Tour 360 Pada Objek Wisata Sangeh Satya, I Wayan Wira; Sandhiyasa, I Made Subrata; Aristana, Made Dona Wahyu; Udayana, I Putu Agus Eka Darma; Desnanjaya, I Gusti Made Ngurah
Jurnal KOMET Vol 1 No 2 (2024): Jurnal Komet: Kolaborasi Masyarakat Berbasis Teknologi : Volume 1 Nomor 2, Oktobe
Publisher : Yayasan Sinergi Widya Nusantara

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.70103/komet.v1i2.13

Abstract

Objek Wisata Sangeh, terkenal dengan hutan kera alaminya dan keberadaan beberapa pura penting, menawarkan pengalaman unik bagi pengunjung. Namun, terdapat kendala karena pura di kawasan ini tidak boleh dimasuki oleh wisatawan, serta keterbatasan informasi yang tersedia yang dapat mengurangi pengalaman wisata. Oleh karena itu, kegiatan pengabdian ini bertujuan untuk mengembangkan Virtual Tour 360° untuk Objek Wisata Sangeh sebagai solusi atas masalah tersebut. Hasil dari kegiatan ini adalah pembuatan sebuah website virtual tour untuk Objek Wisata Sangeh, yang diharapkan dapat memberikan edukasi yang akurat tentang keindahan dan keberagaman budaya Sangeh, serta mempromosikan destinasi wisata ini kepada wisatawan lokal maupun mancanegara. Pengujian System Usability Scale (SUS) menunjukkan bahwa website virtual tour ini mendapatkan skor tinggi dalam penerimaan pengguna dengan nilai akhir 78.375. Skor ini berada dalam kategori "Acceptable" dan masuk dalam kelas B. Kategori dan kelas tersebut biasanya menunjukkan bahwa pengguna menemukan sistem tersebut cukup memuaskan dan dapat digunakan dengan baik dalam konteks yang diujikan.Manfaat dari kegiatan ini termasuk sebagai media edukasi, pelestarian budaya, dan pengalaman virtual yang interaktif bagi pengunjung.