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: powerbi.micros...
Download Apocalypse Dataset: github.com/Ale...
Favorite Power BI Courses:
Power BI for Business Intelligence - bit.ly/3Nfi59i
Power BI A-Z - 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: coursera.pxf.i...
📖Data Analysis with Python - coursera.pxf.i...
📖IBM Data Analysis Specialization - coursera.pxf.i...
📖Tableau Data Visualization - coursera.pxf.i...
Udemy Courses:
📖Python for Data Analysis and Visualization- bit.ly/3hhX4LX
📖Statistics for Data Science - bit.ly/37jqDbq
📖SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
📖Tableau A-Z - 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 - / alextheanalyst
💻Alex The Analyst Shop - teespring.com/...
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: github.com/Ale...
📱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
18 авг 2024