Visualize complex survey data in Power BI

  Рет қаралды 30,413

BIDataLab

BIDataLab

Күн бұрын

Пікірлер: 55
@islamicknowledge4027
@islamicknowledge4027 Жыл бұрын
The amount of precision and detail in your videos is very helpful. Thank you!
@goldgarbagecan
@goldgarbagecan 3 жыл бұрын
Hi, i am from Perú. You don't know how i suffered for a guide for build a graph and analyze a multiple choice survey data. No info in spanish, no info in Power BI community. Just you had the answer and finally i finished. Your video is gold and you need to put a guide for step by step that pivot and procedures that are very complex but useful in analizing multiple choice questions. Sound is not good, however the content is a gem. Thank you :) New Suscriber.
@novala2004
@novala2004 2 жыл бұрын
same here
@me_youtube2318
@me_youtube2318 Жыл бұрын
Thank you so much for making this. I was really stuck on how to get this type of survey data to work in Power BI. This is great!
@JavierBerrios-wk6vt
@JavierBerrios-wk6vt 7 ай бұрын
Very detailed explanation on how to solve a tricky problem with clear reasoning why. Thanks for putting together such helpful video.
@yaksh82
@yaksh82 4 ай бұрын
Simply resolved the issue of multiple response analysis. Thanks you
@Slayonus
@Slayonus Жыл бұрын
Amazing video, it took me super long to find a video that covers this topic well; super happy that I found this. Thank you so much!
@lindabond9307
@lindabond9307 2 жыл бұрын
Thank you - it was doing my head in how to create the data model, which is the key to this problem. Great simple steps. You're very kind - thanks so much!
@Angel-kr4qo
@Angel-kr4qo 5 ай бұрын
Thank you soo much, the way you explain the proccess makes it really easy to follow. :)
@ZohraYaqub-c8w
@ZohraYaqub-c8w Жыл бұрын
This is exactly what I needed to learn! Thank you!
@robertsheffer9054
@robertsheffer9054 3 жыл бұрын
This is exellent and well explained! Just what I required.
@rawazsulaiman3315
@rawazsulaiman3315 3 жыл бұрын
Great video, well illustrated each steps. If you make a video for likert scale data visualization that would be super perfect ...
@novala2004
@novala2004 2 жыл бұрын
Thanks for this excellent explanation - it solved my issue immediately
@jagenones6513
@jagenones6513 3 ай бұрын
Great tutorial! Thank you
@byo0o1999
@byo0o1999 4 ай бұрын
Hi, what if i have wight in my data is there a way to use the weighted data in the visuals?
@eirikemhjellen2736
@eirikemhjellen2736 2 жыл бұрын
This helpt me very much, keep ut the good work!
@igorrichwinferreira2801
@igorrichwinferreira2801 Жыл бұрын
Thanks, for the video! Very helpful. But what if I want to display the data as a percentage (but no the grand total percentage)?
@oneway5093
@oneway5093 10 ай бұрын
Excellent explanation. can we get the sample data for excercise.
@mohammedaltaf4877
@mohammedaltaf4877 2 жыл бұрын
Excellent Job Brother
@BIDataLab
@BIDataLab 2 жыл бұрын
Thanks brother :)
@nael4555
@nael4555 Жыл бұрын
Very good and useful video, thank you so much, I would like to practice what I learned in this video, could u please share the dataset?
@piajavier8168
@piajavier8168 Жыл бұрын
can you do a crosstab table wherein the gender is separated into 2 columns pls. thanks
@poojasivayogan1702
@poojasivayogan1702 2 жыл бұрын
Life saver! Thanks a ton!
@devl4617
@devl4617 3 жыл бұрын
Great work done
@wesleyharper3253
@wesleyharper3253 Жыл бұрын
This is really cool stuff! Question, if I want to create measures that show the % of individuals who use each program what is the best way to go about doing that? Additionally, if I want to add slicers, for example a slicer for each department they work in what is the best way to go about doing that while still showing the aforementioned percentage measures correctly? Thank you for posting this, really helpful stuff.
@duyoan3042
@duyoan3042 2 жыл бұрын
thank you for your guide, it í very helpful
@DSShinZoku
@DSShinZoku 2 жыл бұрын
many many thanks!
@gmea1234
@gmea1234 9 ай бұрын
Thank you!
@ItsTheBlingBling
@ItsTheBlingBling Жыл бұрын
Thanks for a great video! May I know how do I go about if I wanna see how many respondents have BOTH Outlook and Excel in their answers?
@BIDataLab
@BIDataLab 9 ай бұрын
You just select both in the slicer
@Marhan93
@Marhan93 2 жыл бұрын
Hi! Great video. My forms is addign a semi-colon to the final word, so PowerBI creates an additional empty "value" next to the indexes. I see that you have no special characters at the end of your multiple choice answers. Wondering if anyone had a solution so I could strip it out automatically/prevent the emptry row being made? (yours says "Word, Excel" whilemine says "Word;Excel;" for instance)
@ominous_8991
@ominous_8991 Жыл бұрын
The video is excellent. Help me start breaking apart my survey, but I hit a snag. I am hoping someone can give me advice. The survey has 62 questions and 5 possible responses. I did separate columns, like gender, to another table using the index option shown in the video. However, with the questions, I would like to group them by category and perform calculations. For example, questions 1-8 are about Job Satisfaction and questions 9-14 are about Compensation. So I might want a break down of Female Hispanics. Any advice?
@devl4617
@devl4617 3 жыл бұрын
Please provide the dataset in the description, it would be really helpful.
@BIDataLab
@BIDataLab 3 жыл бұрын
Here is the link for the dataset: drive.google.com/drive/folders/1IdhysazoUFzAlOROrHjPFeK9q5GaRRMd?usp=sharing Let me know if you need anything else
@4AlexeyR
@4AlexeyR 2 жыл бұрын
Hi, thanks for the video. Have a question. Do you know how to automate these steps with scripts to do not repeat manually for each column? Let's think we have a list of target columns.
@BIDataLab
@BIDataLab 2 жыл бұрын
I don't think we can do much to improve this sorry!
@MAbdullah47
@MAbdullah47 Жыл бұрын
can you post the resources?
@asjones987
@asjones987 3 жыл бұрын
Was there a reason you did not uses Split Column by Delimiter Advanced option to split into rows instead of columns?
@BIDataLab
@BIDataLab 2 жыл бұрын
I didn’t know that option at that time 😆
@anastasiadushina4217
@anastasiadushina4217 2 жыл бұрын
Hi, thank you for your video, it's really useful. I just have one more question, is it possible to create the same visualizations of programs and motivators for percentage of employees, not number? Thank you!
@BIDataLab
@BIDataLab 2 жыл бұрын
Yes, absolutely, the simpliest way is to choose the value to show as % of total
@carltonseymour869
@carltonseymour869 2 жыл бұрын
Interesting but why did you not leave it as a one-to-many relationship.
@BIDataLab
@BIDataLab 2 жыл бұрын
It would not filter
@carltonseymour869
@carltonseymour869 2 жыл бұрын
@@BIDataLab Yes do agree but why would you need to filter as you can create a measure of "countrows" on the table you pulled out from the main table.
@BIDataLab
@BIDataLab 2 жыл бұрын
@@carltonseymour869 You can try it yourself, it will not work because of the filters we are taking from the other tables, and to filter that main table (where we create the countrows measure), the filter should be bidirectional. Of course, there are other advanced ways to create measures, but this approach is the easiest one.
@carltonseymour869
@carltonseymour869 2 жыл бұрын
@@BIDataLab Thank you t is definitely the easiest.
@Kidhypo12
@Kidhypo12 5 ай бұрын
I am surprised that you did not get Error codes due to duplicates in the index column
@BIDataLab
@BIDataLab 5 ай бұрын
No problem in 1:N relationship
@irexhepi
@irexhepi 3 жыл бұрын
Nice
@SoroushSohrabian
@SoroushSohrabian Жыл бұрын
Great
@fatjanpaloja9182
@fatjanpaloja9182 3 жыл бұрын
👍🏻👍🏻👍🏻
@ShellLD
@ShellLD 3 жыл бұрын
Unfortunately I cant hear you even with my PC's volume turned up to maximum
@inteligenciademercado4809
@inteligenciademercado4809 3 жыл бұрын
The volume is too low
@matthayward4411
@matthayward4411 9 ай бұрын
Thank you!
Get all your survey data in ONE visual!
15:52
Christine Payton
Рет қаралды 15 М.
Как Я Брата ОБМАНУЛ (смешное видео, прикол, юмор, поржать)
00:59
А я думаю что за звук такой знакомый? 😂😂😂
00:15
Денис Кукояка
Рет қаралды 6 МЛН
小路飞和小丑也太帅了#家庭#搞笑 #funny #小丑 #cosplay
00:13
家庭搞笑日记
Рет қаралды 17 МЛН
Players push long pins through a cardboard box attempting to pop the balloon!
00:31
Lost trio #hoo #toa #pipermclean #leovaldez #jasongrace
0:20
Основы работы в Microsoft Power BI
31:43
Nikolay Pavlov
Рет қаралды 182 М.
Data modelling 101 with Power BI | Community Webinars
1:10:17
Microsoft Power BI
Рет қаралды 149 М.
«Если 50 детей не рожу - ничего не добился»
1:26:17
Саша Сулим
Рет қаралды 1,5 МЛН
How to calculate Net Promoter Score in Power BI without DAX
8:15
Maurice A. - Power Platform Enthusiast
Рет қаралды 10 М.
Master Power BI Essentials in Just 15 minutes
14:16
Kenji Explains
Рет қаралды 672 М.
How to Analyze Select-All-That-Apply Survey Questions in Excel ✅ [MS FORMS!]
9:38
Spotlight Impact Data Design
Рет қаралды 14 М.
Unlocking the Secrets of Survey Data in Power BI
12:54
Pragmatic Works
Рет қаралды 3,9 М.
Как Я Брата ОБМАНУЛ (смешное видео, прикол, юмор, поржать)
00:59