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.

Microsoft Analytics for Twitter – Powered by PowerPivot for Excel image image thumb41

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.

Microsoft Analytics for Twitter – Powered by PowerPivot for Excel image image thumb51

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 Growth Hacking: Gaining Early Traction by Doing Things that Don't Scale

Microsoft Analytics for Twitter – Powered by PowerPivot for Excel image image thumb61

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.

Discuss This Article

Comments: 1

Add a New Comment

Thank you for adding to the conversation!

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