ANALISIS TREN PEMESANAN DAN MUSIM TINGGI HOTEL SUNLAKE SUNTER MENGGUNAKAN DATA HISTORIS DENGAN POWER BI
Keywords:
Business Intelligence, Power BI, Tren, Musiman, Data MiningAbstract
Penelitian ini dilatarbelakangi oleh pentingnya pemanfaatan data historis dalam industri perhotelan untuk mendukung pengambilan keputusan yang lebih akurat dan berbasis data. Permasalahan yang sering terjadi adalah belum optimalnya pemanfaatan data pemesanan hotel dalam mengidentifikasi pola tren dan musiman, sehingga berdampak pada kurang efektifnya strategi operasional dan pemasaran. Tujuan penelitian ini adalah untuk menganalisis pola pemesanan hotel serta mengembangkan dashboard interaktif berbasis Business Intelligence (BI) menggunakan Power BI guna mendukung pengambilan keputusan strategis. Metode yang digunakan adalah pendekatan deskriptif kuantitatif dengan tahapan pengumpulan data, preprocessing data, analisis data, visualisasi data, dan interpretasi hasil. Data yang digunakan berupa data historis pemesanan hotel yang diolah menggunakan Power BI melalui Power Query Editor dan dashboard interaktif. Hasil penelitian menunjukkan bahwa terdapat pola tren dan musiman dalam pemesanan hotel, di mana terjadi peningkatan pada periode pertengahan dan akhir tahun serta penurunan pada awal tahun. Selain itu, ditemukan variasi pola pemesanan berdasarkan negara asal tamu dan jenis kamar. Dashboard yang dihasilkan mampu menyajikan informasi secara visual dan interaktif sehingga memudahkan pihak manajemen dalam memahami kondisi operasional hotel dan mendukung pengambilan keputusan berbasis data.
References
Al-Said, N. (2025). Integrating Business Intelligence and AI for Collaborative Leadership in Organizations. 213–230. https://doi.org/10.4018/979-8-3693-9581-3.ch011
Alauddin, M. (2025). Data Analysis Using Power BI. International Scientific Journal of Engineering and Management, 04(06), 1–9. https://doi.org/10.55041/isjem04149
Bhuiyan, M., Rahman, M. A., Hoque, A., Ashrafuzzaman, M., & Rahman, A. (2023). Advanced Analytics and Machine Learning for Revenue Optimization in the Hospitality Industry: A Comprehensive Review of Frameworks. American Journal of Scholarly Research and Innovation, 2(02), 52–74. https://doi.org/10.63125/8xbkma40
Buhalis, D., & Leung, R. (2018). Smart Hospitality—Interconnectivity and Interoperability Towards an Ecosystem. International Journal of Hospitality Management, 71, 41–50. https://doi.org/10.1016/j.ijhm.2017.11.011
Bustamante, A., Sebastia, L., & Onaindia, E. (2020). Bitour: A business intelligence platform for tourism analysis. ISPRS International Journal of Geo-Information, 9(11), 1–23. https://doi.org/10.3390/ijgi9110671
Chang, Y.-J., Chen, S.-L., Che, T.-S., & Chu, J.-Y. (2019). Analysis on Seasonality of Accommodation Demand for Tourist Hotels. International Journal of Trade Economics and Finance, 10(6), 139–143. https://doi.org/10.18178/ijtef.2019.10.6.651
Deyá-Tortella, B., Leoni, V., & Ramos, V. (2022). COVID-led consumption displacement: A longitudinal analysis of hotel booking patterns. International Journal of Hospitality Management, 107(January). https://doi.org/10.1016/j.ijhm.2022.103343
Dowlut, N., & Gobin-Rahimbux, B. (2023). Forecasting resort hotel tourism demand using deep learning techniques – A systematic literature review. Heliyon, 9(7), e18385. https://doi.org/10.1016/j.heliyon.2023.e18385
Guizzardi, A., Ballestra, L. V., & D’Innocenzo, E. (2022). Hotel dynamic pricing, stochastic demand and covid-19. Annals of Tourism Research, 97, 103495. https://doi.org/10.1016/j.annals.2022.103495
Korte, D. (2013). Business Intelligence in the Hospitality Industry. International Journal of Innovation Management and Technology. https://doi.org/10.7763/ijimt.2013.v4.435
Kumar, M., Iftekhar, M., Yadav, O. P., Shaw, P. J., & Sirohi, H. (2025). Leveraging Power BI for Real-Time Sales Dashboard Analytics and Decision-Making. International Journal of Research in Engineering and Innovation, 09(04), 179–187. https://doi.org/10.36037/ijrei.2025.9405
Miguel, Á., & Reina, R. (2021). Bernoulli Time Series Modelling with Application to Accommodation Tourism Demand †. January 2001.
Mogha, A., Abhinav, Tomar, A., Vinayak, V., & Shukla, S. (2025). Blinkit Sales Analysis Using Power BI: Uncovering Insights Through Data Visualization. International Journal of Research in Engineering and Innovation, 09(03), 102–109. https://doi.org/10.36037/ijrei.2025.9303
Nafiisa, B. L., Putri, Y. N. W., & Ayunin, Q. (2022). Dashboard Visualisasi Data UMK Sebagai Alat Pengambilan Keputusan Menggunakan Microsoft Power BI. Akuntansi Dan Manajemen, 17(2), 86–105. https://doi.org/10.30630/jam.v17i2.199
Pandipati, S. (2024). Improving Business Intelligence Reporting for Manufacturing Company: A VIKOR-Based Comparative Evaluation of BI Tools. Journal of Business Intelligence and Data Analytics, 1(2), 1–13. https://doi.org/10.55124/jbid.v1i2.243
Praba, R. D., Nisha, T. N., Yazhini, S., & S, K. M. (2024). Customer Satisfaction Analysis in Hotels Using Power BI. International Journal of Scientific Research in Computer Science Engineering and Information Technology, 10(2), 242–248. https://doi.org/10.32628/cseit2410216
Rachim, S., Maryati, S., Yudhatama, Y., & Rohendi, A. (2025). Transformasi Strategi Pemasaran: Integrasi Digital Marketing Dengan Analitik Prediktif. Jurnal Ekonomi Bisnis Dan Manajemen (Eko-Bisma), 4(2), 233–237. https://doi.org/10.58268/eb.v4i2.197
Ramasani, M. R. (2025). AI-Driven Business Intelligence and Financial Data Visualization: Transforming Modern Analytics. International Journal of Scientific Research in Computer Science Engineering and Information Technology, 11(1), 3461–3467. https://doi.org/10.32628/cseit251112369
Sainaghi, R., Mauri, A. G., Ivanov, S., & d’Angella, F. (2019). Mega Events and Seasonality: The Case of the Milan World Expo 2015. International Journal of Contemporary Hospitality Management, 31(1), 61–86. https://doi.org/10.1108/ijchm-10-2017-0644
Sanabia-Lizarraga, K. G., Carballo-Mendívil, B., Arellano-González, A., & Bueno-Solano, A. (2024). Business Intelligence for Agricultural Foreign Trade: Design and Application of Power BI Dashboard. Sustainability (Switzerland), 16(21). https://doi.org/10.3390/su16219576
Sea, S. B., & Dubikaltinien, A. (2021). applied sciences The Impact of Coastal Geodynamic Processes on the Distribution of Trace Metal Content in Sandy Beach Sediments ,.
Shaik, A., Khan, I. A., Dandu, M. M. K., Goel, P. P., Jain, P. A., & Shrivastav, E. A. (2024). The Role of Power BI in Transforming Business Decision-Making: A Case Study on Healthcare Reporting. Journal of Quantum Science and Technology, 1(3). https://doi.org/10.63345/jqst.v1i3.117
Tirupati, K. K., Joshi, A., Singh, D. S. P., Chhapola, A., Jain, S. K., & Gupta, A. (2024). Leveraging Power BI for Enhanced Data Visualization and Business Intelligence. Universal Research Reports, 10(2), 676–711. https://doi.org/10.36676/urr.v10.i2.1375
Wark, J. D. (2022). Power Up: Combining Behavior Monitoring Software With Business Intelligence Tools to Enhance Proactive Animal Welfare Reporting. Animals, 12(13), 1606. https://doi.org/10.3390/ani12131606
Al-Said, N. (2025). Integrating Business Intelligence and AI for Collaborative Leadership in Organizations. 213–230. https://doi.org/10.4018/979-8-3693-9581-3.ch011
Alauddin, M. (2025). Data Analysis Using Power BI. International Scientific Journal of Engineering and Management, 04(06), 1–9. https://doi.org/10.55041/isjem04149
Bhuiyan, M., Rahman, M. A., Hoque, A., Ashrafuzzaman, M., & Rahman, A. (2023). Advanced Analytics and Machine Learning for Revenue Optimization in the Hospitality Industry: A Comprehensive Review of Frameworks. American Journal of Scholarly Research and Innovation, 2(02), 52–74. https://doi.org/10.63125/8xbkma40
Buhalis, D., & Leung, R. (2018). Smart Hospitality—Interconnectivity and Interoperability Towards an Ecosystem. International Journal of Hospitality Management, 71, 41–50. https://doi.org/10.1016/j.ijhm.2017.11.011
Bustamante, A., Sebastia, L., & Onaindia, E. (2020). Bitour: A business intelligence platform for tourism analysis. ISPRS International Journal of Geo-Information, 9(11), 1–23. https://doi.org/10.3390/ijgi9110671
Chang, Y.-J., Chen, S.-L., Che, T.-S., & Chu, J.-Y. (2019). Analysis on Seasonality of Accommodation Demand for Tourist Hotels. International Journal of Trade Economics and Finance, 10(6), 139–143. https://doi.org/10.18178/ijtef.2019.10.6.651
Deyá-Tortella, B., Leoni, V., & Ramos, V. (2022). COVID-led consumption displacement: A longitudinal analysis of hotel booking patterns. International Journal of Hospitality Management, 107(January). https://doi.org/10.1016/j.ijhm.2022.103343
Dowlut, N., & Gobin-Rahimbux, B. (2023). Forecasting resort hotel tourism demand using deep learning techniques – A systematic literature review. Heliyon, 9(7), e18385. https://doi.org/10.1016/j.heliyon.2023.e18385
Guizzardi, A., Ballestra, L. V., & D’Innocenzo, E. (2022). Hotel dynamic pricing, stochastic demand and covid-19. Annals of Tourism Research, 97, 103495. https://doi.org/10.1016/j.annals.2022.103495
Korte, D. (2013). Business Intelligence in the Hospitality Industry. International Journal of Innovation Management and Technology. https://doi.org/10.7763/ijimt.2013.v4.435
Kumar, M., Iftekhar, M., Yadav, O. P., Shaw, P. J., & Sirohi, H. (2025). Leveraging Power BI for Real-Time Sales Dashboard Analytics and Decision-Making. International Journal of Research in Engineering and Innovation, 09(04), 179–187. https://doi.org/10.36037/ijrei.2025.9405
Miguel, Á., & Reina, R. (2021). Bernoulli Time Series Modelling with Application to Accommodation Tourism Demand †. January 2001.
Mogha, A., Abhinav, Tomar, A., Vinayak, V., & Shukla, S. (2025). Blinkit Sales Analysis Using Power BI: Uncovering Insights Through Data Visualization. International Journal of Research in Engineering and Innovation, 09(03), 102–109. https://doi.org/10.36037/ijrei.2025.9303
Nafiisa, B. L., Putri, Y. N. W., & Ayunin, Q. (2022). Dashboard Visualisasi Data UMK Sebagai Alat Pengambilan Keputusan Menggunakan Microsoft Power BI. Akuntansi Dan Manajemen, 17(2), 86–105. https://doi.org/10.30630/jam.v17i2.199
Pandipati, S. (2024). Improving Business Intelligence Reporting for Manufacturing Company: A VIKOR-Based Comparative Evaluation of BI Tools. Journal of Business Intelligence and Data Analytics, 1(2), 1–13. https://doi.org/10.55124/jbid.v1i2.243
Praba, R. D., Nisha, T. N., Yazhini, S., & S, K. M. (2024). Customer Satisfaction Analysis in Hotels Using Power BI. International Journal of Scientific Research in Computer Science Engineering and Information Technology, 10(2), 242–248. https://doi.org/10.32628/cseit2410216
Rachim, S., Maryati, S., Yudhatama, Y., & Rohendi, A. (2025). Transformasi Strategi Pemasaran: Integrasi Digital Marketing Dengan Analitik Prediktif. Jurnal Ekonomi Bisnis Dan Manajemen (Eko-Bisma), 4(2), 233–237. https://doi.org/10.58268/eb.v4i2.197
Ramasani, M. R. (2025). AI-Driven Business Intelligence and Financial Data Visualization: Transforming Modern Analytics. International Journal of Scientific Research in Computer Science Engineering and Information Technology, 11(1), 3461–3467. https://doi.org/10.32628/cseit251112369
Sainaghi, R., Mauri, A. G., Ivanov, S., & d’Angella, F. (2019). Mega Events and Seasonality: The Case of the Milan World Expo 2015. International Journal of Contemporary Hospitality Management, 31(1), 61–86. https://doi.org/10.1108/ijchm-10-2017-0644
Sanabia-Lizarraga, K. G., Carballo-Mendívil, B., Arellano-González, A., & Bueno-Solano, A. (2024). Business Intelligence for Agricultural Foreign Trade: Design and Application of Power BI Dashboard. Sustainability (Switzerland), 16(21). https://doi.org/10.3390/su16219576
Sea, S. B., & Dubikaltinien, A. (2021). applied sciences The Impact of Coastal Geodynamic Processes on the Distribution of Trace Metal Content in Sandy Beach Sediments ,.
Shaik, A., Khan, I. A., Dandu, M. M. K., Goel, P. P., Jain, P. A., & Shrivastav, E. A. (2024). The Role of Power BI in Transforming Business Decision-Making: A Case Study on Healthcare Reporting. Journal of Quantum Science and Technology, 1(3). https://doi.org/10.63345/jqst.v1i3.117
Tirupati, K. K., Joshi, A., Singh, D. S. P., Chhapola, A., Jain, S. K., & Gupta, A. (2024). Leveraging Power BI for Enhanced Data Visualization and Business Intelligence. Universal Research Reports, 10(2), 676–711. https://doi.org/10.36676/urr.v10.i2.1375
Wark, J. D. (2022). Power Up: Combining Behavior Monitoring Software With Business Intelligence Tools to Enhance Proactive Animal Welfare Reporting. Animals, 12(13), 1606. https://doi.org/10.3390/ani12131606
Downloads
Published
Issue
Section
Citation Check
License
Copyright (c) 2026 Faisal Bahtiar Riyadi, Rini Astuti, Khaerul Anam, Puji Pramudya Marta
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
