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