Hello everybody, here we are, the first post on my blog! Data management that talks to you? Don’t be afraid is not boring as it looks like, it’s even super interesting if you go deeper into the subject.
Be ready, today we gonna use Google fusion table and I’ll show you how to create your own interactive map.
Let ‘s start with Ireland and see how this small, friendly and proud population is allocated on these 26 fabulous Irish counties.
First step, you need to gather the data about Irish population and its repartition.
You can find it on this 2 links below:
- Irish County 2011 Population:
- Irish KMZ Datafile:
Open the first link, and copy the data in excel, next you absolutely need to add up the population of North Tipperary and South Tipperary. Don’t forget to checkpoint and comma between the population number and rectify it, if necessary, personally, I had to change some point in a comma.
Second step, normally you have two files in fusion table, our goal is to get only one. How do you do it? No worry it’s very easy, you merge the files!
Third step, I swear the most important is already behind us, go in map geometry and look your map. Yes, we did it, but honestly it’s not very attractive and clear. It’s good to have data but you need to present them well, in order to get clearly the result and facilitate the interpretation. If you don’t analyse your data, close my blog and watch a tv show it will be more useful.
Let’s try to make this map more attractive. So, we have to change the map feature style in the polygons category, you click on, fill colour and next you want your map according to the total number of persons, do it. Finally you chose your colour, I put red for the counties most populated, and a scale of green (colour of Ireland) for the rest. Now, look your map it’s clear, you can distinguish the difference between each county.
What do we see? Irish people are concentrate in three counties, Dublin, Galway and Cork. The rest of the country is really less populated. Ireland is still wild, the most of it is country side. Obviously, the population it’s concentrated where there are urban areas. Often providing more universities, facilities and opportunities. We can also deduct that there is a potential non-exploited, and the government should focus also on developing these other regions to attract people.
Now, we get this information and know how to present it with a spark of imagination and ambition, we could accomplish incredible things. Think about it, with new data like politics choice in according to the different counties, we could make correlations. Better, we had the data of people who went to university to understand their vote. We could see the proportion of youngers in each county, the integration in the job market, where are the best opportunities, where is the best purchasing power and make correlations analysing this data. Let’s see the consumption of alcohol in each different county.
In conclusion, thanks to the data we don’t only show where there is a problem but also the correlations and analysis will give us the right way to fix it.
It’s important to be aware that data can be use to influence and manipulate people, but also to find a correlation in order to improve our society. Big Data cancel the notion of subjectivity, data are real, correlation can be subjective if you don’t consider all factors. But the main goal is to find the truth, beautiful and dangerous at the same time. This little exercise was a perfect introduction, we will go deeper in the subject taking in consideration more data.
Ps: don’t forget to share my blog if you want to learn technical things with a smooth approach.