<![CDATA[PT Aska Daya Tama merupakan perusahaan penyewaan peralatan pengeboran Mud Motor di Indonesia. Pengelolaan data operasional perusahaan saat ini masih terhambat oleh tersebarnya data di berbagai Excel yang tidak terintegrasi, sehingga menyulitkan pemantauan aktivitas penyewaan dan analisis keuangan. Penelitian ini mengembangkan sistem Business Intelligence menggunakan metode Business Dimensional Lifecycle dari Kimball untuk mengintegrasikan data dan memvisualisasikan data operasional. Penggunaan metodologi Kimball dipilih karena pendekatannya yang praktis dan adaptif untuk perusahaan menengah. Implementasi sistem meliputi pengembangan data warehouse berbasis Google BigQuery, proses Extract, Transform, Load (ETL) menggunakan Talend Open Studio, serta dashboard visualisasi data melalui Looker Studio. Model data dirancang menggunakan skema fact constellation dengan tiga tabel fakta dan tujuh tabel dimensi untuk mendukung analisis historis data peralatan. Dashboard BI yang dikembangkan menghasilkan ringkasan kinerja operasional, historis penyewaan dan pemeliharaan peralatan. Pengujian usability dengan metode Dashboard Assessment Usability Model (DATUS) terhadap lima responden menghasilkan skor rata-rata 90,8 dari 100, dengan aspek efficiency mencatat hasil tertinggi (4,7 dari 5). Hasil pengujian membuktikan dashboard memiliki tingkat kepuasan yang tinggi dan memenuhi kebutuhan pengguna secara efektif melalui keberhasilan task-based testing. Implementasi dashboard operasional BI memberikan manfaat berupa pemantauan data operasional mendekati -real-time, mempercepat identifikasi masalah, dan memperoleh wawasan yang lebih mendalam. Abstract PT Aska Daya Tama is a Mud Motor drilling equipment rental company in Indonesia. Currently, the company’s operational data management is hindered by scattered data across various Excel files that are not integrated, making it difficult to monitor rental activities and conduct financial analysis. This study develops a Business Intelligence system using Kimball’s Business Dimensional Lifecycle method to integrate scattered data and visualize operational data. The Kimball methodology is chosen for its practical and adaptive approach suitable for medium-sized companies. The system implementation includes developing a data warehouse based on Google BigQuery, performing Extract, Transform, Load (ETL) processes using Talend Open Studio, and creating a data visualization dashboard with Looker Studio. The data model is designed using a fact constellation schema with three fact tables and seven dimension tables to support historical analysis of equipment data. The developed BI dashboard provides a summary of operational performance, rental history, and equipment maintenance. Usability testing using the Dashboard Assessment Usability Model (DATUS) on five respondents yielded an average score of 90.8 out of 100, with the highest score in the efficiency aspect (4.7 out of 5). The test results demonstrate that the dashboard has a high satisfaction level and effectively meets user needs through successful task-based testing. The implementation of the operational BI dashboard provides benefits such as near real-time operational data monitoring, faster issue identification, and deeper insight discovery.]]>
Copyrights © 2026
