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