Forum Discussion
identifying themes and doing sentiment analysis in text analytics using Power BI
In this case, try to create a calculated column. If the real data is not as cleaning as the sample, you may need some extra data cleaning work(not in Power BI). The best option would be classifying the comment when inputing, eg using some droplist having the themes and save the themes along with comment.
themes = SWITCH ( TRUE (), TRUE () && SEARCH ( "manager", Table[Comment],, 0 ) > 0, "manager", TRUE () && SEARCH ( "infrastructure", Table[Comment],, 0 ) > 0, "infrastructure", TRUE () && SEARCH ( "R&D", Table[Comment],, 0 ) > 0, "R&D" )You can download the WordCloud visual.
In this case, try to create a calculated column. If the real data is not as cleaning as the sample, you may need some extra data cleaning work(not in Power BI). The best option would be classifying the comment when inputing, eg using some droplist having the themes and save the themes along with comment.
themes =
SWITCH (
TRUE (),
TRUE ()
&& SEARCH ( "manager", Table[Comment],, 0 ) > 0, "manager",
TRUE ()
&& SEARCH ( "infrastructure", Table[Comment],, 0 ) > 0, "infrastructure",
TRUE ()
&& SEARCH ( "R&D", Table[Comment],, 0 ) > 0, "R&D"
)
Hi All.
I am trying to do the sentiment analysis for the following statements but trying to categorize them first by keywords and then do the analysis. Please find below the sample.
| Comment | Employee ID |
| My manager has good knowledge on statistics | 101 |
| The infrastructure of my company is sufficient for all purposes | 312 |
| Managers in my business unit have a lot of work | 132 |
| The R&D business unit of my Company is pretty good | 101 |
| My manager gives me a lot of work | 345 |
| My Company has good infrastructure for research | 456 |
| Managers in my business unit follow processes strictly | 836 |
| My Company has excellent infrastructure for development | 98 |
| The R&D business unit of My Company has a lot of opportunity to develop new patents | 906 |
| All Managers at My Company are well trained | 567 |
So I want to categorize by keywords "manager", "R&D", "Infrastructure" and then do the sentiment analysis . I am trying to use the nested if statement for the same... So I need to search for these words for each line and then do the sentiment analysis. Can some one please help me with the same...