Forum Discussion
Is there a key word generator?
Hi Anonymous ,
If you have a Premium Capacity or Premium-per-User licence you can use the in-built AI capabilities in Power Query:
There are generic keyword/keyphrase models available, as well as sentiment evaluation etc.
Other than that, you will need to go for the parsing option and use a 'word exclusion' list to avoid the AT's and THE's etc.
You may find Chris Webb's attempt at this type of thing a useful starting point, but make sure to red Frank's comments at the end to get correct counts:
https://blog.crossjoin.co.uk/2013/03/15/finding-shakespeares-favourite-words-with-data-explorer/
Pete
Super UserHi Anonymous ,
If you have a Premium Capacity or Premium-per-User licence you can use the in-built AI capabilities in Power Query:
There are generic keyword/keyphrase models available, as well as sentiment evaluation etc.
Other than that, you will need to go for the parsing option and use a 'word exclusion' list to avoid the AT's and THE's etc.
You may find Chris Webb's attempt at this type of thing a useful starting point, but make sure to red Frank's comments at the end to get correct counts:
https://blog.crossjoin.co.uk/2013/03/15/finding-shakespeares-favourite-words-with-data-explorer/
Pete
Thank you, BA_Pete for the lead!