Power Query Online Training [updated 2022]
0 of 58 lessons complete (0%)
Exit Course
Introduction to Power Query
Course Guide
Preview
Power Query Tour
Power Query Workflow
M and the Advance Editor
Preview
4 lessons
Connect to data sources
Get Data from Excel
Get Data from a text file (txt)
Get Data from CSV file
Preview
Get Data from Folder
Get Data from PDF
Get Data from SQL (on-premises)
Get Data from Azure SQL
Get Data from web
Get Data from Online Sources
Get Data from Power BI Service
Get Data from Power BI Dataflow
Custom connectors & Other
12 lessons
Cleaning Data
Intro to Clean data
Keep/ Remove rows
Promote / Demote Headers
Data Types Explained
Keep / Remove Columns
Split Columns
Format Options
Rename columns
Replace Values
Fill Up/Down
Preview
Extract
11 lessons
Joining Tables
Intro to Joins
Left Outer
Right Outer
Full Outer
Inner
Left Anti
Right Anti
Append
8 lessons
Column Transformations
Intro to Custom columns
Preview
Custom Columns
Conditional Column
Conditional column with parameters
Advanced conditional columns
Column By Example
6 lessons
Best Practices
Best Practice 1: Table Names
Best Practice 2: Column Names
Best Practice 3:Data Types
Best Practice 4: Unnecessary steps
Best Practice 5: Unclear steps
Best Practice 6:Document
Best Practice 7: Load tables
Best Practice 8: Folders
8 lessons
Introduction to M
Should I learn M?
Language Flow
Power Query Functions
EX1: Proper Casing on column headers
EX2: Remove Underscores on headings
EX3: Rename columns without adding steps
EX4: Change Data Types without adding Steps
EX5: Document steps fast
8 lessons
Prove your Power Query Mastery
Introduction to M
Power Query Functions
You don’t have access to this lesson
Please purchase this course, or sign in if you’re already enrolled, to access the course content.
Purchase course
Sign in
In this lesson I go through M functions.
To access this content, you must purchase
Power Query course for Power BI
or
M Language + Power Query Course Bundle
.
Previous
Next