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