Multidimensional Analysis of Booking Data in Hospitality Industry Using Data Warehousing Techniques

Lam, Mai and Nguyen, Duc-Hien (2024) Multidimensional Analysis of Booking Data in Hospitality Industry Using Data Warehousing Techniques. INTI JOURNAL, 2024 (54). pp. 1-10. ISSN e2600-7320

[img] Text
ij2024_54.pdf - Published Version
Available under License Creative Commons Attribution.
Download (298kB)
Official URL: https://intijournal.intimal.edu.my

Abstract

Understanding customer behaviors is essential for optimizing pricing strategies, enhancing guest experiences, and effectively meeting demand in the hospitality industry. This study presents the development of a data warehouse system designed to analyze hotel booking behaviors. Using ETL processes, reservation data from diverse sources is consolidated and standardized to enable comprehensive analysis. Then, multidimensional analyses of booking frequency and transaction value reveal key customer preferences and behavioral patterns. A real-world dataset comprising 119,390 records spanning from July 1, 2015, to August 31, 2017, was utilized to validate the system. Multidimensional analyses revealed that 70% of bookings occurred during peak seasons, with transaction values averaging 25% higher compared to off-peak periods. Additionally, customers who booked via direct channels displayed a 20% higher retention rate. The results validate the proposed system's capability to provide actionable intelligence, driving effective business strategies and supporting predictive modeling in the hospitality industry.

Item Type: Article
Uncontrolled Keywords: hospitality industry, customer behaviors, ETL, OLAP, multidimentional data
Subjects: H Social Sciences > H Social Sciences (General)
H Social Sciences > HD Industries. Land use. Labor
H Social Sciences > HD Industries. Land use. Labor > HD28 Management. Industrial Management
Depositing User: Unnamed user with email masilah.mansor@newinti.edu.my
Date Deposited: 31 Dec 2024 03:24
Last Modified: 31 Dec 2024 03:24
URI: http://eprints.intimal.edu.my/id/eprint/2119

Actions (login required)

View Item View Item
INTI Institutional Repository is powered by EPrints 3 which is developed by the School of Electronics and Computer Science at the University of Southampton. More information and software credits.