Analyse survey results with multiple answers using Power Query - Excel and Power BI

Do you have data containing multiple answers in a single column?
Do not just split the column. Use this Power Query approach to give you all types of analysis quickly and easily.

In this video, I will show you how to use Power Query to split a column by a delimiter and create new rows for each value. This is useful when you want to analyze survey results that have multiple responses in one cell.

Download sample file 🔽 https://efficiency365.com/wp-content/...

Contents 🔖
00:00 - Introduction
00:09 - Solution
00:20 - Power Query Transform
00:30 - Add index column
00:40 - Create a reference
00:47 - Split to rows
01:28 - Import into data model
01:45 - Create relationship
02:12 - Analyze with Pivot
02:55 - Multiple column survey data
03:34 - Repeat for each question
05:03 - Correcting mistakes


Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster

https://s.efficiency365.com/bk

Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms

Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://s.efficiency365.com/ptyt
Excel to Power BI - https://swiy.io/uxlpbi

Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: https://efficiency365.com/blog

LinkedIn :   / nitinparanjape  
Twitter :   / drnitinp  

Production
--------------------
Music and Effects: https://elements.envato.com/
Created using Adobe Premiere: https://www.adobe.com/in/creativeclou...
AI based captions: https://videoindexer.ai (Microsoft service)