{"id":12481,"date":"2024-08-30T18:59:23","date_gmt":"2024-08-30T10:59:23","guid":{"rendered":"https:\/\/www.utm.edu.mo\/NewsPortal\/?p=12481"},"modified":"2024-08-30T19:11:07","modified_gmt":"2024-08-30T11:11:07","slug":"visualising-tourist-data-with-tableau-public","status":"publish","type":"post","link":"https:\/\/www.utm.edu.mo\/NewsPortal\/visualising-tourist-data-with-tableau-public\/","title":{"rendered":"Visualising tourist data with Tableau Public"},"content":{"rendered":"<span class='pum-trigger  popmake-12488  text-center font-blue' data-do-default=''>\u4e2d\u6587\u6458\u8981 \/ Summary in Chinese<\/span>\n\n\n\n<h5 class=\"wp-block-heading\"><em><em><em><em><em>In this feature, UTM Lecturer Mr. Ford Lei discusses the use of free interactive data visualisation platform Tableau Public to transform raw data into insights with practical applications<\/em><\/em><\/em><\/em><\/em><\/h5>\n\n\n\n<p><\/p>\n\n\n\n<p>As one of the most popular, online-based, visual analytics platforms, Tableau Public makes possible the visualisation of raw data by individuals and corporations. Students and researchers in the tourism field should take advantage of tourist-data visualisation techniques to gain a deeper understanding of various tourist markets.<\/p>\n\n\n\n<p><a href=\"https:\/\/public.tableau.com\/views\/ChinesetouriststoMacau2011-2022\/Dashboard1?:language=en-US&amp;:display_count=n&amp;:origin=viz_share_link\" target=\"_blank\" rel=\"noreferrer noopener\">This Tableau Public project<\/a>\u00a0visualises a dataset from the\u00a0<a href=\"https:\/\/www.dsec.gov.mo\/en-US\/Statistic\/Database\" target=\"_blank\" rel=\"noreferrer noopener\">Macao Statistics and Census Service (DSEC)<\/a>\u00a0in order to illustrate data on visitors coming from different regions of Mainland China to Macao between 2011 and 2022.<\/p>\n\n\n\n<p><strong>Why this dataset and why is it important?<\/strong><\/p>\n\n\n\n<p>There is a need for Macao\u2019s tourism sector to have easy access to this dataset, as tourists from Mainland China make up the largest portion of the visitor market. A more detailed understanding of this segment might be gained by looking at data on tourists from the various regions within Mainland China.<\/p>\n\n\n\n<p><strong>Reasons for using different kinds of graphs to visualise the data.<\/strong><\/p>\n\n\n\n<p>First, I used a line chart to visualise a time series dataset so that I could easily see the trend of tourists from different regions each year (see Figure 1). The purpose of this visualisation is to allow me to compare data on different regions in a time series or examine the performance of each region on its own.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"478\" src=\"https:\/\/www.utm.edu.mo\/NewsPortal\/wp-content\/uploads\/2024\/08\/Figure-1.jpg\" alt=\"\" class=\"wp-image-12483\" srcset=\"https:\/\/www.utm.edu.mo\/NewsPortal\/wp-content\/uploads\/2024\/08\/Figure-1.jpg 940w, https:\/\/www.utm.edu.mo\/NewsPortal\/wp-content\/uploads\/2024\/08\/Figure-1-300x153.jpg 300w, https:\/\/www.utm.edu.mo\/NewsPortal\/wp-content\/uploads\/2024\/08\/Figure-1-768x391.jpg 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/figure><\/div>\n\n\n<p class=\"has-text-align-center\"><em><strong>Figure 1. <\/strong>Line chart<\/em><br>Data source: Macao Statistics and Census Service (DSEC)<p class=\"MsoNormal\" style=\"margin: 0cm; line-height: normal; font-size: 11pt; font-family: Calibri, sans-serif; caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); text-align: start; white-space: normal;\"><span lang=\"EN-GB\" style=\"font-size: 12pt; font-family: Verdana, sans-serif;\"><\/span><\/p><span style=\"caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: -webkit-standard; font-size: medium; text-align: start; white-space: normal;\"><\/span><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>As a second step, I used a bar chart to visualise the weighting of different regions within the Mainland China segment in a series of different years, based on the percentages for each region (see Figure 2). Using this example, I am able to see the percentage of tourists visiting Macao from different regions of Mainland China in a given year.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"399\" height=\"375\" src=\"https:\/\/www.utm.edu.mo\/NewsPortal\/wp-content\/uploads\/2024\/08\/Figure-3.jpg\" alt=\"\" class=\"wp-image-12485\" srcset=\"https:\/\/www.utm.edu.mo\/NewsPortal\/wp-content\/uploads\/2024\/08\/Figure-3.jpg 399w, https:\/\/www.utm.edu.mo\/NewsPortal\/wp-content\/uploads\/2024\/08\/Figure-3-300x282.jpg 300w\" sizes=\"auto, (max-width: 399px) 100vw, 399px\" \/><\/figure><\/div>\n\n\n<p class=\"has-text-align-center\"><em><strong>Figure 2. <\/strong>Bar chart<\/em><br>Data source: Macao Statistics and Census Service (DSEC)<p class=\"MsoNormal\" style=\"margin: 0cm; line-height: normal; font-size: 11pt; font-family: Calibri, sans-serif; caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); text-align: start; white-space: normal;\"><span lang=\"EN-GB\" style=\"font-size: 12pt; font-family: Verdana, sans-serif;\"><\/span><\/p><span style=\"caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: -webkit-standard; font-size: medium; text-align: start; white-space: normal;\"><\/span><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Lastly, I have plotted the distribution of the total number of tourists from different Mainland China regions from 2011 to 2022 in the table graphic below (see Figure 3). Here, I can see at a glance the market share of each region and compare it with the total number of tourists, within the 12-year period ended 2022.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"399\" height=\"302\" src=\"https:\/\/www.utm.edu.mo\/NewsPortal\/wp-content\/uploads\/2024\/08\/Figure-2.jpg\" alt=\"\" class=\"wp-image-12484\" srcset=\"https:\/\/www.utm.edu.mo\/NewsPortal\/wp-content\/uploads\/2024\/08\/Figure-2.jpg 399w, https:\/\/www.utm.edu.mo\/NewsPortal\/wp-content\/uploads\/2024\/08\/Figure-2-300x227.jpg 300w, https:\/\/www.utm.edu.mo\/NewsPortal\/wp-content\/uploads\/2024\/08\/Figure-2-74x55.jpg 74w, https:\/\/www.utm.edu.mo\/NewsPortal\/wp-content\/uploads\/2024\/08\/Figure-2-111x83.jpg 111w\" sizes=\"auto, (max-width: 399px) 100vw, 399px\" \/><\/figure><\/div>\n\n\n<p class=\"has-text-align-center\"><em><strong>Figure 3. <\/strong>Table graphic<\/em><br>Data source: Macao Statistics and Census Service (DSEC)<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"has-text-align-left\">To conclude, in order to visualise the data of visitors coming from different regions of Mainland China to Macao between 2011 and 2022, I have used three types of graphs. With the assistance of Tableau Public, we are able to see the trends of tourists coming from different regions each year. Additionally, we can see how many tourists visit Macao from different regions each year and the percentage of each region&#8217;s market share in Macao.<p class=\"MsoNormal\" style=\"margin: 0cm; line-height: normal; font-size: 11pt; font-family: Calibri, sans-serif; caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); text-align: start; white-space: normal;\"><span lang=\"EN-GB\" style=\"font-size: 12pt; font-family: Verdana, sans-serif;\"><\/span><\/p><span style=\"caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: -webkit-standard; font-size: medium; text-align: start; white-space: normal;\"><\/span><\/p>\n\n\n\n<p><em>By UTM Lecturer Mr. Ford Lei Chong Fo, Faculty of Creative Tourism and Intelligent Technologies<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this feature, UTM Lecturer Mr. Ford Lei discusses the use of free interactive data visualisation platform Tableau Public to transform raw data into insights with practical applications As one [&hellip;]<\/p>\n","protected":false},"author":18,"featured_media":12486,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2255],"tags":[2497,1373,1992,2756,400,2861,3225,402,2859,3226],"class_list":["post-12481","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tech","tag-data-visualisation","tag-ford-lei","tag-information-technology","tag-lei-chong-fo","tag-macao","tag-macao-university-of-tourism","tag-tableau-public","tag-tourism","tag-utm","tag-visual-analytics"],"views":572,"_links":{"self":[{"href":"https:\/\/www.utm.edu.mo\/NewsPortal\/wp-json\/wp\/v2\/posts\/12481","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.utm.edu.mo\/NewsPortal\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.utm.edu.mo\/NewsPortal\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.utm.edu.mo\/NewsPortal\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.utm.edu.mo\/NewsPortal\/wp-json\/wp\/v2\/comments?post=12481"}],"version-history":[{"count":6,"href":"https:\/\/www.utm.edu.mo\/NewsPortal\/wp-json\/wp\/v2\/posts\/12481\/revisions"}],"predecessor-version":[{"id":12495,"href":"https:\/\/www.utm.edu.mo\/NewsPortal\/wp-json\/wp\/v2\/posts\/12481\/revisions\/12495"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.utm.edu.mo\/NewsPortal\/wp-json\/wp\/v2\/media\/12486"}],"wp:attachment":[{"href":"https:\/\/www.utm.edu.mo\/NewsPortal\/wp-json\/wp\/v2\/media?parent=12481"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.utm.edu.mo\/NewsPortal\/wp-json\/wp\/v2\/categories?post=12481"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.utm.edu.mo\/NewsPortal\/wp-json\/wp\/v2\/tags?post=12481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}