Forum Discussion
Twitter Analysis with Power BI
Hi All,
I am trying to do sentiment analysis using Microsoft Cognitive Services by extracting the tweets using R.
1. Is there any way we can exract the tweets directly in Power BI and do the data cleaning part.
2. What I observed is, Cognitive services does not necessarily give correct sentiment of the tweets. Is there any way to fine tune this process ?
Any docuementation of this will really help. I have read the text analytics blog from Microsoft and trying to follow the same.
For data extraction directly on Power BI, I am not able to find anything.
Regards,
Akash
Hi akj2784
1. You may try to use web data source to call Twitter API and do the data cleaning in Query Editor. Available retrieved data are also depends on the Twitter API. Article: Get Data from Twitter API with Power Query.
2. Some articles about sentiment analysis for you:
https://datachant.com/tag/sentiment-analysis/
https://community.powerbi.com/t5/Community-Blog/Sentiment-Analysis-in-Power-BI/ba-p/55898
Regards,
Cherie
3 Replies
Hi akj2784
1. You may try to use web data source to call Twitter API and do the data cleaning in Query Editor. Available retrieved data are also depends on the Twitter API. Article: Get Data from Twitter API with Power Query.
2. Some articles about sentiment analysis for you:
https://datachant.com/tag/sentiment-analysis/
https://community.powerbi.com/t5/Community-Blog/Sentiment-Analysis-in-Power-BI/ba-p/55898
Regards,
Cherie
I found this tutorial on youtube very simple and direct have a look on it
Hi
1- You can connect Twitter to Power bi using the API URL, or a third-party connector that helps you connect directly to your twitter account ( https://windsor.ai/microsoft-power-bi/).
2- For sentiment analysis there is this package " text mining" it will help you get the analysis you need.3- Well you have few choices, either with text mining using keywords and terms or using an app such as brand24.
