Great video David - I am specifically look at how I would analyse data like you have in column C and D is there a video for that? Where I can see what the responses are in numbers
I think you are referring to unpivot which is covered here also in Power Query: th-cam.com/video/oIFSxUNxuRw/w-d-xo.htmlsi=mfoF70KQROciO70b or other survey analysis videos are here: th-cam.com/video/A85t3b5Zn5Q/w-d-xo.html and here: th-cam.com/video/3ffJzC5AR2Q/w-d-xo.html
Hi David, great video! You mentioned that you have another video which explains how to analyse data from Microsoft Forms in Excel when there are a continuous stream of new responses. Are you able to send the link to this video? Thanks!
Hey! Glad you like it, I have around 4 videos which describe analysing forms data in excel, this one shows that but if you search in my channel you can find more! th-cam.com/video/UoEwPKLjoeU/w-d-xo.html
Hey David, thank you for the video :) I wanted to know if I can do this the same way you did when I have more than one likert question in my forms. So in my case instead of E-Mails, Chatapp and Teams, I have 5 car manufacturers and instead of percentage I have a scale from 1-5. This structure continues for 10 different likert questions. And if I do it the same way you did the Powerquery changes a bit in structure. I‘m a bit confused and I‘d be glad if you‘d help me out here 😄
The same method is adaptable for your situation for sure, the video should explain how, if it doesn’t help I could offer consulting support under my company, you can email me on david@xlconsulting-asia.com
Hi David. Thanks for the videos, they are proving very helpful with my final year project for university. I have a quick question. When I import my data from Forms into Excel, the columns containing the answers from my likert questions are not titled with the statement from the Form itself ie: "Access to the countryside is a fundamental human right", instead it just says "Column 1, Column 2, Column 3 etc." Any ideas?
Great video David - I am specifically look at how I would analyse data like you have in column C and D is there a video for that? Where I can see what the responses are in numbers
I think you are referring to unpivot which is covered here also in Power Query: th-cam.com/video/oIFSxUNxuRw/w-d-xo.htmlsi=mfoF70KQROciO70b or other survey analysis videos are here: th-cam.com/video/A85t3b5Zn5Q/w-d-xo.html and here: th-cam.com/video/3ffJzC5AR2Q/w-d-xo.html
Hi David, great video! You mentioned that you have another video which explains how to analyse data from Microsoft Forms in Excel when there are a continuous stream of new responses. Are you able to send the link to this video? Thanks!
Hey! Glad you like it, I have around 4 videos which describe analysing forms data in excel, this one shows that but if you search in my channel you can find more! th-cam.com/video/UoEwPKLjoeU/w-d-xo.html
Hey David, thank you for the video :)
I wanted to know if I can do this the same way you did when I have more than one likert question in my forms.
So in my case instead of E-Mails, Chatapp and Teams, I have 5 car manufacturers and instead of percentage I have a scale from 1-5. This structure continues for 10 different likert questions. And if I do it the same way you did the Powerquery changes a bit in structure. I‘m a bit confused and I‘d be glad if you‘d help me out here 😄
The same method is adaptable for your situation for sure, the video should explain how, if it doesn’t help I could offer consulting support under my company, you can email me on david@xlconsulting-asia.com
Hi David - This is great information. Do you have any resources that translates this same process from Forms to PBI?
Thanks for the feedback. PBI also uses the Power Query engine so the process is pretty much the same actually
My likert scale won't allow me to add more than 7 options, Please help.
I assume you mean in Forms, in that case you can use the "Rating" question type" and write in the question what the different values mean
Hi David. Thanks for the videos, they are proving very helpful with my final year project for university. I have a quick question.
When I import my data from Forms into Excel, the columns containing the answers from my likert questions are not titled with the statement from the Form itself ie: "Access to the countryside is a fundamental human right", instead it just says "Column 1, Column 2, Column 3 etc." Any ideas?
Sorry I can’t say without seeing it more clearly. PS love the south park reference in your profile name 😂