Microsoft Analytics für Twitter verfügbar

Microsoft Analytics für Twitter verfügbar [Excel 2010 Add-In]

Microsoft stellt im Microsoft Download Center ein neues Add-in namens Microsoft Analytics für Twitter für Microsoft Excel 2010 zum kostenlosen Download zur Verfügung. Microsoft Analytics für Twitter funktioniert nur dann, wenn auf eurem Computer die neuesten Versionen von Microsoft Excel 2010 und Microsoft Excel 2010 für PowerPivot ausgeführt werden.

Microsoft Analytics for Twitter allows users to search Twitter and create dashboard views on Tweet statistics inside Excel 2010 with PowerPivot. 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.

Microsoft Analytics für Twitter Add-In ist zur Zeit nur auf Englisch erhältlich, aber auch für deutsche Microsoft Excel 2010 Nutzer leicht verständlich.

Microsoft Analytics für Twitter Dashboard

Microsoft Analytics for Twitter Dashboard

Microsoft Analytics für Twitter herunterladen

Microsoft Analytics for Twitter steht auf der folgenden Microsoft-Website zum kostenlosen Download zur Verfügung:

Microsoft Analytics for Twitter Overview [Englisch]

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

Microsoft Analytics for Twitter System Requirements

  • Windows 7 Professional and Windows 7 Enterprise.
  • Microsoft® Excel 2010.
  • Microsoft® PowerPivot for Excel 2010.

Microsoft Analytics for Twitter Instructions

Perform Twitter Search

  1. Open the "Microsoft Analytics for Twitter.xlsx" file on your desktop.
  2. 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.
  3. Click the search icon to retrieve Twitter search queries.
  4. Wait for the "Twitter Search Complete" message box.
  5. Click OK.
  6. 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.
  7. Click OK.

Refresh the data

  1. On the PowerPivot tab in Excel, click "Update All".
  2. Wait until PowerPivot Window has refreshed.
  3. Close or minimize the PowerPivot Window.
  4. On the Data tab in Excel click "Refresh All".

Tone Dictionary

The Tone Score is calculated based off of the user defined tone dictionary. This dictionary maps keywords to a tone index which is a sliding scale from very positive to very negative. Users can modify the dictionary to meet the needs of their specific search topic.

  1. On the Tone Dictionary worksheet in Excel, modify the dictionary terms in the right hand column.
  2. Repeat Perform Twitter Search and Refresh Data steps. The Tone Score is calculated as part of the search query process, thus in order to capture dictionary updates the search must be performed after tone dictionary updates.

Search Query Syntax

Microsoft Analytics for Twitter has been designed to support up to 5 concurrent search queries on #hashtags, @mentions, keywords and Tweeters. The search operators' syntax follows Twitter Search syntax see The following examples outline several sample search scenarios.

Searching Hashtags

  • #microsoft, #msbi, #sql, #sqlserver, #powerpivot
  • #microsoft AND #bi, #sql OR #sqlserver

Searching Mentions

  • @microsoft, @microsoftbi, @powerpivot
  • @microsoft AND @bi, @sql OR @sqlserver

Searching Keywords (i.e. freeform text search)

  • microsoft, powerpivot, excel
  • excel AND bi, powerpivot or sql


  • from:MicrosoftBITV, from:MicrosoftBI
  • from:MicrosoftBITV OR from:MicrosoftBI

Combo Search

  • #msbi, @microsoftbi, MicrosoftBI, from:MicrosoftBI
  • #msbi AND @microsoftbi, MicrosoftBI OR from:MicrosoftBI


  • Twitter search queries are limited to the past 4 - 7 days and a maximum of 1500 tweets per day.
Kommentare sind geschlossen
Copyright © 2016 Valdet Beqiraj