Analytics for Twitter is an useful freeware add-in based on PowerPivot and allows users to search Twitter and create dashboard views on Tweet statistics inside Excel 2010.  Users can use any combination of search terms, including #hashtags, @mentions, @users, and keywords to search Twitter using their documented APIs, perform comparative analysis on tweets, as well as depict the tone of the tweets using a customizable tone dictionary of terms.  The workbook comes with several sheets that provide insights into the query terms.

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).
• Setup Tone Dictionary

Analytics for Twitter works only with the latest versions of Microsoft Excel 2010 and of Microsoft® PowerPivot for Excel 2010.