A) A chart that breaks down population by Gender
B) A chart/table that shows population by province
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|
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.