• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Data Stories
    • Power BI Stories
    • 1 dataset, 100 matplotlib visualizations
  • Learning Portal
    • Download Center
    • 25 Days Challenge
    • DAX Glossary
    • Power BI
    • Power BI by Topic
    • Python
    • 1 dataset, 100 matplotlib visualizations
  • Courses
    • Power BI Mini Master Class 1: Using a REST API as a data source
    • Power BI Master Class 1: COVID Tracker
    • Introduction to Power BI – FREE Online course
    • M Language + Power Query Course Bundle
    • Power Query Online Training [updated 2022]
    • M Language Online Course: The unofficial and Practical Reference Guide [updated 2025]
    • My Courses
  • Shop
    • Courses
    • Master Classes
    • Template Apps
    • JSON Themes
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Search
  • Contact
You are here: Home / Courses / Power Query Online Training [updated 2022]

Power Query Online Training [updated 2022]

posted on October 22, 2018

Please log in to access your purchased courses.
Please log in to access your purchased courses.

Hello and welcome to Curbal’s first course on Power Query!

I’ve been wanting to do this course for a long long time. I think Power Query is one of the most important tools or skills that you need to learn in the coming years. Why do I say that? Well Power Query is available now in Excel, in Power BI, in Analysis Services, you have it in PowerApps, in flow… Microsoft is putting Power Query everywhere! There are two reasons for that: it is that good, is an amazing tool and number two: it just makes your life easier.

Includes

  • 58 video lessons
  • 3 hours of short videos
  • English captions on all lessons
  • 23 downloadable resources
  • Lifetime access
  • Certification upon course completion
  • Mobile Friendly
  • Access to the Power BI High level introduction course included
  • 3 preview lessons available

Happy Learning!

Who is this course for?

This course is for people that are beginners in Power Query and for those that have worked with Power Query for a while but would like to have a structured way of learning it. If you have been doing Power Query longer than that, you can still take the course because, you know me, I always put best practices there and some tips and tricks… is filled with that!

What are we going to cover?

Well it is packed, packed, packed with material. We’re going to do of course a round tour of Power Query and explain how everything works.

We’re going to go through get sources. We will go through how to connect to the most common sources. There are eleven lessons on that, so I think I’ve got to cover with most of them. Then we’re going to go through the most common transformations that you will do in Power Query, the ones that you have on the user interface where you click, click, click and then you have it. There are some buts and ifs and some mmm… I’ll go through that too, so you know what to expect when you’re clicking those buttons.

After that, we’re going to go through how to join tables: you have merge and you have append and I will go through both and we have great examples to do that. You will be able to follow along with the examples that I provide, you have all the material there for you to go along and do it with me.

Once we have done the join tables, well we’re going to go through the column transformations and the column transformations is such a great “advanced feature” because it allows you to make transformations that are fairly basic but there is no button for it, so it allows you to make Power Query to write code in a very simple way.

Once we’ve gone through the custom columns, I have to do this, I have to show you the best practices. These are habits that you need to implement every time you create a Power Query file. We will go through what those habits are and what they are good for.

Last but not least, we have a module on M. M is the language that is written behind the scenes when you are doing Power Query transformations and it’s an amazing skill to have. You don’t need to be an M master, to be able to know enough M to do amazing thing, but that is exactly what I’m going to show you. I’m going to show you what M is, I’m going to go through the basic workflow for M, so you get a feel for how that works and I’m going to bombard you with the examples: if you want to do this, this is how you do it in M and you’ll see how much faster and easier things get done. It will actually allow you to implement the best practice that I showed you faster. The hope for to me at creating that lesson, was that you shouldn’t be afraid of M, you shouldn’t be afraid of the advanced editor. Be curious! Go there and check and modify and see what happens…Hopefully slowly but surely, you will start learning M without even realizing it.

Those are the main topics. I really hope that you enjoy this course, it is available at curbal.com/courses-overview at the same place as the free course.

If you haven’t taken the free course do that, it is an introduction to Power BI and I really hope you enjoy it, I put my heart and soul on it! Looking forward your feedback and until then, take care!

Course Outline:

Introduction to Power Query

Lessons

Course Guide Preview Power Query Tour Power Query Workflow M and the Advance Editor Preview

Connect to data sources

Lessons

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

Cleaning Data

Lessons

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

Joining Tables

Lessons

Intro to Joins Left Outer Right Outer Full Outer Inner Left Anti Right Anti Append

Column Transformations

Lessons

Intro to Custom columns Preview Custom Columns Conditional Column Conditional column with parameters Advanced conditional columns Column By Example

Best Practices

Lessons

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

Introduction to M

Lessons

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
Prove your Power Query Mastery

Primary Sidebar

Search Website:

Subscribe to our YouTube Channel (+130k subs)!

Apply for Membership (+50,000 members)

Become a Member

Footer CTA

Join our community of +50,000 professionals

Become a Member

Subscribe to YouTube

About me:

Curbal AB
Badhusgatan 7B
722 15 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2025 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In