Using Microsoft Azure – Twitter Analysis

Time for a fun post, I have been working on a mini-project using technology from Microsoft Azure to hook into Arsenal FC public twitter feed to analyse what was being said about this great football club. (Yes I support Arsenal)

The Technology used? Azure Logic Apps, Cognitive Services, Azure SQL Database, T-SQL scripts and Power BI. While not quite real time I got Azure Logic Apps to poll their account every 2 minutes.

So what did I find ( when executed on Monday) ?

Firstly, Arsene Wenger, TH14, PEA14 and the carabao cup were popular hash tags! (Good game last night by the way).

pbi_wenger.JPG

I also found out generally that most tweets / RTs were positive using Cognitive services to assign a sentiment score for tweets.

pbi_pes

Then I wrote some code to split the message to find #hashtags for each poster, as you can see  many accounts were talking about TH14 and PEA14 at the same time, I wonder why 🙂

pbi_hash

This shows you how an unskilled person like me can build stuff in Azure. Give it a go yourself. https://azure.microsoft.com/en-us/free/

 

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s