MENU

Fun & Interesting

How to use Power Query in Power BI | Microsoft Power BI for Beginners

Alex The Analyst 479,259 3 years ago
Video Not Working? Fix It Now

💻Take my Full Power BI Course Here: https://www.analystbuilder.com/courses/microsoft-power-bi-desktop-for-business-intelligence In this series we will be walking through the basics of Microsoft Power BI. In this video we will be walking through how to use the Power Query Editor in Power BI. Download Microsoft Power BI: https://powerbi.microsoft.com/en-us/downloads/ Download Apocalypse Dataset: https://github.com/AlexTheAnalyst/Power-BI/blob/main/Apocolypse%20Food%20Prep%20-%20Power%20Query%20Editor%20Tutorial.xlsx Favorite Power BI Courses: Power BI for Business Intelligence - https://bit.ly/3Nfi59i Power BI A-Z - https://bit.ly/3MkpYKw ____________________________________________ SUBSCRIBE! Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________ RESOURCES: Coursera Courses: 📖Google Data Analyst Certification: https://coursera.pxf.io/5bBd62 📖Data Analysis with Python - https://coursera.pxf.io/BXY3Wy 📖IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR 📖Tableau Data Visualization - https://coursera.pxf.io/MXYqaN Udemy Courses: 📖Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX 📖Statistics for Data Science - https://bit.ly/37jqDbq 📖SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij 📖Tableau A-Z - http://bit.ly/385lYvN *Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!* ____________________________________________ SUPPORT MY CHANNEL - PATREON/MERCH 🙌Patreon Page - https://www.patreon.com/AlexTheAnalyst 💻Alex The Analyst Shop - https://teespring.com/stores/alex-the-analyst-shop ____________________________________________ Websites: 💻Website: AlexTheAnalyst.com 💾GitHub: https://github.com/AlexTheAnalyst 📱Instagram: @Alex_The_Analyst ____________________________________________ 0:00 Intro 0:29 Looking at the Data 1:45 Load data into Power Query 2:32 Power Query UI 5:26 Removing Rows 6:17 Changing the Headers 6:49 Changing Data Types 8:00 Removing Rows with "x" Value 8:58 Removing Columns 9:25 Pivoting/Unpivoting 12:15 Saving Transformation 12:44 Outro *All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

Comment