Brand New Excel Add-in: Data Explorer (And How to: Social Media Analytics)
April 13, 2013 7 Comments
This blog is about a new excel Add-in Microsoft introduced in PASS Business Analytics Conference 2013 this week.
We will go through the general introduction of this add-in and then, we will see how it can be used for Social Media Analytics.
First part of the add-in is ‘Get External Data’. As the picture above depicts, there are four sources you can fetch data from using this add-in:
Being a Social Analytics enthusiast, the first thing that caught my attention was nothing but ‘Import data from Facebook‘!
For next few hours, I played with ‘Data Explorer’ on Social Media front and the results were mind blowing!
Fundamentally, this add-in uses Facebook Graph API to fetch data for you and it starts with asking for your Facebook credentials.
Signing in will lead you to ‘Microsoft Data Explorer’ Facebook application; it will ask you to grant access for the application to fetch data for you.
Hit the ‘save’ button and you are all set for data exploration with this awesome add-in.
I started with fetching data from my own Facebook profile. By default, for Graph API, my username would be ‘me’. Here is a snapshot of my first query. I asked “Data Explorer” to fetch dataset containing all the movies I have ‘liked’ on Facebook.
Hitting the OK button, you will get a Facebook Graph Query window like this:
Hit the ‘Done’ button and you will get all your data loaded in an excel worksheet.
(You can fetch the same kind of data about your friends ‘likes’ using your friends’ user name or object id in the query)
Now, at this point- I thought all I can get is data from my own profile, my friends’ profile or from Facebook pages I manage.
Here is something I tried doing and the results amazed me!!
I tried to fetch the Post level data of Starbucks Facebook Page (which is not an easy task to carry out without having admin rights of Starbucks Facebook Page, in my view). This add-in made this task a piece of cake!
Hitting the OK and Done button, I confirmed the query and this is what I got:
Incredible, isn’t it?
Further, I tried to see if I can get the Fan feed.
To my surprise, the next thing I saw was this!
Now, here is something I noticed that was beyond incredible for me! The feeds I was going to load by hitting the ‘done’ button were more in numbers than what I could see on Starbucks Facebook Page. Guess what! I could see the negative feeds posted by Starbucks Fans which Starbucks chose to hide from their page!
In a few minutes, Data Explorer fetched more than 12,000 rows of Starbucks Facebook Page feed for me!
‘Data Explorer’ also provides you with a ‘Refresh’ button which fetches the latest data for the same query with just a single click!
On the same panel, one can also merge or append multiple queries.
In other functions, there is a ‘Design’ option available under the same ‘Table Tools’ segment.
So, with this blog we saw how powerful this add-in can be! One of the most difficult parts is getting the data from a Facebook Page (especially when you don’t own it), but this add-in makes Data Collection so easy that anybody can do it.
Now, what can we do with the data? A lot many things! If I want to analyse how my business is doing on Facebook, I can do it with this add in. Once I get the data, I can run sentiment analysis and see how things are going for me. At the same time, I can also do competitive analysis by getting data from my competitor brand’s Facebook page. If I have a Facebook Profile for my business (and not a Facebook Page), I would be able to get a valuable set of data about my brand’s friends (not fans) with this add-in.
One may not have the capability to fetch statistical data (Likes, Reach, Talking about) from a Facebook Page with ‘Data Explorer’, but all the interactions and post level data (Post type, Post time and Date, Comments etc.) are just a few clicks away!
Please drop a comment on what you think about this add-in or how it may help you / your organization to do Social Media Analytics. I would be more than happy to explore all possible use cases.
DIY: Analytics Driven Social Media (Facebook) [Parth Acharya - Blog]
Six Social Media Analytics Technologies You Should Know About [Parth Acharya - Blog]
Social media and customer dialog management at Starbucks [Parth Acharya - Blog]
I would end this post by thanking Paras Doshi who blogged about his first day at the PASS Business Analytics Conference 2013 in which this add-in was mentioned.