https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/UK-General-Election-2017-Twitter-Analysis/m-p/187945#M880 <P>As we speak, thousands of political conversations and comments about the UK 2017 General Election are happening on Twitter. Many of these messages are offering insight, influence and speculation regarding the parties involved leading up to Election Day on Thursday 8th June 2017.</P> <P>&nbsp;</P> <P>Looking at the narrative contained within the tweets can lead to questions being raised:<BR />- Can positive or negative sentiment within tweets influence the voting public?<BR />- Which parties are getting mentioned the most and is volume more important than sentiment?<BR />- Will the volume reflect the result?</P> <P>&nbsp;</P> <P>Using Microsoft Flow, the process watches for tweets with the hashtag #GE2017, passes the tweet text through Azure Cognitive Services to detect sentiment and finally loads the data into an Azure SQL Server database.</P> <P>&nbsp;</P> <P>Once the tweets are available in the database, they are then able to be analysed and presented using Microsoft Power BI.</P> <P><SPAN class="reportid hidden">eyJrIjoiYmU3N2ExZTMtYjkyMS00NjM4LTkwZjUtZmZmMDM0OTg3NDU1IiwidCI6IjBjNzk5ZDM4LTQ3NjQtNDJiYy1iNGZmLTIzYmViYTljN2ZlMiIsImMiOjh9</SPAN></P> Mon, 05 Jun 2017 10:47:33 GMT jamesdales 2017-06-05T10:47:33Z https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/UK-General-Election-2017-Twitter-Analysis/m-p/187945#M880 <P>As we speak, thousands of political conversations and comments about the UK 2017 General Election are happening on Twitter. Many of these messages are offering insight, influence and speculation regarding the parties involved leading up to Election Day on Thursday 8th June 2017.</P> <P>&nbsp;</P> <P>Looking at the narrative contained within the tweets can lead to questions being raised:<BR />- Can positive or negative sentiment within tweets influence the voting public?<BR />- Which parties are getting mentioned the most and is volume more important than sentiment?<BR />- Will the volume reflect the result?</P> <P>&nbsp;</P> <P>Using Microsoft Flow, the process watches for tweets with the hashtag #GE2017, passes the tweet text through Azure Cognitive Services to detect sentiment and finally loads the data into an Azure SQL Server database.</P> <P>&nbsp;</P> <P>Once the tweets are available in the database, they are then able to be analysed and presented using Microsoft Power BI.</P> <P><SPAN class="reportid hidden">eyJrIjoiYmU3N2ExZTMtYjkyMS00NjM4LTkwZjUtZmZmMDM0OTg3NDU1IiwidCI6IjBjNzk5ZDM4LTQ3NjQtNDJiYy1iNGZmLTIzYmViYTljN2ZlMiIsImMiOjh9</SPAN></P> Mon, 05 Jun 2017 10:47:33 GMT https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/UK-General-Election-2017-Twitter-Analysis/m-p/187945#M880 jamesdales 2017-06-05T10:47:33Z