Peran Lokasi Strategis Restoran dan Kafe Bandung Melalui Data Warehouse dan Business Intelligence
Abstract
This study discusses the significance of applying Data Warehouse and Business Intelligence (BI) in supporting the determination of strategic locations for restaurants and cafés in Bandung, a city experiencing rapid growth alongside increasing tourist visits, particularly in culinary tourism. The purpose of this research is to analyze the role of a system capable of integrating spatial and non-spatial data to support data-driven decision-making. The methods employed include the ETL (Extract, Transform, Load) process and the Nine Step Methodology in developing a Data Warehouse that stores restaurant and cafe data from 2020–2022. The system is equipped with a Business Intelligence Dashboard to present analyses of location trends, consumer preferences, and regional density based on spatial and demographic attributes. The findings indicate that the system can validate and facilitate business owners in identifying potential locations more accurately and efficiently. The contribution of this research is providing an implementation model of Data Warehouse and Business Intelligence as a strategic solution for the restaurant and cafe industry amid increasingly intense competition.
Keywords: Data Warehouse; Business Intelligence; ETL; Nine Step Methodology; Strategic Location
Abstrak
Penelitian ini membahas betapa pentingnya penerapan Data Warehouse dan Business Intelligence (BI) dalam mendukung penentuan lokasi strategis restoran dan kafe di Kota Bandung yang mengalami pertumbuhan pesat seiring meningkatnya kunjungan wisatawan dan salah satunya adalah wisata makanan dan minuman. Tujuan penelitian ini adalah menganalisis peran sistem yang mampu mengintegrasikan data spasial dan non-spasial untuk mendukung pengambilan keputusan berbasis data. Metode yang digunakan adalah ETL (Extract, Transform, Load) serta Nine Step Methodology dalam perkembangan Data Warehouse yang memuat data restoran dan kafe periode 2020–2022. Sistem dilengkapi dengan Dashboard Business Intelligence untuk menampilkan analisis tren lokasi, preferensi konsumen, dan kepadatan wilayah berdasarkan atribut spasial dan demografis. Hasil penelitian menunjukkan bahwa sistem dapat memvalidasi dan mempermudah pemilik usaha dalam menentukan lokasi potensial secara lebih akurat dan efisien. Kontribusi penelitian ini memberikan model implementasi Data Warehouse dan Business Intelligence sebagai solusi strategis bagi industri restoran dan kafe di tengah persaingan yang semakin ketat.
Keywords
References
F. Nawawi, A. Nugroho, and I. Wibowo, “Breaking the stigma: Increasing comprehensive HIV knowledge to end discrimination against people living with HIV,” The Indonesian Journal of Community and Occupational Medicine, vol. 2, no. 3, pp. 120–123, 2023. https://doi.org/10.53773/ijcom.v2i3.76.120-3
K. Suryana, H. Suharsono, and N. Joenputri, “Factors associated with quality of life among people living with HIV/AIDS on highly active antiretroviral therapy: A cross-sectional study,” International Journal of Pharmacy and Pharmaceutical Sciences, vol. 12, no. 9, pp. 36–40, 2020. https://doi.org/10.22159/ijpps.2020v12i9.38628
CC. Arnold, B. Sonn, F. Meyers, A. Vest, R. Puls, E. Zirkler, et al., “Accessing and utilizing clinical and genomic data from an electronic health record data warehouse,” Translational Medicine Communications, vol. 8, no. 1, pp. 1–11, 2023. https://doi.org/10.1186/s41231-023-00140-0
X. Zeng, E. Forrestal, L. Cellucci, M. Kennedy, and D. Smith, “Using electronic health records and data warehouse collaboratively in community health centers,” Journal of Cases on Information Technology, vol. 15, no. 4, pp. 45–62, 2013. https://doi.org/10.4018/jcit.2013100104
L. Fleuren, T. Dam, M. Tonutti, D. Bruin, R. Lalisang, D. Gommers, et al., “The Dutch data warehouse, a multicenter and full-admission electronic health records database for critically ill COVID-19 patients,” Critical Care, vol. 25, no. 1, pp. 1–11, 2021. https://doi.org/10.1186/s13054-021-03733-z
M. Kahn, J. Mui, M. Ames, A. Yamsani, N. Pozdeyev, N. Rafaels, et al., “Migrating a research data warehouse to a public cloud: Challenges and opportunities,” Journal of the American Medical Informatics Association, vol. 29, no. 4, pp. 592–600, 2021. https://doi.org/10.1093/jamia/ocab278
W. Utami, “Optimal control analysis of HIV/AIDS disease spread model in Indonesia,” Barekeng Jurnal Ilmu Matematika dan Terapan, vol. 18, no. 2, pp. 707–716, 2024. https://doi.org/10.30598/barekengvol18iss2pp0707-0716
J. Yao, J. Wang, Q. Chen, and R. Xing, “Core methodologies in data warehouse design and development,” International Journal of Robotics Applications and Technologies, vol. 1, no. 1, pp. 57–66, 2013. https://doi.org/10.4018/ijrat.2013010104
N. Ardista, P. Purbandini, and T. Taufik, “Rancang bangun data warehouse untuk pembuatan laporan dan analisis pada data kunjungan pasien rawat jalan Rumah Sakit Universitas Airlangga berbasis Online Analytical Processing (OLAP),” Journal of Information Systems Engineering and Business Intelligence, vol. 3, no. 1, pp. 40-51, 2017. https://doi.org/10.20473/jisebi.3.1.40-51
H. Maryanto, “Analysis and design of data warehouse and data mart budget,” Journal of Intelligent Software Systems, vol. 2, no. 1, pp. 6-14, 2023. https://doi.org/10.26798/jiss.v2i1.927
M. Syaputra, “Data warehouse design for sales transactions on CV. Sumber Tirta Anugerah,” Jurnal CoreIT: Jurnal Hasil Penelitian Ilmu Komputer dan Teknologi Informasi, vol. 8, no. 2, pp. 88-96, 2022. https://doi.org/10.24014/coreit.v8i2.19800
M. Akbar and Y. Rahmanto, “Desain data warehouse penjualan menggunakan Nine Step Methodology untuk Business Intelligence pada PT Bangun Mitra Makmur,” Jurnal Informatika dan Rekayasa Perangkat Lunak, vol. 1, no. 2, pp. 137–146, 2020. https://doi.org/10.33365/jatika.v1i2.331
A. Dhaouadi, K. Bousselmi, M. Gammoudi, and S. Hammoudi, “Data warehousing process modeling from classical approaches to new trends: main features and comparisons,” Data, vol. 7, no. 8, pp. 113-127, 2022. https://doi.org/10.3390/data7080113
X. Liu, N. Iftikhar, H. Huo, and P. Nielsen, “Optimizing ETL by a two-level data staging method,” International Journal of Data Warehousing and Mining, vol. 12, no. 3, pp. 32–50, 2016. https://doi.org/10.4018/ijdwm.2016070103
S. Arifin, G. Madey, A. Vyushkov, B. Raybaud, and F. Collins, “An Online Analytical Processing multi-dimensional data warehouse for malaria data,” Database: The Journal of Biological Databases and Curation, vol. 2017, no. 1, pp. 1–12, 2017. https://doi.org/10.1093/database/bax073
B. Khan, “An overview of ETL techniques, tools, processes and evaluations in data warehousing,” Journal on Big Data, vol. 6, no. 1, pp. 1–20, 2024. https://doi.org/10.32604/jbd.2023.046223
F. Amanzougarene, M. Chachoua, and K. Zeitouni, “Handling imprecision in qualitative data warehouse: Urban building sites annoyance analysis use case,” The International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences, vol. XL-2/W1, pp. 133–138, 2013. https://doi.org/10.5194/isprsarchives-XL-2-W1-133-2013
E. Malinowski and E. Zimányi, Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications. Berlin, Germany: Springer, 2008.
How To Cite This :
Refbacks
- There are currently no refbacks.
