BITOUR: A Business Intelligence Platform for Tourism Analysis

[EN] Integrating collaborative data in data-driven Business Intelligence (BI) system brings an opportunity to foster the decision-making process towards improving tourism competitiveness. This article presents BITOUR, a BI platform that integrates four collaborative data sources (Twitter, Openstreetmap, Tripadvisor and Airbnb). BITOUR follows a classical BI architecture and provides functionalities for data transformation, data processing, data analysis and data visualization. At the core of the data processing, BITOUR offers mechanisms to identify tourists in Twitter, assign tweets to attractions and accommodation sites from Tripadvisor and Airbnb, analyze sentiments in opinions issued by tourists, and all this using geolocation objects in Openstreetmap. With all these ingredients, BITOUR enables data analysis and visualization to answer questions like the most frequented places by tourists, the average stay length or the view of visitors of some particular destination.This work has been supported by COLCIENCIAS through a PhD scholarship. This work is supported by the Spanish MINECO project TIN2017-88476-C2-1-R.Bustamante, A.; Sebastiá Tarín, L.; Onaindia De La Rivaherrera, 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/ijgi9110671S123911Nakahira, K. T., Akahane, M., & Fukami, Y. (2012). The Difference and Limitation of Cognition for Piano Playing Skill with Difference Educational Design. Smart Innovation, Systems and Technologies, 609-617. doi:10.1007/978-3-642-29934-6_59Chua, A., Servillo, L., Marcheggiani, E., & Moere, A. V. (2016). Mapping Cilento: Using geotagged social media data to characterize tourist flows in southern Italy. Tourism Management, 57, 295-310. doi:10.1016/j.tourman.2016.06.013Karagiannakis, N., Giannopoulos, G., Skoutas, D., & Athanasiou, S. (2015). OSMRec Tool for Automatic Recommendation of Categories on Spatial Entities in OpenStreetMap. Proceedings of the 9th ACM Conference on Recommender Systems. doi:10.1145/2792838.2796555Burcher, M., & Whelan, C. (2017). Social network analysis as a tool for criminal intelligence: understanding its potential from the perspectives of intelligence analysts. Trends in Organized Crime, 21(3), 278-294. doi:10.1007/s12117-017-9313-8Alcabnani, S., Oubezza, M., & Elkafi, J. (2019). An approach for the implementation of semantic Big Data Analytics in the Social Business Intelligence process on distributed environments (Cloud computing). Proceedings of the 4th International Conference on Big Data and Internet of Things. doi:10.1145/3372938.3373003Zeng, B., & Gerritsen, R. (2014). What do we know about social media in tourism? A review. Tourism Management Perspectives, 10, 27-36. doi:10.1016/j.tmp.2014.01.001Lalicic, L. (2018). Open innovation platforms in tourism: how do stakeholders engage and reach consensus? International Journal of Contemporary Hospitality Management, 30(6), 2517-2536. doi:10.1108/ijchm-04-2016-0233Dwyer, L., & Kim, C. (2003). Destination Competitiveness: Determinants and Indicators. Current Issues in Tourism, 6(5), 369-414. doi:10.1080/13683500308667962Gomezelj, D. O., & Mihalič, T. (2008). Destination competitiveness—Applying different models, the case of Slovenia. Tourism Management, 29(2), 294-307. doi:10.1016/j.tourman.2007.03.009Zhong, L., Deng, J., & Xiang, B. (2008). Tourism development and the tourism area life-cycle model: A case study of Zhangjiajie National Forest Park, China. Tourism Management, 29(5), 841-856. doi:10.1016/j.tourman.2007.10.002Fernández, J. I. P., & Rivero, M. S. (2009). Measuring Tourism Sustainability: Proposal for a Composite Index. Tourism Economics, 15(2), 277-296. doi:10.5367/000000009788254377Cibinskiene, A., & Snieskiene, G. (2015). Evaluation of City Tourism Competitiveness. Procedia - Social and Behavioral Sciences, 213, 105-110. doi:10.1016/j.sbspro.2015.11.411Business Intelligence (BI)—Glossaryhttps://www.gartner.com/it-glossary/business-intelligence-bi/Mariani, M., Baggio, R., Fuchs, M., & Höepken, W. (2018). Business intelligence and big data in hospitality and tourism: a systematic literature review. International Journal of Contemporary Hospitality Management, 30(12), 3514-3554. doi:10.1108/ijchm-07-2017-0461Maeda, T. N., Yoshida, M., Toriumi, F., & Ohashi, H. (2016). Decision Tree Analysis of Tourists’ Preferences Regarding Tourist Attractions Using Geotag Data from Social Media. Proceedings of the Second International Conference on IoT in Urban Space. doi:10.1145/2962735.2962745Guy, I., Mejer, A., Nus, A., & Raiber, F. (2017). Extracting and Ranking Travel Tips from User-Generated Reviews. Proceedings of the 26th International Conference on World Wide Web. doi:10.1145/3038912.3052632Peng, M. Y.-P., Tuan, S.-H., & Liu, F.-C. (2017). Establishment of Business Intelligence and Big Data Analysis for Higher Education. Proceedings of the International Conference on Business and Information Management - ICBIM 2017. doi:10.1145/3134271.3134296Castellanos, M., Gupta, C., Wang, S., Dayal, U., & Durazo, M. (2012). A platform for situational awareness in operational BI. Decision Support Systems, 52(4), 869-883. doi:10.1016/j.dss.2011.11.011Cohen, L. (2017). Impacts of business intelligence on population health. Proceedings of the South African Institute of Computer Scientists and Information Technologists on - SAICSIT ’17. doi:10.1145/3129416.3129441Love, M., Boisvert, C., Uruchurtu, E., & Ibbotson, I. (2016). Nifty with Data. Proceedings of the 2016 ACM Conference on Innovation and Technology in Computer Science Education. doi:10.1145/2899415.2899431Berndt, D. J., Hevner, A. R., & Studnicki, J. (s. f.). Hospital discharge transactions: a data warehouse component. Proceedings of the 33rd Annual Hawaii International Conference on System Sciences. doi:10.1109/hicss.2000.926791Musa, G. J., Chiang, P.-H., Sylk, T., Bavley, R., Keating, W., Lakew, B., … Hoven, C. W. (2013). Use of GIS Mapping as a Public Health Tool–-From Cholera to Cancer. Health Services Insights, 6, HSI.S10471. doi:10.4137/hsi.s10471Mooney, S. J., Westreich, D. J., & El-Sayed, A. M. (2015). Commentary. Epidemiology, 26(3), 390-394. doi:10.1097/ede.0000000000000274Wisniewski, M. F., Kieszkowski, P., Zagorski, B. M., Trick, W. E., Sommers, M., & Weinstein, R. A. (2003). Development of a Clinical Data Warehouse for Hospital Infection Control. Journal of the American Medical Informatics Association, 10(5), 454-462. doi:10.1197/jamia.m1299Miah, S. J., Vu, H. Q., Gammack, J., & McGrath, M. (2017). A Big Data Analytics Method for Tourist Behaviour Analysis. Information & Management, 54(6), 771-785. doi:10.1016/j.im.2016.11.011Li, D., Deng, L., & Cai, Z. (2019). Statistical analysis of tourist flow in tourist spots based on big data platform and DA-HKRVM algorithms. Personal and Ubiquitous Computing, 24(1), 87-101. doi:10.1007/s00779-019-01341-xKrawczyk, M., & Xiang, Z. (2015). Perceptual mapping of hotel brands using online reviews: a text analytics approach. Information Technology & Tourism, 16(1), 23-43. doi:10.1007/s40558-015-0033-0Alaei, A. R., Becken, S., & Stantic, B. (2017). Sentiment Analysis in Tourism: Capitalizing on Big Data. Journal of Travel Research, 58(2), 175-191. doi:10.1177/0047287517747753Thelwall, M. (2019). Sentiment Analysis for Tourism. Big Data and Innovation in Tourism, Travel, and Hospitality, 87-104. doi:10.1007/978-981-13-6339-9_6Höpken, W., Fuchs, M., Höll, G., Keil, D., & Lexhagen, M. (2013). Multi-Dimensional Data Modelling for a Tourism Destination Data Warehouse. Information and Communication Technologies in Tourism 2013, 157-169. doi:10.1007/978-3-642-36309-2_14Sabou, M., Onder, I., Brasoveanu, A. M. P., & Scharl, A. (2015). Towards Cross-Domain Decision Making in Tourism: A Linked Data Based Approach. SSRN Electronic Journal. doi:10.2139/ssrn.2580242Fermoso, A. M., Mateos, M., Beato, M. E., & Berjón, R. (2015). Open linked data and mobile devices as e-tourism tools. A practical approach to collaborative e-learning. Computers in Human Behavior, 51, 618-626. doi:10.1016/j.chb.2015.02.032Wöber, K. W. (2003). Information supply in tourism management by marketing decision support systems. Tourism Management, 24(3), 241-255. doi:10.1016/s0261-5177(02)00071-7Vajirakachorn, T., & Chongwatpol, J. (2017). Application of business intelligence in the tourism industry: A case study of a local food festival in Thailand. Tourism Management Perspectives, 23, 75-86. doi:10.1016/j.tmp.2017.05.003Diakopoulos, N., Naaman, M., & Kivran-Swaine, F. (2010). Diamonds in the rough: Social media visual analytics for journalistic inquiry. 2010 IEEE Symposium on Visual Analytics Science and Technology. doi:10.1109/vast.2010.5652922Bustamante, A., Sebastia, L., & Onaindia, E. (2019). Can Tourist Attractions Boost Other Activities Around? A Data Analysis through Social Networks. Sensors, 19(11), 2612. doi:10.3390/s19112612Yasseri, T., Quattrone, G., & Mashhadi, A. (2013). Temporal analysis of activity patterns of editors in collaborative mapping project of OpenStreetMap. Proceedings of the 9th International Symposium on Open Collaboration. doi:10.1145/2491055.2491068Jilani, M., Corcoran, P., & Bertolotto, M. (2013). Multi-granular Street Network Representation towards Quality Assessment of OpenStreetMap Data. Proceedings of the Sixth ACM SIGSPATIAL International Workshop on Computational Transportation Science - IWCTS ’13. doi:10.1145/2533828.2533833Luxen, D., & Vetter, C. (2011). Real-time routing with OpenStreetMap data. Proceedings of the 19th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems - GIS ’11. doi:10.1145/2093973.2094062Baumbach, S., Rubel, C., Ahmed, S., & Dengel, A. (2019). Geospatial Customer, Competitor and Supplier Analysis for Site Selection of Supermarkets. Proceedings of the 2019 2nd International Conference on Geoinformatics and Data Analysis. doi:10.1145/3318236.3318264Milot, J., Munroe, P., Beaudry, E., Grondin, F., & Bourdeau, G. (2016). Lookupia. Proceedings of the 25th International Conference Companion on World Wide Web - WWW ’16 Companion. doi:10.1145/2872518.2890485Ciepluch, B., Mooney, P., Jacob, R., & Winstanley, A. C. (2009). Using OpenStreetMap to deliver location-based environmental information in Ireland. SIGSPATIAL Special, 1(3), 17-22. doi:10.1145/1645424.1645428Del Pilar Salas-Zárate, M., López-López, E., Valencia-García, R., Aussenac-Gilles, N., Almela, Á., & Alor-Hernández, G. (2014). A study on LIWC categories for opinion mining in Spanish reviews. Journal of Information Science, 40(6), 749-760. doi:10.1177/0165551514547842Gambino, O. J., & Calvo, H. (2016). A Comparison Between Two Spanish Sentiment Lexicons in the Twitter Sentiment Analysis Task. Advances in Artificial Intelligence - IBERAMIA 2016, 127-138. doi:10.1007/978-3-319-47955-2_11Mooney, P., Corcoran, P., & Winstanley, A. C. (2010). Towards quality metrics for OpenStreetMap. Proceedings of the 18th SIGSPATIAL International Conference on Advances in Geographic Information Systems - GIS ’10. doi:10.1145/1869790.1869875El-Ashmawy, K. l. A. (2016). TESTING THE POSITIONAL ACCURACY OF OPENSTREETMAP DATA FOR MAPPING APPLICATIONS. Geodesy and cartography, 42(1), 25-30. doi:10.3846/20296991.2015.116049

A Review of Text Corpus-Based Tourism Big Data Mining

With the massive growth of the Internet, text data has become one of the main formats of tourism big data. As an effective expression means of tourists’ opinions, text mining of such data has big potential to inspire innovations for tourism practitioners. In the past decade, a variety of text mining techniques have been proposed and applied to tourism analysis to develop tourism value analysis models, build tourism recommendation systems, create tourist profiles, and make policies for supervising tourism markets. The successes of these techniques have been further boosted by the progress of natural language processing (NLP), machine learning, and deep learning. With the understanding of the complexity due to this diverse set of techniques and tourism text data sources, this work attempts to provide a detailed and up-to-date review of text mining techniques that have been, or have the potential to be, applied to modern tourism big data analysis. We summarize and discuss different text representation strategies, text-based NLP techniques for topic extraction, text classification, sentiment analysis, and text clustering in the context of tourism text mining, and their applications in tourist profiling, destination image analysis, market demand, etc. Our work also provides guidelines for constructing new tourism big data applications and outlines promising research areas in this field for incoming years

A Review of Text Corpus-Based Tourism Big Data Mining

With the massive growth of the Internet, text data has become one of the main formats of tourism big data. As an effective expression means of tourists’ opinions, text mining of such data has big potential to inspire innovations for tourism practitioners. In the past decade, a variety of text mining techniques have been proposed and applied to tourism analysis to develop tourism value analysis models, build tourism recommendation systems, create tourist profiles, and make policies for supervising tourism markets. The successes of these techniques have been further boosted by the progress of natural language processing (NLP), machine learning, and deep learning. With the understanding of the complexity due to this diverse set of techniques and tourism text data sources, this work attempts to provide a detailed and up-to-date review of text mining techniques that have been, or have the potential to be, applied to modern tourism big data analysis. We summarize and discuss different text representation strategies, text-based NLP techniques for topic extraction, text classification, sentiment analysis, and text clustering in the context of tourism text mining, and their applications in tourist profiling, destination image analysis, market demand, etc. Our work also provides guidelines for constructing new tourism big data applications and outlines promising research areas in this field for incoming years

What drives the helpfulness of online reviews? A deep learning study of sentiment analysis, pictorial content and reviewer expertise for mature destinations.

User-generated content (UGC) is a growing driver of destination choice. Drawing on dual-process theories on how individuals process information, this study focuses on the role of central and peripheral information processing routes in the formation of consumers’ perceptions of the helpfulness of online reviews. We carried out a two-step process to address the perceived helpfulness of user-generated content, a sentiment analysis using advanced machine-learning techniques (deep learning), and a regression analysis. We used a database of 2,023 comments posted on TripAdvisor about two iconic Venetian cultural attractions, St. Mark’s Square (an open, free attraction) and the Doge’s Palace (a museum which charges an entry fee). Following the application of deep-learning techniques, we first identified which factors influenced whether a review received a “helpful” vote by means of logistic regression. Second, we selected those reviews which received at least one helpful vote to identify, through linear regression, the significant determinants of TripAdvisor users’ voting behaviour. The results showed that reviewer expertise is an influential factor in both free and paid-for attractions, although the impact of central cues (sentiment polarity, subjectivity and pictorial content) is different in both attractions. Our study suggests that managers should look beyond individual ratings and focus on the sentiment analysis of online reviews, which are shown to be based on the nature of the attraction (free vs. paid-for)

Vandalism and tourism settings: an integrative review

Although wide agreement exists in the literature concerning the presence of vandalism in tourism, very little attention has been given to studying the phenomenon. This paper reviews published literature that addresses vandalism, its manifestation in tourism and its prevention. The review provides a comprehensive analysis of empirical research on the motivations for vandalism, deviant visitor behaviour and intervention strategies to manage such behaviours in tourism settings. The paper reviews the micro-level and macro level forces influencing vandalism and provides a definition, thematic analysis of current literature on motivation of vandalism and common themes in vandalism prevention. The analysis demonstrates a range of intervention strategies to curb vandalism. An evolution towards the use of more refined proactive techniques is apparent in recent work. The review provides a foundation for further work by theorists and practitioners

Toward personalised and dynamic cultural routing: a three-level approach

This paper introduces the concept of “smart routing” as a recommender system for tourists that takes into account the dynamics of their personal user profiles. The concept relies on three levels of support: 1) programming the tour, i.e. selecting a set of relevant points of interests (POIs) to be included into the tour, 2) scheduling the tour, i.e. arranging the selected POIs into a sequence based on the cultural, recreational and situational value of each, and 3) determining the tour’s travel route, i.e. generating a set of trips between the POIs that the tourist needs to perform in order to complete the tour. The “smart routing” approach intends to enhance the experience of tourists in a number of ways. The first advantage is the system’s ability to reflect on the tourists’ dynamic preferences, for which an understanding of the influence of a tourist’s affective state and dynamic needs on the preferred activities is required. Next, it arranges the POIs together in a way that creates a storyline that the tourist will be interested to follow, which adds to the tour’s cultural value. Finally, the POIs are connected by a chain of multimodal trips that the tourist will have to make, also in accordance with the tourist’s preferences and dynamic needs. As a result, each tour can be personalised in a “smart” way, from the perspective of both the cultural and the overall experience of taking it. We present the building blocks of the “smart routing” concept in detail and describe the data categories involved. We also report on the current status of our activities with respect to the inclusion of a tourist’s affective state and dynamic needs into the preference measurement phase, as well as discuss relevant practical concerns in this regard

Destination image online analyzed through user generated content: a systematic literature review

Destination Image is a concept that has been studied for a long time in tourism research. The question of how a destination is perceived by tourists and potential new guests is an important insight, especially for local tourism managers, in order to evaluate the implemented strategies and to plan further tactics. Since the last two decades, due to a drastic digitalization, tourism research is now increasingly examining the Destination Image online. This creates new challenges in the selection of sources, methods, and in data collection. The aim of the present study was to systematically capture the approach to analyze the online Destination Image through User Generated Content using studies from the last ten years. Therefore, a Systematic Literature Review on primary research from academic databases was conducted. As a summary of the findings, a conceptual model was developed, based on the insights of the studies in the dataset, to contribute a guidance for the preparation phase of future online Destination Image research. In short, the main findings are: TripAdvisor.com is the main source for online Destination Image analysis. Researchers recommend using the help of software and programming languages to collect and analyzed the data. Equally to earlier Destination Image studies, the main methods applied in online Destination Image analysis are quantitative content analysis, qualitative content analysis and sentiment analysis. In combination with the examination of cognitive and affective factors, co-occurrence analysis, and correlation analysis. The present study has several limitations, which are: the loss of detail information due to reducing the studies to comparable key parameters, the absence of Anglo-American studies, due to the database selection as well as the lack of quality testing of the studies included.A Destination Image é um conceito que tem sido estudado há muito tempo na investigação turística. A questão de como o destino é visto pelos turistas e pelos potenciais novos hóspedes é uma perspectiva importante, especialmente para os gestores de turismo da região, a fim de avaliar as estratégias implementadas e de planear novas tácticas. Desde as últimas duas décadas, ocorreu uma digitalização drástica, a investigação turística adaptou-se a este fenómeno e está agora a estudar cada vez mais a imagem do destino online. Esta alteração criou novos desafios na selecção de fontes, métodos, e na recolha de dados. O objetivo do presente trabalho foi o de captar, de forma sistemática, as abordagens consideradas para analisar a imagem do destino online utilizando estudos dos últimos dez anos. Para este efeito, os estudos primários dos anos 2010-2020 das bases de dados académicos Web of Science, ProQuest e b-on, foram recolhidos utilizando palavras-chave de pesquisa pré-definidas. O grupo de artigos obtidos como resultado foram subsequentemente sujeitos a avaliação de eligibilidade, como recomendado por Moher et al. (2009). Isto significa que os estudos que não cumpriam os critérios pré-definidos foram excluídos. Os critérios de inclusão foram: O trabalho académico tinha de ser uma referência primária de uma revista científica, escrita em inglês e a amostra analisada tinha de ter uma origem associada à comunicação nas social media online. Posteriormente, os restantes 35 artigos foram transferidos para uma base de dados utilizando uma matriz de codificação. A matriz de codificação foi concebida para capturar os parâmetros-chave de cada estudo primário de uma forma padronizada e, portanto, comparável. Foi considerada informação geral, como o ano, localização e revista publicada, bem como informação temática específica, como o campo do turismo pesquisado e os meios analisados, juntamente com as categorias referentes à metodologia considerada, as ferramentas utilizadas e os resultados obtidos. A base de dados resultante foi então utilizada para obter declarações sobre a abordagem metodológica utilizada na análise da imagem de destinos online. Como resumo dos resultados, foi desenvolvido um modelo conceptual, baseado nos conhecimentos obtidos a partir do grupo de artigos, que constituiu o conjunto de dados para análise, para contribuir com um guião para a fase de preparação de uma futura investigação sobre imagem dos destinos online. Em resumo, as principais conclusões são: TripAdvisor.com é a principal fonte para a análise da imagem de destinos online. Os investigadores recomendam a utilização da ajuda de software e linguagens de programação para a recolha e análise dos dados. À semelhança de estudos anteriores de Destination Image, os principais métodos aplicados na análise imagem dos destinos online são a análise quantitativa do conteúdo, a análise qualitativa do conteúdo e a análise dos sentimentos. Em combinação com a análise dos fatores cognitivos e afectivos, análise de co-ocorrência, e análise de correlação. O presente estudo tem várias limitações. Que são: a perda de informação detalhada devido à redução dos estudos a parâmetros-chave comparáveis, a ausência de estudos anglo-americanos, devido à selecção do banco de dados, bem como a falta de testes de qualidade dos estudos incluídos.(TurExperience - Tourist experiences' impacts on the destination image: searching for new opportunities to the Algarve”)