Google Fusion Table & Data Visualization

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:
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! :)


About Parth Acharya
Data Analyst | Social Media Evangelist | Film Maker

10 Responses to Google Fusion Table & Data Visualization

  1. 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

  2. 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

  3. Paras Doshi says:

    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!

      • Paras Doshi says:

        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..

  4. Pingback: Mapping “Facebook Page Likes vs Country” using PowerView in Office 2013 | Paras Doshi – Blog

  5. Pingback: Seven Interesting Google Projects that a Data Professional may not have heard about: | Paras Doshi – Blog

  6. Pingback: Microsoft Excel Add-in: GeoFlow… and Data Visualization | Parth Acharya - Blog

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: