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.
First release of the course as Power Query Fundamentals
New videos added to the Query Settings Module:
New videos by Matt Allington added to the Introduction Module:
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.