Seven Interesting Google Projects that a Data Professional may not have heard about:

Standard

Here’s the list:

1. Google Refine

2. Google Prediction API

3. Google Trends

4. Google Chart Tools

5. Google Big Query

6. Google Correlate

7. Google Fusion Tables

Note: These projects may not be ready to be used in your production environment as some of them are in Beta/Experimental stages and their support/development may be deprecated in future.

Thanks: I thought of writing this blog post after a discussion I had with Parth Acharya about Google and it’s projects for Data Professionals. He pointed me to some of the most interesting samples that used Google Fusion Tables and here’s his one of the blog post on related topic: Google Fusion Table & Data Visualization

Mapping “Facebook Page Likes vs Country” using PowerView in Office 2013

Standard

Just a quick note that you can quickly create maps in PowerView in office 2013. I just created one in 2 minutes:

Facebook Page likes VS Country

This seems like a great way to visualize where your fans are from. In my case, most of them are from India and so one actionable insight would be to schedule posts based on Time Zone in India. And I can imagine that such reports could be very helpful to brands who have sizable fan following on Facebook.

Here’s the screenshot:

Maps Power View Excel 2013 social media analytics
Thanks to the following blog-posts for inspiration:

1. Google Fusion Table & Data Visualization (He used Google Fusion Tables, I used PowerView!)

2. Creating Maps in Excel 2013 using Power View