Analysis and Identification of International Tourist Visits to Indonesia Based on Data Warehouse Implementation

Authors

  • Indira Septianita Larasati Hasanuddin University, Makassar
  • Valian Yoga Pudya Ardhana Universitas Qamarul Huda Badaruddin, Lombok
  • Alika Oktaviani Universitas Negeri Makassar, Makassar
  • Yulita Sirinti Pongtambing Hasanuddin University, Makassar
  • Eliyah A M Sampetoding Hasanuddin University, Makassar
  • Lopinta Sarungallo Hasanuddin University, Makassar
  • Rahmi Rahmi Hasanuddin University, Makassar

DOI:

https://doi.org/10.30865/ijics.v6i2.4537

Keywords:

Data Warehouse, Economic, Identification, Tourist

Abstract

Foreign tourist visits to Indonesia play an important role in the economic growth of the tourism sector. In increasing the interest of visitors, development resources are needed as a tourism sector. The development carried out must be carried out optimally with the growth trend of tourist visits so that development is right on target, effective and efficient. This study aims to visit foreign tourists to Indonesia using the implementation of a data warehouse. The dataset used is data on foreign tourist arrivals by nationality in 2021 sourced from the Central Statistics Agency (BPS). This is done to determine the interest and potential of tourism to support the country's economy. The steps taken in this analysis and identification are Choosing the Process, Choosing the Grain, Identifying and confirming the dimension, Choosing The Facts, Rounding out the dimension table, Choosing the duration of database, Tracking Slowly changing Dimensions, Deciding the query priorities and the query mode, and the last Storing pre-calculation in the fact information. The result can be seen Foreign Tourism Visits in Indonesia using the Application of OLAP Data Warehouse for analysis. So that in 2021 it can be analyzed that monthly tourist visits tend to be stable with the periods of July-August and January-December increasing. These results in the future can be used as a policy reference in increasing tourist visits to foreign tourist targets in certain countries. This is done to determine the interest and potential of tourism to support the country's economy through the tourism sector

References

T. Permana and A. Puspitaningsih, "Devisa dan Turis Mancanegara," Edutourism Journal Of Tourism Research, vol. 2, no. 1, pp. 79-82, 2020.

A. N. Rais, R. Rousyati, I. J. Thira, D. N. Kholifa, N. Purwati and Y. M. Kristania, "Evaluasi Metode Forecasting pada Data Kunjungan Wisatawan Mancanegara ke Indonesia," EVOLUSI: Jurnal Sains Dan Manajemen, vol. 8, no. 2, pp. 104-115, 2020.

C. M. Hall, "Constructing sustainable tourism development: The 2030 agenda and the managerial ecology of sustainable tourism," Journal of Sustainable Tourism, vol. 27, no. 7, pp. 1044-1060, 2019.

G. Mahiroh, Analisis Hubungan Sektor Pariwisata Terhadap Pertumbuhan Ekonomi Indonesia, Malang: Universitas Brawijaya, 2019.

K. W. Ksamawan, G. Maskie and D. Kaluge, "Pariwisata Pengaruhnya Terhadap Ekonomi: Analisis Kajian Asal Kunjungan Wisatawan Mancanegara," JIET (Jurnal Ilmu Ekonomi Terapan), vol. 4, no. 1, 2019.

"Kunjungan Wisatawan Mancanegara per bulan Menurut Kebangsaan," Badan pusat Statistik, Jakarta, 2022.

"Data Pariwisata," Badan Pusat Statistik, Jakarta, 2022.

W. Suprihatin, "Analisis Perilaku Konsumen Wisatawan Era Pandemi Covid-19 (Studi Kasus Pariwisata di Nusa Tenggara Barat)," Jurnal Bestari, vol. 1, no. 1, pp. 56-66, 2020.

D. T. Anggarini, "Upaya pemulihan industri pariwisata dalam situasi pandemi Covid-19," Jurnal Pariwisata, vol. 8, no. 1, pp. 22-31, 2021.

E. S. Manapa, "Analysis on the Method of Online Learning and Transportation Budgets from Indonesian Students During the Pandemic COVID-19," Journal Dynamic Saint, vol. 5, no. 2, pp. 985-991, 2020.

T. W. Sagala, E. A. Manapa, V. Y. P. Ardhana and G. Lewakabessy, "Perbandingan Implementasi Manajemen Pengetahuan pada Berbagai Industri," JTIM: Jurnal Teknologi Informasi dan Multimedia, vol. 1, no. 4, pp. 327-335, 2020.

J. F. Rusdi, "Peran teknologi informasi pada pariwisata Indonesia," Jurnal Accounting Information System (AIMS), vol. 2, no. 2, pp. 78-118, 2019.

S. Sowmya and K. R. Bab, "A Decision Tree Based Recommended System For Tourism," Journal Of Composition Theory, Computer Science, vol. 13, no. 12, pp. 27-42, 2020.

H. R. Taluay, K. B. Seminar and D. R. O. Monintja, "Development of web-based tourism decision support system in talaud island regency," International Journal of Information Technology and Business Management, vol. 39, no. 1, pp. 37-45, 2015.

A. Nanda, S. Gupta and V. Meenu, "A comprehensive survey of OLAP: recent trends," in 3rd International Conference on Electronics, Communication and Aerospace Technology (ICECA), 2019.

E. K. Suni and W. Ridwan, "Analisis Dan Perancangan Data Warehouse Untuk Mendukung Keputusan Redaksi Televisi Menggunakan Metode Nine-Step Kimball," J. Tek. Inform, vol. 11, no. 2, pp. 197-206, 2018.

Downloads

Published

2022-07-31

How to Cite

Larasati, I. S., Ardhana, V. Y. P., Oktaviani, A., Pongtambing, Y. S., Sampetoding, E. A. M., Sarungallo, L., & Rahmi, R. (2022). Analysis and Identification of International Tourist Visits to Indonesia Based on Data Warehouse Implementation. The IJICS (International Journal of Informatics and Computer Science), 6(2), 113–118. https://doi.org/10.30865/ijics.v6i2.4537

Issue

Section

Articles