Forum Discussion

chandramouli's avatar
chandramouli
Helper I
9 years ago
Solved

Identifying themes in sentiment analysis

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 about the process...the requirement is to seperate thethemes and then do the sentimental analysis on them...can someone please throw light on how is to be done in power BI

  • chandramouli

     

    In your scenario, you supposes to have column in your 8000 records to identify those sentiments into different category. Power BI can't distinguish one records belongs to which category and classify them automatically. For your requirement, you may try to use DAX to check some keywords index within sentiment text, then  use nested IF statements to define different category for each keyword.

     

    Regards,

2 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee

    chandramouli

     

    In your scenario, you supposes to have column in your 8000 records to identify those sentiments into different category. Power BI can't distinguish one records belongs to which category and classify them automatically. For your requirement, you may try to use DAX to check some keywords index within sentiment text, then  use nested IF statements to define different category for each keyword.

     

    Regards,

    • chandramouli's avatar
      chandramouli
      Helper I

      Hi Simon,

       

      Appreciate your response!.. Can you please provide some sample script on how it is to be done?

       

       

      Thanks,

      Arun