Google Fusion CA 1 Data Management & Analytics

Question 1:

A) A chart that breaks down population by Gender

Image 1

B) A chart/table that shows population by province

Image 2

C) Use a pivot table to find out what % of the population does each county account for in 2011.

Row Labels Sum of Total Persons percentage
Carlow 54612 1.190257205
Cavan 73183 1.595008295
Clare 117196 2.554262495
Cork 519032 11.31219471
Donegal 161137 3.511947469
Dublin 1273069 27.74627462
Galway 250653 5.462930109
Kerry 145502 3.17118589
Kildare 210312 4.583706388
Kilkenny 95419 2.0796373
Laois 80559 1.755766684
Leitrim 31798 0.69303081
Limerick 191809 4.180437343
Longford 39000 0.849996905
Louth 122897 2.678514606
Mayo 130638 2.847228095
Meath 184135 4.013184106
Monaghan 60483 1.318214431
Offaly 76687 1.671377248
Roscommon 64065 1.396283378
Sligo 65393 1.425226862
Tipp 158754 3.460010479
Waterford 113795 2.480138406
Westmeath 86164 1.877926496
Wexford 145320 3.167219237
Wicklow 136640 2.978040439
Grand Total 4588252  

 

 

Question 2:

Image 1

Map 1

Image 2

Map 2

Image 3

Map 3

 

Question 3:

As part of our assignment on the Irish Census Data for 2011, we were ask to use Google’s Fusion Tables to create a Heat map, this was done by cleansing the data file provided, extracting the information that was required for the Heatmap.  I didn’t have a Gmail account set up, so the first step was to create an account, one set up, I logged into Google Drive & selected Fusion Tables.  The first file I loaded was the clean map KML file which was uploaded to Moodle, I repeated the same steps to load the cleansed census data I had manipulated. Once loaded, selected File, Merge from the dropdown.

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.

Next a pop up appeared to select the columns to be used on the heat map, I deselected males, females & description & hit view table.

Once I navigated to the map of geometry tab, my first map appeared- as shown above ref: Image 1.

When feature map was selected the map appears as shown in image 2.

Fusion Tables allows you to present your data in a visual, interactive way. This data was collated after importing into fusion table and merged on the County attribute to obtain the total population and male and female population heat maps as required.

The map aims to reflect the population data from the 26 counties in ROI.

The benefits of data visualization to a business/decision maker are to collate & understand the data more easily. In addition it helps to determine & spot patterns & trends in business operations.

It is quite apparent from the image 3 that within the heat map, Dublin & Cork are jumping out above the other 24 counties, for a business this information helps, decision makers identify to abnormalities or highlights immediately. In this case Both Dublin & Cork are the most densely populated counties, & visual synopsis’s such as this would can prove to be very useful for fast moving businesses who need to spot trends & risks as quickly as possible.

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *