Skip to main content

Twitter Analytics for the Developers Conference in Mauritius

It was fun to build the Twitter statistics for the Developers Conference in Mauritius, but, it's only today that I had the time to compile the figures for all 3 days and apply Sentiment Analysis on the individual tweets. Let's look at the results!

Interactive Dashboard

Firstly, you can view the interactive dashboard here, filter the results, and even view details of the tweets.

Tweet Count

Count of Tweets: 790
Count of Tweets by Day: 20 = 223 ; 21= 246 ; 22= 321 
People Tweet most between 11 - 12 Hr
Highest number of Tweets by Username is 121 (MSCC)
Twitter Username with highest number of ReTweets is MSCC with 259 RTs
Twitter Username with highest number of Favourites is Ish with 86 Favourites


Sentiment Analysis

Sentiment Score of each tweet is between 0 and 1 where 1 is the tweet with the most positive sentiment.

Sum of Sentiment Score was highest between 11 and 12 Hr.
Username with Highest of Sum(Score) is Ajmal
Average Sentiment Score was better on Sunday



Let's do a filtering for PHP Mauritius UG and see the result.


PHP Mauritius is happier at around 14 and happiest on Sunday. Go ahead an play with the filters, it's fun!




Tweets with highest sentiment score 

click on the image to enlarge


Tweets with lowest sentiment score
Seems that those who could not come to DevCon had the lowest sentiment score.
The algorithm failed for the coffee tweet. Anyway, it's a machine doing the calculations, it won't be 100% accurate.

click on the image to enlarge


Most used words in tweets

DevConMru and https were the most used words. Note that common words like "the" were excluded



The technologies used are Power BI & Azure Machine Learning. Reach out to me to learn more about these Analytics tools!

Comments

Popular posts from this blog

Creating and Querying Microsoft Azure DocumentDB

DocumentDB is the latest storage option added to Microsoft Azure.
It is a no-sql storage service that stores JSON documents natively and provides indexing capabilities along with other interesting features.

This article is available available on theMicrosoft Technet Wiki. This article was highlighted in theTop Contributor awardson the 12th of October 2014. This article was highlighted in the TNWiki Article Spotlight. This article was highlighted in the The Microsoft TechNet Guru Awards! (October 2014).


DocumentDB is the latest storage option added to Microsoft Azure.
It is a no-sql storage service that stores JSON documents natively and provides indexing capabilities along with other interesting features.
This wiki shall introduce you to this new service.

Setting up a Microsoft Azure DocumentDBGo to the new Microsoft Azure Portal. https://portal.azure.com/ 


 Click on New > DocumentDB


Enter A Database ID and hit Create!



Query Unstructured Data From SQL Server Using PolyBase

Scope The following article demonstrates how unstructured data and relational data can be queried, joined and processed in a single query using PolyBase, a new feature in SQL Server 2016. Pre-RequisitesIntroduction to Big Data Analytics Using Microsoft Azure Big Data Analytics Using Hive on Microsoft Azure Analyze Twitter Data With Hive in Azure HDInsight Running Hadoop on Linux using Azure HDInsight  Introduction Traditionally, Big Data is processed using Apache Hadoop which is totally fine. But what if the result of this needs to be linked to the traditional Relation Database? For example, assume that from the analysis of tons of application logs, marketing needs to contact some customs that faced problems in an application following a failure in the application.
This problem is solved with PolyBase. PolyBase allows you to use Transact-SQL (T-SQL) statements to access data stored in Hadoop or Azure Blob Storage and query it in an ad-hoc fashion. It also lets you query semi-structure…

Creating and Deploying Microsoft Azure WebJobs

Azure WebJobs enables you to run programs or scripts in your website as background processes. It runs and scales as part of Azure Web Sites.
This article focuses on the basics of WebJobs before demonstrating an example where it can be used.

This article is also available on the Mirosoft TechNet Wiki.
This article was highlighted in the The Microsoft TechNet Guru Awards! (October 2014).


Introduction
What is Microsoft Azure WebJobs?
Azure WebJobs enables you to run programs or scripts in your website as background processes. It runs and scales as part of Azure Web Sites.

What Scheduling Options is supported by Microsoft Azure WebJobs? Azure WebJobs can run Continuously, On Demand or on a Schedule.
In what language/scripts are WebJobs written?
Azure WebJobs can be created using the following scripts:  .cmd, .bat, .exe (using windows cmd).ps1 (using powershell).sh (using bash).php (using php).py (using python).js (using node)In this article, the use of c# command line app shall be demonstrated.
Cr…