Forum Discussion

chandramouli's avatar
chandramouli
Icon for Helper I rankHelper I
9 years ago
Solved

identifying themes and doing sentiment analysis in text analytics using Power BI

Suppose if there are about 8000 ought records and the responses do not have a central theme ...such that some of the responses aare about a particular product, some about the infrastructure, some abo...
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    chandramouli

     

    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"
)

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

chandramouli

 

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"
)

chandramouli's avatar
chandramouli
Icon for Helper I rankHelper I
9 years ago

Hi Eric,

 

Thanks a lot for your help!.. This works.:) Excited....Also can you please let me know if it is possible to create Word clouds in Power BI..

 

 

Thanks,

Arun