Go back to Courses

Power Query Fundamentals

  • On-Demand
Author: Ken Puls Matt Allington Miguel Escobar
If you need to learn one new tool today, Power Query is it! This FREE course explains the fundamental concepts of Power Query, so you can have a basic understanding of what Power Query does and when to use it. You also receive our free eBook, 'Magic Tricks for Data Wizards'.
Course

Power Query Fundamentals

FREE
This Course contains:
2h 30m of video content
4 Content Modules
3 Quizzes
Downloadable files and Handouts
Certificate of completion
DURATION:
2h 30m
TOOLS:
Excel
Power BI
SKILLS:
Data Preparation

What you'll learn?

Basic understanding of what Power Query is and what it's designed for
How the Power Query User Interface is used to Extract, Transform and Load data
Simple transformation solutions that you can apply to your work
Building solutions to import data from common Data Sources
Methods to debug errors in your Power Query solutions
That you have been wasting a huge amount of time doing repetitive manual work that can easily be automated

Course Overview

Course Description

Power Query is an amazing ETL technology that allows you to “Get & Transform” your data in order to build refresh-able solutions for your business intelligence.  First available as a free add-in for Excel 2010 and Excel 2013, it’s now build in to Excel 2016 and higher, as well as acting as the “Get Data” layer for Power BI.

Simply put, Power Query allows you to Extract data from a vast array of sources, Transform it more quickly and easily than you ever thought possible, and then Load it directly into a table or your data model.

If you need to learn one new tool today, Power Query is it! This FREE course is sets the fundamental concepts of Power Query, so you can have a basic understanding of what Power Query does and when to use it. 

In this course, we will introduce you to the magic of Power Query and how it will transform the way you work with data forever. 

Who this course is for?

  • Anyone that needs to import and clean data to be analyzed
  • Anyone who copies and pastes data into the same Excel spreadsheet on a regular basis in order to be able to continue their workflow
  • Anyone who has ever tried to consolidate data in Excel using VLOOKUP() or other methods
  • Every user of Excel or Power BI

Bonus Gift with this Course

Our ‘Magic Tricks for Data Wizards’ eBook, with nearly 80 pages of helpful tips and tricks for Power Query in Excel and Power BI

Course Update Log

First release of the course as Power Query Fundamentals

New videos added to the Query Settings Module:

  • The “Get Data” User Experience
  • Data Profiling and Data Quality

New videos by Matt Allington added to the Introduction Module:

  • Power Query UI Walkthrough
  • When to Use Power Query

Course Formats

On-Demand
This is an on-demand course, delivered via pre-recorded video modules that you can consume at your own pace. It includes all required sample files, practice sets, and Q&A tests to validate your knowledge.

Course Content

Welcome to Power Query Fundamentals
2 Lessons
Getting Started
Magic Tricks for Data Wizards
Introduction
1 Quiz | 5 Lessons
What is Power Query?
Versions of Power Query
Power Query UI Walk Through
When to Use Power Query
Our Suggested Learning Path
Module Quiz – Introduction
Importing Basic Data
1 Quiz | 4 Lessons
Connecting to Delimited Flat Files
Connecting to Data in Excel Workbooks
Connecting to Data in the Current Excel Workbook
Connecting to Non-Delimited Flat Files
Module Quiz – Importing Basic Data
Query Settings
1 Quiz | 6 Lessons
Step Settings
The Get Data User Experience
Data Profiling and Data Quality
Configuring Query Load Destinations
Query Error Auditing
The Importance of Defining Data Types
Module Quiz – Query Settings

How subscription works?

This course is built on an annual subscription format. Your registration comes with 12 months of access to the course materials, so you can refer back to the videos and example files whenever you like. Your subscription also gives you access to our private Discussion Forum, where you can ask questions related to the course materials, as well as how to apply those teachings to your own work. This forum is an invaluable resource that also allows students to practice their own learnings by helping others with those questions.

On your annual renewal date, your subscription will be automatically renewed with the credit card information on file, unless you cancel your subscription beforehand. You will be emailed a renewal reminder about one month before the renewal date. Please see the FAQs below for information about subscription renewals and cancellations.

About the authors

Ken Puls

Microsoft MVP, FCPA, FCMA
Ken Puls is one of the founding partners of Skillwave.Training, and the President and Chief Training Officer of Excelguru Consulting Inc. in Canada. He is a Chartered Professional Accountant, blogger, author, and trainer with over 20 years of business and IT experience. His passion lies in exploring tools to turn data into information, and teaching others how to use them. Ken is a Microsoft MVP and a leading expert in Excel, Power Query, and Power BI.

Matt Allington

Microsoft MVP
Matt Allington is one of the founding partners of Skillwave.Training, and the owner and principal consultant at Excelerator BI Pty Ltd. in Australia. He is an expert in Power BI training and has 30+ years of experience in using data to deliver business value. Matt is a Microsoft MVP that specializes in Power BI, Power Pivot, and Power Query. He brings his business and IT experience to solve general business data problems quickly and efficiently.
Miguel Escobar

Miguel Escobar

Microsoft MVP
Miguel Escobar is one of the founding partners of Skillwave.Training, and the principal of Powered Solutions, a Microsoft Gold Partner in Panama. Miguel is an Excel specialist turned Business Intelligence expert using the latest tools from Microsoft – Power BI. He is the co-author of M is for Data Monkey, a blogger, and a Youtuber of powerful Excel video Tricks. He has been recognized as a Microsoft MVP and is a Microsoft Certified Trainer (MCT).

FAQ

How long do I have access to this course?
You have unlimited access to this course. Unlike our other courses, it is not built on a subscription basis so there is no renewal or expiry date.
How do I access the course materials? Are they downloadable?
The videos are streamed on-demand and may be watched as often as you like. However, they are not downloadable. The example files and handouts for each lesson are downloadable.
Where are the course videos hosted?
All the videos for the course are hosted on Vimeo. Please note that some networks block access to Vimeo, in which case the videos will not be watchable. You may want to double-check that your network allows access to Vimeo before registering in the Academy, to ensure that you will be able to see the videos.
Are quizzes required for completing the course? How do I receive my Certificate of Completion?
Yes, the quiz at the end of each module is required. Each quiz contains a set of randomized true/false and multiple-choice questions (usually 10 in total). You must get at least 80% to pass the quiz. But don’t worry, you can retake the test as many times as you like! After all the modules and lessons have been completed and quizzes passed, you will be able to download the Certificate of Completion from the My Courses area of your Account Dashboard.