Analysing Survey Results with Power BI

We analyse the results of a recent survey to rate four topic ideas for future events (schools, elections, COVID and crime) to see what insights we can draw and decide which of these topics to run - and which not.
The datasets and course materials used in the examples are atgithub.com/MarkWilcock/lbag-o...
Details and signup for events at www.meetup.com/London-Busines....
Music: bensound.com

[@mushroomdew]

Fantastic thank you. I love working through real world examples.

[@LondonBusinessAnalyticsGroup]

Glad you liked the video.

[@M.Al-Majeed]

Great video, helped me out a lot. Thanks a lot Mark.

[@BrianStettenbenz]

Thanks Mark for the video. There is not a lot of PowerBI on this specific topic. Your video is a great resource.

[@LondonBusinessAnalyticsGroup]

Glad it was helpful!. Thanks Brian.

[@1963bikerchick]

Thank you! This helped me so much!

[@LondonBusinessAnalyticsGroup]

Hi Heidi, Glad you enjoyed it. - Mark

[@JAYNEDOE_]

Maybe this video is a little outdated being 2 years ago and Power BI have changed their fields but I found this difficult to follow or unable to replicate with the survey dataset I am currently using.

[@sheenalchand7917]

Life saver video!

[@LondonBusinessAnalyticsGroup]

HI Sheenal, Really glad it was helpful. - Mark

[@anhphan9141]

thanks for the video Mark, it helps me a low. One question, how did you sort topic by largest to smallest of the Fascinating response? Thanks,

[@monicasanchez3659]

This video has been great to get me started as I'm new to PowerBI, but I'm still stuck on how to show multiple response question results on a table. I figured how to show the counts and the %, but not the percent of cases which is what I really need to report. Any tips? Thank you.

[@JiasKitchen19]

Hello, thanks for sharing its very useful. I am also creating something similar for a survey and i want to create something to see the average response per topic can you please confirm how i can do that?

[@youleib2965]

Hello and thank you very much for the helpfull content. i solved a same usecase. my problem is, that icant use the columns of the survey table to filter the visuals of the response. do u have a hint to solve such a case?

[@michelesenso3462]

Great video, however, i do not understand how you got to the 'Response' long table. Does this need to be build manually?

[@LondonBusinessAnalyticsGroup]

Hi Michele, to get the data in 'long' format, In the Query Editor, unpivot the the 'wide' format table. - Mark

[@Caitorade]

How did you create Number of Respondents?

[@cooluo]

Will you be holding any more topics this year regarding surveys ? I would like to come/ attend.

[@LondonBusinessAnalyticsGroup]

Hi Abdul, we will do another session on qualitative data this year - the video on surveys has been very popular. - Mark

[@marcosvalera6614]

Fantastic video!!!, is it possible to weight data?

[@LondonBusinessAnalyticsGroup]

Hi Marcos, Yes, it is possible to weight data, or do any calculation, using DAX, Power BI's language for calculations. - Mark

[@marcosvalera6614]

@@LondonBusinessAnalyticsGroup Many thanks!! I want to represent in a Dashboard survey data with multiresponse questions and with weighted data. Is there any example how to do this things?

[@ivanantonius2320]

Hi sir,
Want to ask.
How if we slicer by score number or sentiment, not the category.
One pie chart is filled by sentiment (Very boring, Interesting, fascinating, etc)
Then if we choose/click "very boring" on the pie chart,
All category which is set on another pie chart will generate depends on the sentiment that we choose / contains "sentiment very boring".
Thank you

[@LondonBusinessAnalyticsGroup]

Hi Ivan, In Power BI, use interactions between visuals on the same page so that the first pie chart filters will filter the second pie chart. - Mark

[@nurqamarinamohdnoor2492]

How the score sentiments is set?

[@lorifabian]

Either I use Number of respondents or Count of Score I get the same values (whole numbers representing number of respondents in that sentiment category) even If I double checked everything :(

[@LondonBusinessAnalyticsGroup]

Hi Loredana, Best to download the sample PBIX and compares with what you have got. Hard to answer this question in another way.

[@nurlidiyairdinaazmi139]

How do you get number of respondents under the response sheet ?

[@lorifabian]

In Report move (first vertical icon on the left table) you right click on the "Response" field, select "new measure" and you type after = COUNTROWS(Response)

[@inamullahkhan5761]

tell me more than 2 measure slicer

[@lalalalilili4951]

hi there is something i want to ask. may i know, how to break down the sentiment category?

[@LondonBusinessAnalyticsGroup]

You would need another related table or column in your data to do this