Google Fusion Table & Data Visualization
October 25, 2012 10 Comments
Few days back, one of my Facebook Page got its 100th like and I could see that the likers are from all different countries around the world. And I thought wouldn’t it be great if I can put them all on the map?
That was when I got to know the power of Google Fusion Table for Data visualization.
So, this is what I did and I loved the outcome presented by Google!!
1. The page is about the people of sun sign Libra (created with a vision to get all the Librans on Facebook together!!) and due to the openness of the subject the page was built on- it could attract people from different parts of the world.
2. With Facebook insights, I could get the data about people and their respective nationalities.
3. Now it was Google’s turn to show its magic!
3.1 Go to Google Docs, click on ‘Create’ and in the more section go for ‘Fusion Table’
3.2 Select the spreadsheet you want to visualize on map.
> In our case, I just created a spreadsheet with two columns, one for number of people and second for their Country.
3.3 Click on new tab ‘+’ button and select ‘add map’
4. That’s it! Google will do its job and you’ll have all your data about people and their country visualized! It also works on the bases of longitude-latitude! And apart from that, there are many things you can try to make it look cool. Also, you can share, publish and embed your visualized data!
5. Below is the image of 100 awesome Librans I mapped using this feature! :)
And here’s the link to the map: http://goo.gl/YoqTs
Have a great day! And please drop a comment if you too have played with Fusion Table, I’d be very happy to learn new things! :)
That is very fascinating, You are an excessively skilled blogger. I’ve joined your rss feed and look forward to searching for extra of your great post. Also, I have shared your web site in my social networks
Thank you! I look forward to your views on my future posts.
Great beat ! I wish to apprentice while you amend your site, how can i subscribe for a blog web site? The account helped me a appropriate deal. I had been a little bit acquainted of this your broadcast provided bright clear concept
Great to know you liked the post! You can click on the rss button ‘Posts’ and register for a live feed.
This is awesome! Is there a way to show it via a Bubble (instead of a pin)? The benefit being that the size of bubble could represent the number of people from that region? Just a thought.
Yes, we can have bubbles- but value based dimensions are not offered as a feature yet. Though I think it would be really cool to have something like that.
For example. if I want to map airlines data with this feature. In this case, it would be great if I can map cities with higher frequency of flights with larger bubbles!
Yes, that’s a nice use case too! Let me try with something called “Powerview” in excel 2013 – such a visualization should be supported by PowerView..
Pingback: Mapping “Facebook Page Likes vs Country” using PowerView in Office 2013 | Paras Doshi – Blog
Pingback: Seven Interesting Google Projects that a Data Professional may not have heard about: | Paras Doshi – Blog
Pingback: Microsoft Excel Add-in: GeoFlow… and Data Visualization | Parth Acharya - Blog