Playback starts YouTube’s embedded player (privacy-enhanced mode).
How to Analyze Survey Data Part 1 - Unpivot Data with Power Query
ChannelExcel Campus - JonDescription from the creator
Sign up for our Excel webinar, times added weekly: excelcampus.com/blueprint-registration/
Checkout the full article and download the file at: excelcampus.com/pivot-tables/analyze-survey-dat…
Learn how to use Power Query to transform multiple choice survey data in Excel. This survey data has been exported to Excel in a format that is not easy to use for a pivot table. In this video you will learn how to use the Unpivot feature in Power Query to transform or normalize the data. This will make it easier to analyze with a pivot table and chart.
Please subscribe to my free email newsletter to get more Excel tips and tutorials like this. excelcampus.com/newsletter
PART 2: youtu.be/h-sKEPEvwZ8
PART 3: youtu.be/NBgL8ItVdKY
Checkout the full article and download the file at: excelcampus.com/pivot-tables/analyze-survey-dat…
Learn how to use Power Query to transform multiple choice survey data in Excel. This survey data has been exported to Excel in a format that is not easy to use for a pivot table. In this video you will learn how to use the Unpivot feature in Power Query to transform or normalize the data. This will make it easier to analyze with a pivot table and chart.
Please subscribe to my free email newsletter to get more Excel tips and tutorials like this. excelcampus.com/newsletter
PART 2: youtu.be/h-sKEPEvwZ8
PART 3: youtu.be/NBgL8ItVdKY
About this tutorial
Excel Campus - Jon published this 5:44 video tutorial on October 27, 2016. It has been watched 184,168 times on YouTube.
- Channel
- Excel Campus - Jon
- Category
- Howto & Style
- Duration
- 5:44
- Published
- October 27, 2016
- Views
- 184,168
- Likes
- 2,277
Tags
Share
This tutorial in other languages
- FRComment analyser des données d'enquête Partie 1 - Unpivot données avec la puissance de requête
- ESCómo analizar datos Encuesta Parte 1 - Datos UNPIVOT con Power consultas
- PTComo Analisar Levantamento de Dados Parte 1 - Dados Não Dinâmica com Power consulta
- ITCome analizzare parte dei dati Indagine 1 - UnPivot dati con Power Query
- DEWie Analysieren von Vermessungsdaten Teil 1 - Unpivot Daten bei Abfrage
- NLHoe te analyseren Survey gegevens Deel 1 - UNPIVOT gegevens met Power Query
- RUКак анализировать данные обследования Часть 1 - UNPIVOT данных с Мощность запроса
- PLJak analizować dane Survey Part 1 - UNPIVOT danych z Query zasilania
- JAパワークエリとアンピボットデータ - 調査データパート1を分析する方法
- ARكيفية تحليل مسح البيانات الجزء 1 - بيانات UNPIVOT مع سؤال الطاقة
- HIपावर क्वेरी के साथ Unpivot डाटा - कैसे सर्वे डेटा भाग 1 का विश्लेषण करने
- IDBagaimana Menganalisis Survei Data Bagian 1 - data UNPIVOT dengan Power Query