Get Twitter statistics within Excel
Microsoft Analytics for Twitter allows users to query Twitter (i.e. Tweeters, #hashtags, @mentions & keywords) and get dashboard views on Twitter statistics inside Microsoft Office Excel 2010.In other words, users will get an Excel-integrated tool for analyzing tweet statistics within a familiar environment.With this 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).How to Perform Twitter Search:· Open the "Microsoft Analytics for Twitter.xlsx" file on your desktop.· Enter a maximum of 5 comma delimited search queries in the search pane located at the top of the "Topics", "People", "Tone" or "Details" worksheets. See the Twitter Search Syntax section for more information on the search syntax. You only need to enter your search term once to populate all the worksheets. For your convenience, the search pane is located at the top of each sheet.· Click the search icon to retrieve Twitter search queries.· Wait for the "Twitter Search Complete" message box.· Click OK.· Wait for the "Next Steps" message box. If a "Twitter Search Query Clipped" message box precedes this message, note the message and consider refining the affected search query.· Click OK. Requirements:
· Microsoft Office Excel 2010.
· Microsoft PowerPivot for Excel 2010.
· Minimum of 2 GB of RAM
· 5MB of available hard disk space