GOOGLE FUSION TABLE

 

This blog post is about fusion tables and the 2011 Irish census and how the data can be visualized using Google Fusion Table and Microsoft.

A link to the KML file with the county coordinates was given by our lecturer and the population from 2011 census was gotten from the Central Statistics Office (CSO.ie).

Even though, new research didn’t have to be conducted, and before I could proceed with merging the file, the data had to be cleaned

I updated the county column on both files to ensure they had the same naming convention, once completed I used this column to merge the data together.

 

Step 1 – Log in to Google Drive

Step 2 – Select Google Fusion – Add New File

FT1

This was the first picture of the geometry after merging both files.

It was re-focused and then I got this.

FT2

To change and differentiate the counties, the range and colours are changed by going into Tools – Fill Colour, I then put in the range I wanted and colours.

FT3 

Here is the result.

FT4

Represented in the column chart is the sum of persons in each county.

FT5

 

FT6

The map aims to reflect the population data from the 26 counties in Republic of Ireland.

Some of the benefits of data visualization to a business/decision maker is:

  • To collate & understand the data more easily.
  • Determine & spot patterns & trends in business operations.

From the heatmap above, it’s obvious that Dublin & Cork are growing faster ahead of the other counties. A business or company can use these trends to their advantage by making important decisions to grow the business.

Both Cork and Dublin seems the most densely populated counties, and this visual representation can prove to be very useful for fast moving businesses who needs to quickly identify trends and risks involved as quickly as possible. Either to establish new businesses, move existing business or close the business.