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
Cleaning Data
Fill Up/Down
This is a preview lesson
Purchase this course, or sign in if you’re already enrolled, to take this lesson.
Purchase course
Sign in
In this lesson I will show you how to rename columns in Power Query.
To access this content, you must purchase
Power Query course for Power BI
or
M Language + Power Query Course Bundle
.
Previous
Next