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.microsoft.com/en-us/downloads/
Download Apocalypse Dataset: 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 - 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.io/5bBd62
📖Data Analysis with Python - coursera.pxf.io/BXY3Wy
📖IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
📖Tableau Data Visualization - coursera.pxf.io/MXYqaN
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 - patreon.com/AlexTheAnalyst
💻Alex The Analyst Shop - teespring.com/stores/alex-the-analyst-shop
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: 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*
- How to use Power Query in Power BI | Microsoft Power BI for Beginners ( Download)
- How to Create and Manage Relationships in Power BI | Microsoft Power BI for Beginners ( Download)
- How to use Microsoft Power Query ( Download)
- Power BI Tutorial for Beginners ( Download)
- How to use DAX in Power BI | Microsoft Power BI for Beginners ( Download)
- Power BI Tutorial For Beginners | Create Your First Dashboard Now (Practice Files included) ( Download)
- Ultimate Power Bi Data Transformation/Cleansing Guide (Power Query)🔧📊 ( Download)
- How to use Microsoft Power BI - Tutorial for Beginners ( Download)
- Power Platform & Power BI Tip #2 ( Download)
- How to use Conditional Formatting in Power BI | Microsoft Power BI for Beginners ( Download)
- How to use Drill Down in Power BI | Microsoft Power BI for Beginners ( Download)
- Your first 10 minutes of Power BI - A no-nonsense getting started tutorial for beginners ( Download)
- 📊 How to use Power BI DAX - Tutorial ( Download)
- Master Power BI Essentials in Just 15 minutes ( Download)
- Should You Learn Power Bi Everything You Need To Know ( Download)
