Microsoft Analytics for Twitter – Powered by PowerPivot for Excel

Microsoft just released a tool which enables you to you to analyse Twitter data from within Excel.  You can search up to 5 items and it populates the workbook with information on Topics, People, Tone, and lists all the tweets that are brought back. What is amazing is that they’ve included the source code too.


Tone Edit

Most online analytics tool kind of hide from you how they’re judging sentiment of tweets. However, here you’re provided with a Tone Dictionary which you can edit.


Slice and Dice data the way you want

Since it’s PowerPivot and Excel goodness you can easily slice and dice the data the way you want to view it. The details tab lets you dive in.


The People Tab

SNAGHTML627ea2It shows you who is speaking positively or negatively about the search items and also tells you who is helping you spread the word by tweeting and re-tweeting your message.





You have the Source


Finally the key bits of code used to create the Excel workbook are also included.

A big thumbs up to the team for delivering this.


About sanjayshetty

Sanjay Shetty is currently putting the finishing touches on his book, the Brand Advocacy quick start guide, which covers his framework for building a brand advocacy program. He blogs at
This entry was posted in Microsoft Excel and tagged , , . Bookmark the permalink.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s