Forum Discussion
Email group or clustering
Dear Expert,
I am working on an email analysis which I would like to group/cluster the email subject & email body based on the most frequent words in the emails. Is there any specific text analysis function which is available in PowerBI Destop ( my version is free version)?
B.R.
Ken
Power BI Premium - No trial account is available.
Whether you can do this kind of analysis, you will need to go through the text here to see if it can be accomplished.
https://docs.microsoft.com/en-us/azure/cognitive-services/language-service/overview
If you want to test the service, I will suggest that you sign up for Azure cloud trial and you will get free use of these Cognitive services. Then you can test (But this will not happen through PQ but directly through Azure cloud).
3 Replies
Look here - Use AI Insights in Power BI Desktop
But this is available only for premium subscribers. "Cognitive Services are supported for Premium capacity nodes EM2, A2, or P1 and above. Cognitive services are also available with a Premium Per User (PPU) license"
Thank you for your response. Since I only have very basic program knowledge, is it still able to use the Cognitive Services? Is there any trial account which I may play around before buying?
Lastly, just wanna have better understanding whether the Cognitive Services can cover my key need below?
Here are the key purpose for my project.
- Cluster into 10 groups based on the email subject( top 5 frequent word or words)
- On top of each group from the email subject, further cluster it for another 5 groups.
- Able to remove some non-value words such as "a","an", "the" from the group?
Power BI Premium - No trial account is available.
Whether you can do this kind of analysis, you will need to go through the text here to see if it can be accomplished.
https://docs.microsoft.com/en-us/azure/cognitive-services/language-service/overview
If you want to test the service, I will suggest that you sign up for Azure cloud trial and you will get free use of these Cognitive services. Then you can test (But this will not happen through PQ but directly through Azure cloud).
