Analysing Survey Results with Power BI

Подписаться 11 тыс.

Просмотров 67 тыс.

50% 1

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

Опубликовано:

5 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 32

@mushroomdew 3 года назад

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

@LondonBusinessAnalyticsGroup 3 года назад

Glad you liked the video.

@M.Al-Majeed 2 года назад

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

@1963bikerchick 3 года назад

Thank you! This helped me so much!

@LondonBusinessAnalyticsGroup 3 года назад

Hi Heidi, Glad you enjoyed it. - Mark

@BrianStettenbenz 3 года назад

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

@LondonBusinessAnalyticsGroup 2 года назад

Glad it was helpful!. Thanks Brian.

@anhphan9141 3 года назад

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,

@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.

@monicasanchez3659 2 года назад

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.

@sheenalchand7917 2 года назад

Life saver video!

@LondonBusinessAnalyticsGroup 2 года назад

HI Sheenal, Really glad it was helpful. - Mark

@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?

@michelesenso3462 3 года назад

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

@LondonBusinessAnalyticsGroup 3 года назад

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

@youleib2965 8 месяцев назад

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?

@Caitorade Год назад

How did you create Number of Respondents?

@ivanantonius2320 3 года назад

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 3 года назад

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

@cooluo 3 года назад

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

@LondonBusinessAnalyticsGroup 3 года назад

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

@nurlidiyairdinaazmi139 3 года назад

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)

@nurqamarinamohdnoor2492 3 месяца назад

How the score sentiments is set?

@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

@marcosvalera6614 3 года назад

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

@LondonBusinessAnalyticsGroup 3 года назад

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

@marcosvalera6614 3 года назад

@@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?

@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.