Holiday Toys for Children's Hospital A.I. DuPont: The Spirit of Giving – Learn More ›
Popular Today in Social: All Popular Articles

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.

Related Resources from B2C
» Free Webcast: How to Create Killer Email Conversion Copy

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.

Comments on this Article: 1

Add a Comment
  1. Adrian says:

    Only the “summary” and “people” tabs are working. How can I get the “details” tab to work too?

Add a Comment:


Thank you for adding to the conversation!

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