uk power bi summit twitter social media wottabyte

www.ukpowerbisummit.com

Microsoft Power BIName : David Moss Title : Power BI Solutions ArchitectTwitter : @wottabyteEmail : david@wottabyte.com

UK Power BI SummitThe Social Media Marketer’s Toolkit in Power BI

Social Media Marketer’s Toolkit in Power BI

• Introduction• Cognitive API / Microsoft Flow / Logic Apps• Power BI end to end Solution• Solutions Templates• Campaign Brand Management for Twitter

Social Media Marketer’s Toolkit in Power BI

• Introduction• Cognitive API / Microsoft Flow / Logic Apps• Power BI end to end Solution• Solutions Templates• Campaign Brand Management for Twitter

Microsoft AI & ML

https://www.microsoft.com/cognitive-services

https://www.microsoft.com/en-us/research/product/cognitive-toolkit/

https://powerapps.microsoft.com https://flow.microsoft.com

MICROSOFT POWER TEAM

https://stream.microsoft.com

Get Azure subscription with free credits…..

What is LOGIC APPS ?“Advance Microsoft Flow”

Difference between Flow & Logic Appshttps://docs.microsoft.com/en-us/azure/azure-functions/functions-compare-logic-apps-ms-flow-webjobs

Social Media Marketer’s Toolkit in Power BI

• Introduction• Cognitive API / Microsoft Flow / Logic Apps• Power BI end to end Solution• Solutions Templates• Campaign Brand Management for Twitter

Twitter Logic Apps

Azure Functions

Azure SQL DB

PowerBI

MS Cognitive Application API Text Analytics

Social Media Marketer’s Toolkit in Power BI

• Introduction• Cognitive API / Microsoft Flow / Logic Apps• Power BI end to end Solution• Solutions Templates : Campaign Brand Management

for Twitter

PBI Template Solutions see : https://powerbi.microsoft.com/en-us/solution-templates/

SCCM Technical template see https://www.youtube.com/watch?v=G0rRggpY3fg

Fix above error in Query Editor > Data setting Connections to reset ‘Edit credentials’You’ll need your Azure SQL logical server admin & password.

Need more help goto : Brand & Campaign Management for Twitter Solution Template Training Videohttps://www.youtube.com/watch?v=CwTWSkVxl4whttps://github.com/Microsoft/Business-platform-solution-templates/tree/master/Template/Microsoft-TwitterTemplate

Show Demo of end result in PBI see TwitterDemo

Data Chant Facebook demo Gil Raviv : Good sentiment analysis http://datachant.com/2016/10/21/pass-bi-virtual-chapter-demo-sentiment-analysis-power-bi/

Presidential Facebook sentimental analysisNeed from MS Cognitive Services get a free Text Analytics API key5000 transaction pre month . Each transaction max 1000 text strings = 5000*1000 = 5M /month free

Refresh in .pbit gets FB postings (in chunks of 100) from 2 FB pages: Clinton & TrumpCleans data and then calls the Text Analytics API that returns the sentiment value 0 – 1Classified into buckets <0.3 bad >0.7good rest = neutral

Microsoft Power BI

Name : David Moss Title : Power BI Solutions ArchitectTwitter : @wottabyteEmail : david@wottabyte.com

UK Power BI SummitSocial Media Twitter Dashboard