Sunday, March 04, 2012

Windows 8 Preview Engagement and Sentiment Analysis with Microsoft Codename “Social Analytics”

The VancouverWindows8 data set created by the Codename “Social Analytics” team and used by my Microsoft Codename “Social Analytics” Windows Form Client demo application is ideal for creating a time series of Twitter-user engagement and sentiment during the first few days of availability of the Windows 8 preview bits.

Following is a screen capture showing summary engagement (tweet count per day) and sentiment (Tone) data for 481,098 tweets, retweets and replies about Windows 8 from 2/12 to 3/4/2011:


Note: The execution time to retrieve the data was 04:55:05. Hour data is missing from the text box. (This problem has been corrected in the latest downloadable version.) The latest data (for 3/4/2011) isn’t exact because it’s only for 23 hours.

The abrupt increase in Tweets/Day from an average of 24,205 to more than 100,000 on 2/29/2011 is to be expected because Microsoft released the Windows 8 Consumer Preview and Windows 8 Server Beta on that date.

Clicking the Get OData button and clicking No when asked if you want to overwrite the existing ContentItems.csv summary file regenerates the graph and displays summary data in the DataGridView control:


Here’s Excel 2010 displaying all ContentItems.csv rows:


For more information about the downloadable “Social Analytics” sample app, see the following posts (in reverse chronological order):