Home > Uncategorized > Excel Analytics for Twitter

Excel Analytics for Twitter


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

 

• Topics sheet – based on your query, identify key topics and mentions, frequency of tweets by time of day, and top tweeters.

• People – who are the positive and negative tweeters, top tweeters by day and mentions.

• Tone – using the custom tone dictionary, identify negative, neutral and positive tweets; visualize tone by day and top tweeters by tone.

• Details – dive into every tweet, filtering on key items. 

• Tone Dictionary – customize your own words to determine positive, negative, or neutral tone.  It’s fast and easy.”

 

image

 

Download the .exe Excel add-in at http://www.microsoft.com/download/en/details.aspx?id=26213

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: