In this video, you will learn how to use "Unpivot" in Power BI to shape survey and survey-like data. The tutorial covers the step-by-step process of transforming wide format data into long format data by unpivoting columns. By utilizing this technique, you can easily analyze and visualize your survey data in Power BI as well as increase performance.
Get the file to keep up with this example:
https://prag.works/survey-data-shaping
👍 If you enjoy this video and are interested in formal training on Microsoft Teams, Power BI, Power Apps, Azure, or other Microsoft products you can visit https://prag.works/NICK40 for 40% off On-Demand Learning!
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: https://prag.works/odl-trial-yt
🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-training/hackathons/
🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-mentoring/
🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-training/customized-enterprise-training/
🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/
Let's connect:
✔️Discord: https://prag.works/yt-discord
✔️Facebook: https://prag.works/yt-fb
✔️Instagram: https://prag.works/yt-insta
✔️LinkedIn: https://prag.works/yt-li
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email:
[email protected]
#PragmaticWorks #powerbi #dataanalysis
0:00 - Introduction and overview
0:33 - Problems with survey data in Power BI
1:30 - Example survey data in Power BI
2:57 - Issues with current data reporting
5:25 - Solution: unpivoting data
6:31 - Benefits of unpivoting data
7:26 - Demonstrating the unpivot process
8:21 - Cleaning up data after unpivoting
9:48 - Creating a new visual with unpivoted data
12:27 - Conclusion