Analyzing Inbound tourism is essential for the Retail, Travel and Hospitality Industries for better understanding tourism flows and creating marketing strategies for specific countries.

I found the raw data for this in spreadsheet format from the UNData site at http://bit.ly/1jT7b7H

image

The spreadsheet download from UNData isn't in a format that supports analysis, so the next step was really to use Power Query and convert it to a tabular format suitable for Data Analysis:

image

The first step that I did was format the data as a table with headers. I also noticed that each country had multiple rows associated with it showing Arrivals, Departures and other data. I used the FIll Down option in Power Query to fill this and associate each line with a country

image

image

I did some cleansing of the data using Power Query and then also did an UnPivot operation on it so that I could look at information on any country for any year:

image

The resulting table had a code for every country and I wanted a mapping of the code to the country name. To do this, I used Power Query again to create a new table with just the code and associated country name.

The first step was to Fill Down the codes :

image

And then Remove all the additional columns and leave only the Code and Country columns:

image

Once this was done, the next step was to filter out the rows that had metrics and leave behind only the Country names:

image

And finally establish a link between the two tables using PowerPivot:

image

Here is an interactive visualization with the Data. You can use the filters to filter out years and country:

Here is a link to a full screen visualization: http://bit.ly/1omSTPX