Visualize Country and Region Reference Data using Google Fusion Tables

In an earlier blog post, I wrote about how to get a list of all countries and regions reference data from Azure Data Market. In this post, let’s import it as a Google Fusion Table and visualize it on a map.

Start by creating a Fusion Table Project and import the Country and Region Spreadsheet.

Create a Fusion Table:

image

You can create a view just displaying the key fields:

image

Check out the view:

https://www.google.com/fusiontables/DataSource?docid=1zXdF9UTurxhuadY4UT5l8YVR2ADcwpaa8Y_JIn0

Now go to Visualize>Map

image

You can also customize the map:

image

Result: Smile

image