Analyze and chart Agree/Disagree Likert scale survey data in Power Bi

  Рет қаралды 13,506

MSurveyPoint

MSurveyPoint

Күн бұрын

Пікірлер: 34
@norahmutale4391
@norahmutale4391 Жыл бұрын
Your tutorials are exceptional ❤❤❤❤
@MSurveyPoint
@MSurveyPoint 10 ай бұрын
Glad you like them!
@spencer1226
@spencer1226 Жыл бұрын
Much appreciated! This video was exactly what I needed.
@MSurveyPoint
@MSurveyPoint Жыл бұрын
Encouraging to hear this helped.
@asifkhan-k3m3c
@asifkhan-k3m3c 5 ай бұрын
much appreciated , I was looking for two to three hours to find out the satisfactory and unsatisfactory order alignment in pivot tables in power bi
@MSurveyPoint
@MSurveyPoint 5 ай бұрын
@@asifkhan-k3m3cGlade this helps
@MSurveyPoint
@MSurveyPoint 5 ай бұрын
@@asifkhan-k3m3c Glade this helps.👍 All the best with your project
@Kal_nashar
@Kal_nashar Жыл бұрын
Thank you so much! This is incredibly useful.
@MSurveyPoint
@MSurveyPoint Жыл бұрын
Glade this helps
@siobhanpoulter455
@siobhanpoulter455 3 ай бұрын
Many thanks for this it is sooooo helpful :)
@MSurveyPoint
@MSurveyPoint 3 ай бұрын
Glad it was helpful!
@patriciaejindu
@patriciaejindu 8 ай бұрын
Thank you for the great tutorial. It was exactly what I was searching for. How would you go about visualising results of the statements by key survey metrics such as by organisational unit, region, country, function, age, gender etc? It would be great to see a tutorial around these.
@MSurveyPoint
@MSurveyPoint 8 ай бұрын
Thanks for the feedback. Noted. I will add this up in my upcoming videos
@make725daily1
@make725daily1 Жыл бұрын
This video sets an exceptional benchmark! _ "Value the journey, as it molds your path towards greatness."
@anaisyanlap7360
@anaisyanlap7360 4 ай бұрын
Thankyou so much
@heyzutube
@heyzutube 10 ай бұрын
you've saved my day
@MSurveyPoint
@MSurveyPoint 10 ай бұрын
Thanks for sharing your feedback Glade to hear this helps.
@emmanuelaigbomian5976
@emmanuelaigbomian5976 26 күн бұрын
Much appreciated man, but can you analyze likert quantitative data like this using MATLAB?
@rij17
@rij17 9 ай бұрын
Thankyou so much for this video. it is extremely helpful, you explained it very nicely! Wanted to ask if there are also other ways to represent the linkert scale, other than 100% Bar chart and Column chart, please let me know, thanks again.
@MSurveyPoint
@MSurveyPoint 9 ай бұрын
Thanks for the feedback. Happy to know this helped. There are always more than one way to represent data, depending on the story you want to communicate with the data. And the format of the final output of your analysis/report: word, PPT, infographic, dashboard, etc. For percentages like we have in the video, and which part of the scale is most important to you; other considerations are 1. Table: well formated, sorted or key numbers highlighted. etc. as 2. Conditional formatting, highlighting high & low scoring. 3. Single column bar chart , focusing on the top 2 scores( Etc.
@nathalinalmeida
@nathalinalmeida 20 күн бұрын
How can I show 0% results in table? There questions with only negative responses and these questions don't are visible in table. Thank you so much
@MSurveyPoint
@MSurveyPoint 20 күн бұрын
Hi @@nathalinalmeida Thank you for feedback. Could you please clarify your question? I am not sure I get it. Alternatively you can connect with via email to better assist you.
@Buloyskie
@Buloyskie 8 ай бұрын
Why my unpivoted data is not updating everytime I refresh with mew data. My data source if from excel.
@MSurveyPoint
@MSurveyPoint 8 ай бұрын
Could you check if the new data is showing in your source data table in power Bi? before the duplicated table. If it is showing, you may consider unpivoting directly in that table. Maybe the duplicated table is not calling the new data from the updated source data table
@שלוחבה-ו6ה
@שלוחבה-ו6ה Жыл бұрын
when i try to sort i get this Error : We cant sort the likert scale response by 'order'. there cant be more than one value in ' order' for the same value in likert scale responses. please choose a different column for sorting or update the data in 'order'
@MSurveyPoint
@MSurveyPoint Жыл бұрын
Okay. Check back on the custom column you created (LikertscaleSortOrder). You probably assigned two values for one likert scale response. That is two conditions were created for the same Likert scale response. You need to remove one, if that is the case. The right assignment should be E.g: using 1-5 points Strongly disagree=1 Disagree=2 Neutral=3 Agree=4 Strongly agree=5 Each Likert label response to take only one value
@andreathorsheim2621
@andreathorsheim2621 5 ай бұрын
@@MSurveyPoint I have the same problem, and have the correct orders from 1-5. Do you know of another potential solution to the problem?
@wonko-the-often-sane
@wonko-the-often-sane 4 ай бұрын
​@@andreathorsheim2621Same here. Even tried a different approach with a dimension table of responses with the response text as the primary key and a unique constraint on the order value. There is no way there are duplicates and yet here we are...
@arthautami9999
@arthautami9999 10 ай бұрын
Thank you so much, this video is really help me But i wanto to ask : How to process satisfaction survey data if i use some domain, for example Topic 1 : Statement 1 Statement 2 Statement 3 Topic 2 : Statement 1 Statement 2 Statement 3 etc. And then i want to visualisation based on topic. Could you give me an answer or tutorial video, please 😊😊
@MSurveyPoint
@MSurveyPoint 10 ай бұрын
Glad you found it helpful
@MSurveyPoint
@MSurveyPoint 10 ай бұрын
You can apply the same approach. But here, One way is to: >>Select the set of statements for topic 1 and unpivot like in this video. You can name the attribute column as Topic 1_statements. >>In the same table, select the set of statements for topic 2 and do the same >>Repeat for the rest of the topics you have. Caution: Your model could be come bigger with this approach (number of rows could run into millions because of the several unpivoting) Alternatively, >Duplicate your data for each of the topics >>Then apply the previous steps for each separately. >>You may name each table for example _Topic 1_Company culture >>Afterwards you the load all the tables into your data model. And proceed with your visualization like in the video. I hope this helps. Do remember to subscribe to support my channel
@arthautami9999
@arthautami9999 10 ай бұрын
@@MSurveyPoint thank you very much, finnaly i have solution now
@MSurveyPoint
@MSurveyPoint 10 ай бұрын
@@arthautami9999 Glade this helped
@MSurveyPoint
@MSurveyPoint 7 ай бұрын
Connect with me if you need support on the following: 1. Survey questionnaire design 2. Online survey scripting 3. Survey data Analysis 4. Research report writing 5. Data analysis in Excel 6. Survey Dashboard in Excel 7. Survey Dashboard in Power Bi Email: msurveypoint@gmail.com Book appointment here calendar.app.google/MMasAbZPDuwCCux76 The scope of my services includes but not limited to the areas of Market Research, Customer Experience Research, Product Research, User Experience Research, Employee Engagement Surveys, NPS, CSAT & Voice of the customer, Monitoring & Evaluation, etc.
Unlocking the Secrets of Survey Data in Power BI
12:54
Pragmatic Works
Рет қаралды 3,9 М.
FOREVER BUNNY
00:14
Natan por Aí
Рет қаралды 41 МЛН
Turn Off the Vacum And Sit Back and Laugh 🤣
00:34
SKITSFUL
Рет қаралды 11 МЛН
Creative Justice at the Checkout: Bananas and Eggs Showdown #shorts
00:18
Fabiosa Best Lifehacks
Рет қаралды 35 МЛН
How To Create these useful Power Bi Visuals that Excel Lacks
10:55
Leila Gharani
Рет қаралды 479 М.
Top 5 Customer Analytics - Demonstrated
16:21
Data Science Demonstrated
Рет қаралды 30 М.
Plotting Likert (agree/disagree) data in Excel
10:33
Chris Armstrong
Рет қаралды 58 М.
Visualize complex survey data in Power BI
17:39
BIDataLab
Рет қаралды 30 М.
12 Dashboard design tips for better data visualization
9:51
Geckoboard
Рет қаралды 202 М.
How to Model and Analyze Data in EXCEL using POWER PIVOT
22:23
Top 3 Survey Visuals in Power BI
25:25
How to Power BI
Рет қаралды 34 М.