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

[@asifkhan-k3m3c]

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]

@@asifkhan-k3m3cGlade this helps

[@MSurveyPoint]

@@asifkhan-k3m3c Glade this helps.👍 All the best with your project

[@patriciaejindu]

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]

Thanks for the feedback. Noted. I will add this up in my upcoming videos

[@make725daily1]

This video sets an exceptional benchmark! _ "Value the journey, as it molds your path towards greatness."

[@norahmutale4391]

Your tutorials are exceptional ❤❤❤❤

[@MSurveyPoint]

Glad you like them!

[@rij17]

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]

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.

[@siobhanpoulter455]

Many thanks for this it is sooooo helpful :)

[@MSurveyPoint]

Glad it was helpful!

[@Kal_nashar]

Thank you so much! This is incredibly useful.

[@MSurveyPoint]

Glade this helps

[@MSurveyPoint]

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: [e-mail] 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.

[@spencer1226]

Much appreciated! This video was exactly what I needed.

[@MSurveyPoint]

Encouraging to hear this helped.

[@anaisyanlap7360]

Thankyou so much

[@arthautami9999]

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]

Glad you found it helpful

[@MSurveyPoint]

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]

@@MSurveyPoint thank you very much, finnaly i have solution now

[@MSurveyPoint]

@@arthautami9999 Glade this helped

[@Buloyskie]

Why my unpivoted data is not updating everytime I refresh with mew data. My data source if from excel.

[@MSurveyPoint]

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

[@heyzutube]

you've saved my day

[@MSurveyPoint]

Thanks for sharing your feedback Glade to hear this helps.

[@שלוחבה-ו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]

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]

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

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