Analyze and chart Agree/Disagree Likert scale survey data using Pivot Table 

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.

You absolute Genius you!!! I don't know what I would have done if I didn't find this!!!!

Many thanks for the video, this is very helpful!

Hi! thanks for the video. If I wanted to show the Top 5 statements based on Strongly Agree scale percentage, is it possible?

Hai. You rearranged the cell to bring all the scales in Ascending order after taking percentages in pivot table. But I am not able to do it. May be that was too fast for me. Could you please help?

Thank you for directing me to this video. I have used this video many times but I want to link the responses to a respondent as i am building a dashboard. when i try to link the chart to the dashboard it does not connect to the slicers

Thank you so much!!

Hello, after I did Transform-Unvipot selected coloumn-home-pivot table report. I cannot find ID to put on values. Did I miss something?

This was really helpful, you save me sir!

Hello, is that ok if you could provide the raw data so I can practice. I am studying for career advancement with tests around the corner and don't have to input enough large data. Thank you.

Cross-tabulation of multiple response survey data in Excel Pivot Tables ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-WX5hLOfC1R0.html

How to do this in Power BI?

Thanks so much for the video. Is there a way where you can do this but with two sets of Likert-scale responses to each statement? I.e. If we have two surveys, to have the Likert responses from survey 1 and survey 2 for each statement, like this: Agree Neither Disagree Statement 1 Survey1 5 6 10 Survey 2 10 7 4 Statement 2 Survey 1 7 8 6 Survey 2 15 1 5 Statement 3 Survey 1 2 5 14 Survey 2 6 2 13

Helpful

On point... thanx

I am happy.

Check out these videos on multiple response survey data 1. How to Analyze Space-separated Multiple response Survey Data in Excel Pivot Table: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JJjM2MpW0lw.html 2. How to analyze comma-separated multiple choice survey data in Pivot Table: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kbCt-D7b6og.html 3. How to Analyze Columns-separated Multiple Response Survey Data in Excel Pivot Table: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Uman2Q4laBE.html 4. How to Analyze 1/0 coded Multiple Response Survey Data in Excel Pivot Table: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kdeT4O01nmU.html 5. How to Analyze TRUE/FALSE coded Multiple Response Survey Data in Excel Pivot Table ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xUY2rJddT3E.html 6. How to Analyze Yes/No coded Multiple Response Survey Data in Excel Pivot Table ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-_e_RX4e2Y5w.html

thank you so much

I can't select the data i can only select one😭

Cross-tabulation of Likert scale Agree/Disagree Survey data in Pivot Table ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ErYw5db1QE8.html

Here is the Sample Data I used in the Video: docs.google.com/spreadsheets/d/1WuboUJ01dJcbYQJHSSiyxp0T-zaURGzA/edit?usp=sharing&ouid=117355798969062583983&rtpof=true&sd=true

Hello, in my case when i import the data it only shows an option for Table and Only create connection ... The option for Pivot table report doesn't show up What should i do about this 🥲

Thank you sooo much!