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.

Recommended for YouWebcast: The Art of Community Development: Turning Brand Awareness Into Sales


The People Tab

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

Comments: 1

Add a New Comment

Thank you for adding to the conversation!

Our comments are moderated. Your comment may not appear immediately.