Friday, June 10, 2011

Query Twitter directly in Excel 2010 with Microsoft Analytics for Twitter

Microsoft Analytics for Twitter allows users to search Twitter and get dashboard views on Tweet statistics inside Microsoft® Office Excel 2010.

With this FREE add-in, you can:

  • Perform up to 5 parallel Twitter Searches (limited to 1500 results per query per day).
  • Drive ad-hoc analysis of tweets by day, by hour, by tweeters, by #hashtags and @mentions.
  • Customize your views (using slicers, DAX formulas or reference tables).

exceltwitter3z

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

Works only with the latest versions of Microsoft Excel 2010 and requires Microsoft PowerPivot for Excel 2010.

 

Download Microsoft Analytics for Twitter

No comments: