Struggling to follow the step where you "split into words"... you mention you will come back to it but watched the whole video and I cannot work out how you did that from this video.
This is exactly what I wanted. Best video on the topic. Easiest to follow. Only thing I wish was that you could explain what a 'measure' is and what does adding the one you did, mean. Anyway, i blindly followed instruction and got my job done :D
Hi great vid! But how did you get from text all in one cell to it being one word per cell? It’s like there is a step missing. Please help as this is what I really need
Hi James, @@raddleriddle7752 I used the Split Column operation in the Power BI Query Editor. Each video has a link to an example Power BI Desktop file that you can download and see all the steps
Excellent video, I learnt a lot! Thank you! What would be the advantage of building a WordCloud visual in PowerBI as against getting the WordCloud survey analysis from Microsoft Forms survey besides the flexibility of filtering?
Thanks for this video, it was a great help, and the documentation is perfect, downloading the example file, I learned a lot. The step using the scrip in R is still a bit of a mistery to me, but I guess I'll figure it out. Do I need to download/copy paste that script into R from some place before using it? Thanks and greetings from Chile.
Very excellent video, thank you! I got one question for you, how do you handle with plural form words when calculate word frequency? Maybe I miss something in your process?
How did you create word table? is it done manually? I have like 12000 rows in excel with comments, how am I going to create a word list out of that, please suggest.
HI theway19, I used R script in a Query Editor script to split sentences into words, then used the Query Editor Group By to count words. It's all in the video. - Mark
@@LondonBusinessAnalyticsGroup I watched the video but don't actually see the exact script that was used to split the sentence into words and distribute them in rows and not across columns.
Hi @@LadyCrimson10 , I used a "split column by delimiter" step. There is an advanced option to split into rows. Expand the advanced options section to see it.
Struggling to follow the step where you "split into words"... you mention you will come back to it but watched the whole video and I cannot work out how you did that from this video.
Under "Split Column" option there is an advanced option to split into rows using a delimiter
This is exactly what I wanted. Best video on the topic. Easiest to follow. Only thing I wish was that you could explain what a 'measure' is and what does adding the one you did, mean. Anyway, i blindly followed instruction and got my job done :D
Hi four321zero, A measure is just a fancy name for a number that we add up - such as the count of words. Glad you enjoyed the video. - Mark
Excelent ! I've learnt a lot with this video ! Thank you so much, greetings from Chile.
Glad it was helpful!
Hi great vid! But how did you get from text all in one cell to it being one word per cell? It’s like there is a step missing. Please help as this is what I really need
Hi James, @@raddleriddle7752 I used the Split Column operation in the Power BI Query Editor. Each video has a link to an example Power BI Desktop file that you can download and see all the steps
@@LondonBusinessAnalyticsGroup After splitting by delimited space, I have many columns, how do you combine them all into 1 column?
@@stryder1587 use the Unpivot operator.
Very nice. Is there also a possibility to keep the survey IDs zu filter the surve by the word?
Excellent video, I learnt a lot! Thank you! What would be the advantage of building a WordCloud visual in PowerBI as against getting the WordCloud survey analysis from Microsoft Forms survey besides the flexibility of filtering?
Thanks for this video, it was a great help, and the documentation is perfect, downloading the example file, I learned a lot. The step using the scrip in R is still a bit of a mistery to me, but I guess I'll figure it out. Do I need to download/copy paste that script into R from some place before using it? Thanks and greetings from Chile.
Thanks for a great video! Is there anyway to change plural words to singular, such as "servants" and "servant" are counted as one?
HI Tra, You could always remove the final s! You can do this in a R step using a R library like tidytext and a technique called stemming. - Mark
@@LondonBusinessAnalyticsGroup thank you for your reply. Really helpful :)
thanks, great video. “split the text into words”，if my sentences are chinese such as “我今天吃了很多饭”,if there any method to do this?
Hi EfficiencyDNA, do Chinese characters have a word separator? If so, use that. - Mark
@@LondonBusinessAnalyticsGroup thank you
Very excellent video, thank you! I got one question for you, how do you handle with plural form words when calculate word frequency? Maybe I miss something in your process?
stop words I think. ie. ', s, t etc.
How did you created Stop_word table you have not mentioned. I think you have skiped some timline.
How did you create word table? is it done manually? I have like 12000 rows in excel with comments, how am I going to create a word list out of that, please suggest.
HI theway19, I used R script in a Query Editor script to split sentences into words, then used the Query Editor Group By to count words. It's all in the video. - Mark
@@LondonBusinessAnalyticsGroup I watched the video but don't actually see the exact script that was used to split the sentence into words and distribute them in rows and not across columns.
Hi @@LadyCrimson10 , I used a "split column by delimiter" step. There is an advanced option to split into rows. Expand the advanced options section to see it.
@@LondonBusinessAnalyticsGroup - "There is an advanced option to split into rows"... a nugget of pure gold