Analyse survey results with multiple answers using Power Query - Excel and Power BI скачать в хорошем качестве

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)