Power Query Fundamentals

Power Query Training · September 22, 2019

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

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 need 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

What you get with the course

1.5+ hours of video content

Downloadable files and handouts

3 Quizzes

Premium Content & Instructors

Support & discussions group

Course Certificate of Completion

Course update log

First release of the course as Power Query Fundamentals

The instructors

Ken Puls, FCPA, FCMA

Is a Chartered Professional Accountant, blogger, author and trainer with over 20 years of business experience. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. He has held the Microsoft MVP distinction since 2006, and has been recognized as a Fellow of his accounting organization.

Miguel Escobar

Is an Excel specialist turned into BI specialist using the latest tools from Microsoft for BI – Power BI. He is the co-author of ‘M is for Data Monkey’, blogger and also Youtuber of powerful Excel video Tricks. He has been recognized as a Microsoft MVP, MCP – MCSA: BI Reporting and a Microsoft Certified Trainer (MCT).

About Instructor

+543 enrolled
Not Enrolled

Course Includes

  • 3 Modules
  • 12 Lessons
  • 3 Quizzes
  • Course Certificate