Microsoft partners Extended Results have done it again. They have released another great PowerPivot based Analytics tool – this time for analysing Twitter feeds. The first was a calendar based analytics tools which allowed you to analyse how you and/or your team spend time based on your calendar events in Microsoft Exchange.
Analytics for Twitter allows users to query Twitter directly in Microsoft® Office Excel 2010. Utilizing the free PowerPivot Excel Add-in users can perform their own analysis such as who are the top Tweeters, what #hashtags are they using and do they have a positive or negative tweet tone. Sample code, used to create this application, is included as a sample and how-to.
Analytics for Twitter link : http://www.microsoft.com/download/en/details.aspx?id=26213
Analytics of your Exchange Calendar: http://www.microsoft.com/download/en/details.aspx?id=20898