A Decision-Support System to Analyse Customer Satisfaction Applied to a Tourism Transport Service
Abstract
:1. Introduction
2. Literature Review
2.1. Customer Experience
2.2. Business Intelligence and Data Mining in the Travel Industry
2.3. Discussion
3. Methodology
3.1. Data Gathering, Transformation, and Database Storage
- (i)
- Data collection: The data was collected from the company’s (YellowFish Transfers, https://www.yellowfishtransfers.com/, accessed on 23 November 2022) information system, which is characterised by 90,691 anonymized rows, corresponding to the operational data from 2012 to 2017. Each row is made up of all the available information (items/attributes) about a traveller or group associated with that traveller.
- (ii)
- Data Transformation: To answer the research question, filters were applied to the dataset to only consider: (a) arrivals to the Faro Airport (in Algarve, Portugal) and (b) rows with customer feedback comments. This resulted in 29,339 rows available.
- (iii)
- Upload to the Data Warehouse: From the available attributes, only the variables relevant to the present study were considered, which are detailed with the respective description and units in Table 1 and Table 2, and in Section 3.2.1.
3.2. Decision-support System to Analyse Consumer Satisfaction
3.2.1. Variables Considered in the Study
3.2.2. OLAP Techniques
- (i)
- Number of countries of origin: 23, with the United Kingdom standing out with the highest number of services (21,066), followed by Ireland (7168) and Portugal (308). The countries with the lowest number of services, equivalent to the minimum considered (5), are the Czech Republic, Estonia, and Italy.
- (ii)
- Average number of passengers transported per trip: Estonia is the country with the highest value (4.2 passengers), followed by Ireland (3.37) and Poland (3.22). The countries with the lowest average number are Portugal (2.20), followed by North America (USA and Canada) (2.35), and Spain and Austria (2.44).
- (iii)
- Average number of kilometres travelled per service: Switzerland is the country with the highest value (70.48 km), followed by Sweden (63.81 km) and Australia (61.22 km), and very close is Germany (61.21 km). The countries with the lowest average km travelled per service is Italy (33.00 km), followed by Luxembourg (36.32 km), Romania (43.00 km), and very close is Estonia (43.80 km).
- (iv)
- Regarding the average attributed to experience (evaluated by the FeedbackExperience variable), the three countries that appear with the highest value (5.0 out of 5.0) are Estonia, Italy, and Romania, whose number of services is five for the first two countries and six for the third, meaning that all customers in these countries rated the experience with five values (standard deviation of 0.0). For the countries with the lowest value, Sweden has the lowest value (4.6), followed by France (4.72), and Luxembourg is tied with the Netherlands (4.74).
- (v)
- Concerning the difference in opinions within the same country (measured by the standard deviation of the sample applied to the FeedbackExperience variable), Austria has a higher variability value (0.63), followed by France (0.57) and Portugal (0.56).
3.2.3. Data-Mining Techniques
- (a)
- Cloud of words, shown in Figure 4, considers the FeedbackComments to study customer satisfaction with tourism transport services. The text mining analysis was performed on 29,339 comments. Given that the size of the words represents the frequency of the words in the services’ commentaries, it is possible to see that some of the words with higher frequency were: “service”, “excellent”, “recommend”, “friendly”, and “great”, among others.
- (b)
- Sentiment Analysis evaluates the sentiment associated with service comments. The VADER algorithm was used for this analysis [58], which produces a result between −1 (most negative sentiment) and +1 (most positive sentiment). Consequently, the results present a “sentiment value” for each comment, which is within the range of values described, where the most positive comment had a sentiment value (compound) of 0.9981, which has an associated value of 5.0 in the FeedbackExperience variable and which corresponds to the text shown in Figure 5. The most negative sentiment was the value of −0.9867, which is associated with a FeedbackExperience of 3.0, whose comment is also represented in Figure 5.
4. Analysis, Discussion, and Implications of the Results
5. Conclusions
Author Contributions
Funding
Institutional Review Board Statement
Informed Consent Statement
Data Availability Statement
Acknowledgments
Conflicts of Interest
References
- Xu, X.; Wang, X.; Li, Y.; Haghighi, M. Business intelligence in online customer textual reviews: Understanding consumer perceptions and influential factors. Int. J. Inf. Manag. 2017, 37, 673–683. [Google Scholar] [CrossRef]
- Altay, B.C.; Okumuş, A. User adoption of integrated mobility technologies: The case of multimodal trip-planning apps in Turkey. Res. Transp. Bus. Manag. 2022, 43, 100706. [Google Scholar] [CrossRef]
- Nyanga, C.; Pansiri, J.; Chatibura, D. Enhancing competitiveness in the tourism industry through the use of business intelligence: A literature review. J. Tour. Futures 2019, 6, 139–151. [Google Scholar] [CrossRef] [Green Version]
- van Lierop, D.; El-Geneidy, A. Enjoying loyalty: The relationship between service quality, customer satisfaction, and behavioral intentions in public transit. Res. Transp. Econ. 2016, 59, 50–59. [Google Scholar] [CrossRef]
- Moldabekova, A.; Philipp, R.; Reimers, H.E.; Alikozhayev, B. Digital technologies for improving logistics performance of countries. Transp. Telecommun. 2021, 22, 207–216. [Google Scholar] [CrossRef]
- Le, H.T.; Carrel, A.L.; Shah, H. Impacts of online shopping on travel demand: A systematic review. Transp. Rev. 2022, 42, 273–295. [Google Scholar] [CrossRef]
- Olmeda, I.; Sheldon, P.J. Data mining techniques and applications for tourism internet marketing. J. Travel Tour. Mark. 2002, 11, 1–20. [Google Scholar] [CrossRef]
- Sharma, M.P.; Sharma, N. Performance Impact of Changing ICT Environment: A Case Study of Indian Hospitality and Tourism Sector. In Proceedings of the International Conference on Smart Trends for Information Technology and Computer Communications, Jaipur, India, 6–7 August 2016; Springer: Singapore; pp. 119–127. [Google Scholar]
- Jin, S.V.; Phua, J. Making reservations online: The impact of consumer-written and system-aggregated user-generated content (UGC) in travel booking websites on consumers’ behavioral intentions. J. Travel Tour. Mark. 2016, 33, 101–117. [Google Scholar] [CrossRef]
- Fuchs, M.; Höpken, W.; Lexhagen, M. Business intelligence for destinations: Creating knowledge from social media. In Advances in Social Media for Travel, Tourism and Hospitality; Routledge: Abingdon, UK, 2017; pp. 290–310. [Google Scholar]
- Liang, T.P.; Liu, Y.H. Research landscape of business intelligence and big data analytics: A bibliometrics study. Expert Syst. Appl. 2018, 111, 2–10. [Google Scholar] [CrossRef]
- Santos, Z.R.; Cheung, C.M.; Coelho, P.S.; Rita, P. Consumer engagement in social media brand communities: A literature review. Int. J. Inf. Manag. 2022, 63, 102457. [Google Scholar] [CrossRef]
- Mariani, M.; Baggio, R.; Fuchs, M.; Höepken, W. Business intelligence and big data in hospitality and tourism: A systematic literature review. Int. J. Contemp. Hosp. Manag. 2018, 30, 3514–3554. [Google Scholar] [CrossRef] [Green Version]
- Gorter, C.; Nijkamp, P.; Vork, R. Analysis of travellers’ satisfaction with transport chains. Transp. Plan. Technol. 2000, 23, 237–258. [Google Scholar] [CrossRef] [Green Version]
- Bassi, F.; Guido, G. Measuring customer satisfaction: From product performance to consumption experience. J. Consum. Satisf. Dissatisfaction Complain. Behav. 2006, 19, 76–88. [Google Scholar]
- Guiver, J.; Lumsdon, L.; Weston, R.; Ferguson, M. Do buses help meet tourism objectives? The contribution and potential of scheduled buses in rural destination areas. Transp. Policy 2007, 14, 275–282. [Google Scholar] [CrossRef]
- Kim, Y.K.; Lee, H.R. Customer satisfaction using low cost carriers. Tour. Manag. 2011, 32, 235–243. [Google Scholar] [CrossRef]
- Garg, R.; Rahman, Z.; Qureshi, M.N.; Kumar, I. Identifying and ranking critical success factors of customer experience in banks: An analytic hierarchy process (AHP) approach. J. Model. Manag. 2012, 7, 201–220. [Google Scholar] [CrossRef]
- Pecorari, P.M.; Lima, C.R.C. Correlation of customer experience with the acceptance of product-service systems and circular economy. J. Clean. Prod. 2021, 281, 125275. [Google Scholar] [CrossRef]
- Khan, I.; Garg, R.J.; Rahman, Z. Customer service experience in hotel operations: An empirical analysis. Procedia Soc. Behav. Sci. 2015, 189, 266–274. [Google Scholar] [CrossRef] [Green Version]
- Klaus, P.P.; Maklan, S. Towards a better measure of customer experience. Int. J. Mark. Res. 2013, 55, 227–246. [Google Scholar] [CrossRef] [Green Version]
- Gitto, S.; Mancuso, P. Improving airport services using sentiment analysis of the websites. Tour. Manag. Perspect. 2017, 22, 132–136. [Google Scholar] [CrossRef]
- Mogaji, E.; Erkan, I. Insight into consumer experience on UK train transportation services. Travel Behav. Soc. 2019, 14, 21–33. [Google Scholar] [CrossRef]
- Park, E. The role of satisfaction on customer reuse to airline services: An application of Big Data approaches. J. Retail. Consum. Serv. 2019, 47, 370–374. [Google Scholar] [CrossRef]
- Park, E.; Jang, Y.; Kim, J.; Jeong, N.J.; Bae, K.; Del Pobil, A.P. Determinants of customer satisfaction with airline services: An analysis of customer feedback big data. J. Retail. Consum. Serv. 2019, 51, 186–190. [Google Scholar] [CrossRef]
- Thelwall, M. Sentiment Analysis for Tourism. In Big Data and Innovation in Tourism, Travel, and Hospitality; Sigala, M., Rahimi, R., Thelwall, M., Eds.; Springer: Singapore, 2019; pp. 87–104. [Google Scholar]
- Lee, M.; Lee, S.A.; Koh, Y. Multisensory experience for enhancing hotel guest experience: Empirical evidence from big data analytics. Int. J. Contemp. Hosp. Manag. 2019, 31, 4313–4337. [Google Scholar] [CrossRef]
- Cheng, L.C.; Chen, K.; Lee, M.C.; Li, K.M. User-Defined SWOT analysis–A change mining perspective on user-generated content. Inf. Process. Manag. 2021, 58, 102613. [Google Scholar] [CrossRef]
- Moro, S.; Esmerado, J.; Ramos, P.; Alturas, B. Evaluating a guest satisfaction model through data mining. Int. J. Contemp. Hosp. Manag. 2020, 32, 1523–1538. [Google Scholar] [CrossRef]
- Li, Q.; Li, S.; Zhang, S.; Hu, J.; Hu, J. A review of text corpus-based tourism big data mining. Appl. Sci. 2019, 9, 3300. [Google Scholar] [CrossRef] [Green Version]
- Khalilinezhad, S.; Fazlollahtabar, H.; Minaei-Bidgoli, B.; Eslami Nosratabadi, H. Detecting Valuable Customers Using the Trade Patterns of Financial Transactions Applying Integrated RFM and OLAP. Int. J. Ind. Eng. Prod. Res. 2021, 32, 1–15. [Google Scholar]
- Larson, D.; Chang, V. A review and future direction of agile, business intelligence, analytics and data science. Int. J. Inf. Manag. 2016, 36, 700–710. [Google Scholar] [CrossRef] [Green Version]
- Vinod, B. Artificial Intelligence in travel. J. Revenue Pricing Manag. 2021, 20, 368–375. [Google Scholar] [CrossRef]
- McGill, J.I.; van Ryzin, G.J. Foreword to the Focused Issue on Yield Management in Transportation. Transp. Sci. 1999, 33, 135. [Google Scholar]
- Morales, D.R.; Wang, J. Forecasting cancellation rates for services booking revenue management using data mining. Eur. J. Oper. Res. 2010, 202, 554–562. [Google Scholar] [CrossRef] [Green Version]
- Lawrence, R.D.; Hong, S.J.; Cherrier, J. Passenger-based predictive modeling of airline no-show rates. In Proceedings of the ninth ACM SIGKDD International Conference on Knowledge Discovery and Data Mining, Washington, DC, USA, 24–27 August 2003; pp. 397–406. [Google Scholar]
- Gorzałczany, M.B.; Rudziński, F.; Piekoszewski, J. Business Intelligence in Airline Passenger Satisfaction Study—A Fuzzy-Genetic Approach with Optimized Interpretability-Accuracy Trade-Off. Appl. Sci. 2021, 11, 5098. [Google Scholar] [CrossRef]
- Vlahogianni, E.I.; Karlaftis, M.G. Advanced computational approaches for predicting tourist arrivals: The case of charter air-travel. In Nonlinear Dynamics; Evans, T., Ed.; IntechOpen: London, UK, 2010; pp. 309–324. [Google Scholar]
- Chow, C.K.W. Customer satisfaction and service quality in the Chinese airline industry. J. Air Transp. Manag. 2014, 35, 102–107. [Google Scholar] [CrossRef]
- Fuchs, M.; Höpken, W.; Lexhagen, M. Big data analytics for knowledge generation in tourism destinations–A case from Sweden. J. Destin. Mark. Manag. 2014, 3, 198–209. [Google Scholar] [CrossRef]
- Kim, K.; Park, O.J.; Yun, S.; Yun, H. What makes tourists feel negatively about tourism destinations? Application of hybrid text mining methodology to smart destination management. Technol. Forecast. Soc. Change 2017, 123, 362–369. [Google Scholar] [CrossRef]
- Sari, E.Y.; Wierfi, A.D.; Setyanto, A. Sentiment Analysis of Customer Satisfaction on Transportation Network Company Using Naive Bayes Classifier. In Proceedings of the 2019 International Conference on Computer Engineering, Network, and Intelligent Multimedia (CENIM), Surabaya, Indonesia, 19–20 November 2019; pp. 1–6. [Google Scholar]
- Hou, Z.; Cui, F.; Meng, Y.; Lian, T.; Yu, C. Opinion mining from online travel reviews: A comparative analysis of Chinese major OTAs using semantic association analysis. Tour. Manag. 2019, 74, 276–289. [Google Scholar] [CrossRef]
- Höpken, W.; Eberle, T.; Fuchs, M.; Lexhagen, M. Improving tourist arrival prediction: A big data and artificial neural network approach. J. Travel Res. 2021, 60, 998–1017. [Google Scholar] [CrossRef]
- Gallego, I.; Font, X. Changes in air passenger demand as a result of the COVID-19 crisis: Using Big Data to inform tourism policy. J. Sustain. Tour. 2021, 29, 1470–1489. [Google Scholar] [CrossRef]
- Amadeus. Defining the Future of Travel through Intelligence; Amadeus IT Group: Madrid, Spain, 2017. [Google Scholar]
- Foster, D. Measuring customer satisfaction in the tourism industry. Qual. Mag. 1999, 8, 23–29. [Google Scholar]
- Volo, S. The experience of emotion: Directions for tourism design. Ann. Tour. Res. 2021, 86, 103097. [Google Scholar] [CrossRef]
- Godovykh, M.; Tasci, A. Customer Experience in Tourism. In Encyclopedia of Tourism Management and Marketing; Edward Elgar Publishing: Cheltenham, UK, 2022; pp. 1–3. [Google Scholar]
- Di Tria, F.; Lefons, E.; Tangorra, F. A Proposal of Methodology for Designing Big Data Warehouses. Preprints 2018, 2018, 2018060219. [Google Scholar]
- Ramos, C.M.Q.; Casado-Molina, A.M.; Ignácio-Peláez, J. An Innovative Management Perspective for Organizations through a Reputation Intelligence Management Model. Int. J. Inf. Syst. Serv. Sect. (IJISSS) 2019, 11, 1–20. [Google Scholar] [CrossRef]
- Ramos, C.M.; Casado-Molina, A.M. Online corporate reputation: A panel data approach and a reputation index proposal applied to the banking sector. J. Bus. Res. 2021, 122, 121–130. [Google Scholar] [CrossRef]
- Erevelles, S.; Fukawa, N.; Swayne, L. Big Data consumer analytics and the transformation of marketing. J. Bus. Res. 2016, 69, 897–904. [Google Scholar] [CrossRef]
- Ayyadevara, V.K. Pro Machine Learning Algorithms; Apress: Berkeley, CA, USA, 2018. [Google Scholar]
- Santos, M.; Azevedo, C. Data Mining; FCA Editora: Lisboa, Portugal, 2005. [Google Scholar]
- Powell, B. Mastering Microsoft Power BI: Expert Techniques for Effective Data Analytics and Business Intelligence; Packt Publishing Ltd.: Birmingham, UK, 2018. [Google Scholar]
- Orange. Orange: Data Mining Fruitful and Fun. 2021. Available online: https://orangedatamining.com/ (accessed on 30 December 2021).
- Hutto, C.; Gilbert, E. Vader: A parsimonious rule-based model for sentiment analysis of social media text. In Proceedings of the International AAAI Conference on Web and Social Media, Ann Arbor, MI, USA, 1–4 June 2014; Volume 8, pp. 216–225. [Google Scholar]
- Buhalis, D.; Volchek, K. Bridging marketing theory and big data analytics: The taxonomy of marketing attribution. Int. J. Inf. Manag. 2021, 56, 102253. [Google Scholar] [CrossRef]
- Senyo, P.K.; Liu, K.; Effah, J. Digital business ecosystem: Literature review and a framework for future research. Int. J. Inf. Manag. 2019, 47, 52–64. [Google Scholar] [CrossRef]
- Alexandru, M.; Dragoș, C.; Bălă-Constantin, Z. Digital Twin for automated guided vehicles fleet management. Procedia Comput. Sci. 2022, 199, 1363–1369. [Google Scholar] [CrossRef]
Variable | Description | Unit |
---|---|---|
FeedbackCourteousArrival | Customer’s opinion about the courtesy felt upon arrival | 5-point scale (1–5) |
FeedbackDrivingArrival | Customer’s opinion about the driver’s driving style on arrival | 5-point scale (1–5) |
FeedbackExperience | Customer’s experience evaluation | 5-point scale (1–5) |
FeedbackPunctualArrival | Customer’s opinion about the punctuality in arrival | 5-point scale (1–5) |
FeedbackWebsite | Customer’s opinion about the functioning of the website when purchasing the service | 5-point scale (1–5) |
FeedbackWelcome | Customer’s opinion about the driver’s welcome | 5-point scale (1–5) |
Km | Number of travelled kilometres | Numerical |
Npax | Number of passengers | Integer (1–8) |
Variable | Description | Unit |
---|---|---|
Country | The customer’s country of origin | Text |
FeedbackComments | Comments made by customers that express an opinion about the experience associated with the service | Text |
Country | Number of Services | Average Number of Passengers | Average of km Travelled | FeedbackExperience Score Average | StdDev of FeedbackExperience Score |
---|---|---|---|---|---|
Czech Republic | 5 | 3.20 | 46.6 | 4.8 | 0.4 |
Estonia | 5 | 4.20 | 43.8 | 5.00 | 0.00 |
Italy | 5 | 3.20 | 33.00 | 5.00 | 0.00 |
Lithuania | 6 | 2.83 | 52.00 | 4.83 | 0.37 |
Romania | 6 | 2.67 | 43.00 | 5.00 | 0.00 |
Austria | 9 | 2.44 | 58.67 | 4.78 | 0.63 |
Poland | 9 | 3.22 | 44.44 | 4.89 | 0.31 |
Spain | 9 | 2.44 | 46.22 | 4.89 | 0.31 |
Denmark | 13 | 2.77 | 46.15 | 4.77 | 0.42 |
Finland | 17 | 3.12 | 53.41 | 4.88 | 0.32 |
Luxembourg | 19 | 2.68 | 36.32 | 4.74 | 0.55 |
Australia | 23 | 2.70 | 61.22 | 4.96 | 0.2 |
Switzerland | 29 | 2.83 | 70.48 | 4.9 | 0.3 |
Sweden | 36 | 2.81 | 63.81 | 4.69 | 0.52 |
Norway | 37 | 2.84 | 55.05 | 4.92 | 0.27 |
Belgium | 51 | 3.08 | 48.55 | 4.84 | 0.36 |
France | 65 | 2.57 | 59.54 | 4.72 | 0.57 |
Germany | 90 | 3.10 | 61.21 | 4.84 | 0.51 |
North America (USA and Canada) | 153 | 2.35 | 56.92 | 4.88 | 0.45 |
The Netherlands | 179 | 2.99 | 50.31 | 4.74 | 0.53 |
Portugal | 308 | 2.2 | 60.04 | 4.79 | 0.56 |
Ireland | 7,168 | 3.37 | 47.77 | 4.87 | 0.48 |
United Kingdom | 21.066 | 3.21 | 48.08 | 4.89 | 0.44 |
Total | 29.308 | 3.23 | 48.31 | 4.88 | 0.45 |
Country | FeedbackExperience Score Average | Number of Services | The Average Number of Passengers | Average of km Travelled | StdDev of FeedbackExperience Score | %Total Customers |
---|---|---|---|---|---|---|
Belgium | 4.84 | 51 | 3.08 | 48.55 | 0.36 | 0.05% |
France | 4.72 | 65 | 2.57 | 59.54 | 0.57 | 0.06% |
Germany | 4.84 | 90 | 3.10 | 61.21 | 0.51 | 0.12% |
Ireland | 4.87 | 7.168 | 3.37 | 47.77 | 0.48 | 70.63% |
The Netherlands | 4.74 | 179 | 2.99 | 50.31 | 0.53 | 0.15% |
North America (USA and Canada) | 4.88 | 153 | 2.35 | 56.92 | 0.45 | 0.00% |
Norway | 4.92 | 37 | 2.84 | 55.05 | 0.27 | 0.05% |
Portugal | 4.79 | 308 | 2.2 | 60.04 | 0.56 | 3.02% |
Sweden | 4.69 | 36 | 2.81 | 63.81 | 0.52 | 0.05% |
United Kingdom | 4.89 | 21.066 | 3.21 | 48.08 | 0.44 | 25.87% |
Total | 4.89 | 29.153 | 3.23 | 48.29 | 0.45 | 100.00% |
Variables | Correlation Value (to the FeedbackExperience) |
---|---|
FeedbackWelcome | +0.534 |
FeedbackDrivingArrival | +0.475 |
FeedbackCourteousArrival | +0.424 |
FeedbackPunctualArrival | +0.381 |
FeedbackWebsite | +0.294 |
Npax | +0.002 |
Km | −0.024 |
Model | MSE | RMSE | MAE | R2 |
---|---|---|---|---|
Linear Regression | 0.120 | 0.347 | 0.122 | 0.403 |
Decision Tree | 0.084 | 0.290 | 0.095 | 0.582 |
Disclaimer/Publisher’s Note: The statements, opinions and data contained in all publications are solely those of the individual author(s) and contributor(s) and not of MDPI and/or the editor(s). MDPI and/or the editor(s) disclaim responsibility for any injury to people or property resulting from any ideas, methods, instructions or products referred to in the content. |
© 2022 by the authors. Licensee MDPI, Basel, Switzerland. This article is an open access article distributed under the terms and conditions of the Creative Commons Attribution (CC BY) license (https://creativecommons.org/licenses/by/4.0/).
Share and Cite
Ramos, C.M.Q.; Cardoso, P.J.S.; Fernandes, H.C.L.; Rodrigues, J.M.F. A Decision-Support System to Analyse Customer Satisfaction Applied to a Tourism Transport Service. Multimodal Technol. Interact. 2023, 7, 5. https://doi.org/10.3390/mti7010005
Ramos CMQ, Cardoso PJS, Fernandes HCL, Rodrigues JMF. A Decision-Support System to Analyse Customer Satisfaction Applied to a Tourism Transport Service. Multimodal Technologies and Interaction. 2023; 7(1):5. https://doi.org/10.3390/mti7010005
Chicago/Turabian StyleRamos, Célia M. Q., Pedro J. S. Cardoso, Hortênsio C. L. Fernandes, and João M. F. Rodrigues. 2023. "A Decision-Support System to Analyse Customer Satisfaction Applied to a Tourism Transport Service" Multimodal Technologies and Interaction 7, no. 1: 5. https://doi.org/10.3390/mti7010005
APA StyleRamos, C. M. Q., Cardoso, P. J. S., Fernandes, H. C. L., & Rodrigues, J. M. F. (2023). A Decision-Support System to Analyse Customer Satisfaction Applied to a Tourism Transport Service. Multimodal Technologies and Interaction, 7(1), 5. https://doi.org/10.3390/mti7010005