Word Frequency Analysis in Power BI (and R)
We analyse respondents’ comments of a recent survey and a Victorian horror novel. We use Power BI’s Query Editor to split the text into words. One stage of the process is to remove punctuation – this requires several steps in M but we add an R step to do this elegantly and simply.
The datasets and course materials used in the examples are at https://github.com/MarkWilcock/lbag-o...
We run a full range of data analysis and generative AI courses in London and online. See our courses at zomalex.co.uk
Details and signup for events at https://www.meetup.com/London-Busines....
Music: bensound.com