Perancangan Dashboard Monitoring Untuk Monthly Report Pemesanan Hotel dengan Microsoft Power BI
Abstract
PT. X, an online-based tour & travel company, faces difficulties in effectively monitoring hotel booking data, which impacts slow and inaccurate decision-making. This study aims to design a monitoring dashboard to simplify the tracking of booking and transaction data, as well as to support faster and more accurate decision-making. The dashboard development method used is the prototyping method, which allows user feedback during the development process. The ETL process is carried out with SQL Server Management Studio, while data visualization is done using Microsoft Power BI. The testing method is performed through User Acceptance Testing (UAT) to evaluate user satisfaction. System evaluation shows that this dashboard effectively improves operational efficiency, speeds up responses to market trends, and facilitates management in making faster and more accurate decisions.
Keywords: Dashboard; Monitoring; Prototyping Method; ETL; Microsoft Power BI.
Abstrak
PT. X, perusahaan tour & travel berbasis online, menghadapi kesulitan dalam memantau data pemesanan hotel secara efektif, yang berdampak pada pengambilan keputusan yang lambat dan tidak akurat. Penelitian ini bertujuan merancang dashboard monitoring untuk mempermudah pemantauan data pemesanan dan transaksi, serta mendukung pengambilan keputusan yang lebih cepat dan tepat. Metode pengembangan dashboard yang digunakan adalah metode prototyping, memungkinkan umpan balik pengguna selama proses pengembangan. Proses ETL dilakukan dengan SQL Server Management Studio, sementara visualisasi data menggunakan Microsoft Power BI. Metode pengujian dilakukan melalui pengujian User Acceptance Testing (UAT) untuk mengevaluasi kepuasan pengguna. Evaluasi sistem menunjukkan bahwa dashboard ini efektif meningkatkan efisiensi operasional, mempercepat respons terhadap tren pasar, dan mempermudah manajemen dalam pengambilan keputusan yang lebih cepat dan akurat.
Keywords
References
I. Khatri, “Information Technology in Tourism & Hospitality Industry: A Review of Ten Years’ Publications,” vol. 9, pp. 74–87, Apr. 2019, doi: 10.3126/jthe.v9i0.23682.
M. Mariani and R. Baggio, “Big data and analytics in hospitality and tourism: a systematic literature review,” International Journal of Contemporary Hospitality Management, vol. 34, no. 1, pp. 231–278, Jan. 2022, doi: 10.1108/IJCHM-03-2021-0301.
N. M. . Scarborough and J. R. . Cornwall, Essentials of entrepreneurship and small business management. Pearson, 2016.
G. Giotis and E. Papadionysiou, The Role of Managerial and Technological Innovations in the Tourism Industry: A Review of the Empirical Literature. USF M3 Publishing, LLC, 2022. doi: 10.5038/9781732127593.
S. Hjelle, P. Mikalef, N. Altwaijry, and V. Parida, “Organizational decision making and analytics: An experimental study on dashboard visualizations,” Information & Management, vol. 61, no. 6, p. 104011, 2024, doi: https://doi.org/10.1016/j.im.2024.104011.
W. Ramadhan, A. Rumanti, and N. Supratman, “Dashboard Design For Dimsum 20 Sales Report Using Waterfall Model,” e-Proceeding of Engineering Vol.9, No.3 Juni 2022 | Page 1348, no. ISSN : 2355-9365, Jun. 2022.
A. A. Michelle Grace Suwandi, “Perancangan Dashboard Monitoring Untuk Penjualan Mainan,” Jurnal Ilmiah Binary STMIK Bina Nusantara Jaya Lubuklinggau, vol. 3, no. 1, pp. 22–29, Apr. 2021, doi: 10.52303/jb.v3i1.34.
G. Kiamidi, Wasino, and T. Sutrisno, “Perancangan Dashboard Untuk Pemantauan Terhadap Kebutuhan Pembelian Material Pada Pt Xyz Menggunakan Metode OLAP,” Jurnal Ilmu Komputer dan Sistem Informasi, vol. 11, no. 1, Jun. 2023, doi: 10.24912/jiksi.v11i1.24143.
U. Apriani, D. Trisnawarman, and Z. Rusdi, “dashboard penjualan dan pembelian PT Petra Sejahtera Abadi,” Jurnal Ilmu Komputer dan Sistem Informasi, vol. 7, no. 2, pp. 216–222, 2019.
H. A. Christianto, D. Trisnawarman, and T. Sutrisno, “Pembuatan Dashboard Penjualan Dan Pembelian Hevindo Sport,” Jurnal Ilmu Komputer dan Sistem Informasi, vol. 8, no. 1, p. 69, Jan. 2020, doi: 10.24912/jiksi.v8i1.11471.
F. Kevin, “Perancangan Dashboard Laporan Penjualan Pada Toko HBI,” Jurnal Ilmu Komputer dan Sistem Informasi, vol. 11, no. 1, Jun. 2023, doi: 10.24912/jiksi.v11i1.24147.
R. S. Pressman, “Software Engineering: A Practitioner’s Approach,” 2010. [Online]. Available: www.mhhe.com/pressman.
M. Syaputra, S. Gusti, S. Sanjaya, and F. Syafria, “Data Warehouse Design For Sales Transactions on CV. Sumber Tirta Anugerah,” Jurnal CoreIT: Jurnal Hasil Penelitian Ilmu Komputer dan Teknologi Informasi, vol. 8, p. 88, Dec. 2022, doi: 10.24014/coreit.v8i2.19800.
S. Anshari and S. Retno, “Penerapan Metode Nine-Step Kimball Dalam Pengolahan Data History Menggunakan Data Warehouse dan Business Intelligence,” Jurnal Ilmu Komputer, vol. 16, pp. 69–79, Apr. 2023, doi: 10.24843/JIK.2023.v16.i01.p07.
I. Suta, I. Mahendra, and Y. P. Sudarmojo, “Design General Hospital Data Warehouse Base on Nine Step Methodology,” IJEET (International J. Eng. Emerg. Technol, vol. 4, no. 1, pp. 15–19, 2019.
W. S. Fana, R. Sovia, R. Permana, and M. A. Islam, “Data Warehouse Design With ETL Method (Extract, Transform, And Load) for Company Information Centre,” International Journal of Artificial Intelligence Research, vol. 5, no. 2, Jun. 2021, doi: 10.29099/ijair.v5i2.215.
R. Kimball and J. Caserta, “The Data Warehouse ETL Toolkit,” 2004.
M. Saputra and Tony, “Rancang Bangun Dashboard Penjualan pada PT. XYZ dengan Microsoft PowerBI,” Jurnal Ilmu Komputer dan Sistem Informasi, vol. 11, no. 2, Aug. 2023, doi: 10.24912/jiksi.v11i2.26028.
How To Cite This :
Refbacks
- There are currently no refbacks.
