$398.00 first payment, $99.00 / year onwards
Power Query, also known as “Get & Transform”, is an amazing piece of ETL technology built into Excel 2016 and Power BI Desktop, and is available as a free add-in for Excel 2013 and 2010. It 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.
The sad reality is that not all data is stored in nicely curated databases, and even when it is, the data analyst often doesn’t have access. Instead, we must piece together data provided in text files, Excel files, web pages, and even the body of emails to build the business intelligence solutions we need.
Until now this has been a painful, repetitive process with a great deal of cut and paste effort to clean, filter, and format data before it can even be used, and updates have been tedious and error prone. That ends right now!
If you need to learn one new tool today, Power Query is it.
With Power Query Academy, you’ll learn how to clean, reshape, and combine your data with ease, no matter where it comes from. Converting ASCII files into tables, combining multiple text files in one shot, and even unpivoting data is not only simple, but an investment in the future. You will save yourself hours of time gathering and preparing your data, and instead refresh your dashboard or report with a single click the next time you need it!
Power Query will change the way you "Get & Transform" data forever, and the skills you learn here are transferable between both Excel and Power BI.
Power Query Academy grew out of our popular live, online Power Query workshops. Due to the success of the workshops, demand grew for a video option catering to those who could not join us live for two days of training.
Power Query Academy will introduce you to the magic of Power Query and transform the way you work with data forever. What you learn here will save you hours of time that you can then use to explore your data, gain powerful insights, and make better decisions.
Ken Puls and Miguel Escobar, both top Power Query experts, will guide you as you learn to master this powerful tool, walking you through how to extract, transform, and load data in Microsoft Excel and Power BI Desktop.
1 Year access
Your registration to Power Query Academy includes:
- One year of unlimited access to the course materials
- 15 modules developed by world-class experts
- 13+ hours of learning broken into 73 bite-sized videos
- Downloadable example files to work through
- Quizzes after each module to help reinforce the information covered
- Free digital copy of our book, 'M is for Data Monkey' (2nd edition) - Release date TBD
- Top support on the course materials for one year
- Content that is updated every quarter as new features are released
- Certificate of Completion upon completion of the course
- Access to the sample dataset from our Azure database, to use with the examples and try your own scenarios
For the past several years, Power Query Training has offered the best live online workshops available and we have trained hundreds of people from around the world. Like our workshops, this course is created from a practical point of view, showcasing real-world examples and techniques that you can begin to use right away.
‘M is for Data Monkey’ is the top-selling Power Query book on the market and is considered a leading reference guide. Written by two world-class professional who are renowned Power Query experts, this book is dedicated to teaching how to use Power Query's incredible user interface, and also understanding and working with "M", the language that runs under the hood of the Power Query engine. As part of your registration to Power Query Academy, you will receive a digital copy of the newly released second edition.
Most traditional courses have static content, meaning that after they’re published there is little to no updating during the course’s lifespan. We live in a dynamic world that requires updates quite frequently – especially when it comes to Power BI and Power Query where updates and new features are released monthly. This is the main reason why Power Query Academy is quite different from most courses out there.
Our mission is to always have the latest and most relevant information in our course and we do this by updating and adding more content to our course on a quarterly basis. You can think of this course as a subscription service where you always get material that is relevant and up-to-date as well as other rewards that we incorporate to the course every quarter, such as:
- New databases on our free test server (Yes, you get access to an always-on SQL Azure database when you sign up to this course!)
- New questions for quizzes
- More resources
- New videos and sample files
This is the model of a modern online course and why we’re confident that our Academy will continue to be the best Power Query course worldwide. Our instructors are actively improving the content every single quarter, so your investment is not only for what is included at the time you register but what you’ll receive throughout your entire enrollment.
IMPORTANT NOTE FOR RETURNING STUDENTS: We understand that you might want to continue your access to the course after your initial enrollment expires. As a returning student, we offer a special discounted price of just USD $99/year after the first year. A couple of weeks before your current registration is about to expire, you will receive an email with information about renewing at the special $99 price.
I have been exposed to Power Query tools and its capabilities by none other than Mr Excel Bill Jelen in one of his tips videos on his YouTube channel, but he did mention about the authors of the tip: Ken Pulse and Miguel Escobar and their first bo...Read More
I have been exposed to Power Query tools and its capabilities by none other than Mr Excel Bill Jelen in one of his tips videos on his YouTube channel, but he did mention about the authors of the tip: Ken Pulse and Miguel Escobar and their first book: M For Data Monkey. I immediately bought the Ebook on my kindle and started reading it. Since then I have completely automated reporting at my workplace with help of Power Query, it takes few minutes instead of few hours to prepare complex MIS which has more than three divisions, this also includes complex divisional balance sheet and Cashflow statement. I have been following Ken and Miguel's blog ever since and following each and every tip they publish (also I am a connection on LinkedIn with both of them). When I first heard about this course, I was more than excited and I had decided to pre-enrol into it as I was sure it was worth every dime and every second invested in it. I am glad that I did that. I have learned so many new things like parameters and functions and M Language, the capabilities of Power Query goes way beyond the traditional way of using it once you know a little bit more about M code. Miguel and Ken have done fantastic Job and their approach to explaining each concept is truly professional and quite easy to grasp. While many advanced concepts I have come across were not easy to digest at first glance but I will be referring them again in future. Following are my suggestions for improving the experience next time: Screen capture zooming, All Miguel's videos had zoom in effect which was nice as I could see the specific part of screen especially formulas while it was not the case with Ken's videos, zooming into specific areas of the screen is quite important as people may not have big screens to watch video lessons all the time.. I would highly recommend this course who wants to master data cleaning and transformation and completely automate business intelligence. before I was exposed to Power Query I used to struggle with complex VBA coding which is difficult to master compared to Power Query (believe me you will not have to rely on VBA for data manipulation anymore once you know PQ) Thank you, Ken and Miguel for this awesome course, I wish you guys soon release the second edition of M for Data Money book and also new courses on Power BI, DAX and Power Pivot/Data Modelling... Cheers Prashant PanchalRead Less
I thought I knew a lot about Power Query, Well I do now!
I thought I knew a lot about Power Query, Well I do now!Read Less
I thoroughly enjoyed every detail of this course. I was able to see immediate return on investment as the course covered some of the challenges I faced as a Power BI freelancer. Thank you!
I thoroughly enjoyed every detail of this course. I was able to see immediate return on investment as the course covered some of the challenges I faced as a Power BI freelancer. Thank you!Read Less
Ken and Miguel are passionate about PQ and PBI and do a great job of sharing and teaching best practices. My go-to source for bettering myself in the exciting field of BI and Analytics.
Ken and Miguel are passionate about PQ and PBI and do a great job of sharing and teaching best practices. My go-to source for bettering myself in the exciting field of BI and Analytics.Read Less
Awesome course with great examples and clear explanations. This is one of the best courses I have done. I got the book on a recommendation and I have recommended to many more users. When I realized the authors were running a course it was an eas...Read More
Awesome course with great examples and clear explanations. This is one of the best courses I have done. I got the book on a recommendation and I have recommended to many more users. When I realized the authors were running a course it was an easy decision to subscribe. Great investments. The delivery platform has a few bugs but the course is awesome. Great job. Keep up the good work.Read Less
Hugely enjoyable course with loads of useful content - certainly will make me stop and think for a change before creating any more PQ solutions. Really liked the modular approach, breaking down the subject matter into usable 'topic chunks' which m...Read More
Hugely enjoyable course with loads of useful content - certainly will make me stop and think for a change before creating any more PQ solutions. Really liked the modular approach, breaking down the subject matter into usable 'topic chunks' which makes it more like a set of building blocks for creating better, more predictable results. Ken's vocal delivery is great - all his enthusiasm for the subject comes thru' in spades. Can't wait to get my hands on the book!Read Less
The course provides many useful techniques which I started using right away in my work. After watching some videos, I immediately revised my existing power query files incorporating the tricks learned from the course material. I would never ha...Read More
The course provides many useful techniques which I started using right away in my work. After watching some videos, I immediately revised my existing power query files incorporating the tricks learned from the course material. I would never have discovered the techniques contained in this course material on my own. The course was also very enjoyable. Thank you for putting these materials together.Read Less
Power Query is a most necessary tool for all analysts. Although, at first sight, it appears daunting, due to a new syntax (that elusive "M" language), Ken and Miguel do a good job explaining it with a step-by-step approach. I personally like the ...Read More
Power Query is a most necessary tool for all analysts. Although, at first sight, it appears daunting, due to a new syntax (that elusive "M" language), Ken and Miguel do a good job explaining it with a step-by-step approach. I personally like the "nothing is too complicated" attitude of the tutors and eventually came to appreciate its validity. Once the foundation is laid by this course, practice will make perfect.Read Less
Found modules to lead me a step at a time to understand Power Query. Modules make it simple to go back and review. Look forward to getting to each new module. I just completed the videos (which means I am half done, now I have to redo the vide...Read More
Found modules to lead me a step at a time to understand Power Query. Modules make it simple to go back and review. Look forward to getting to each new module. I just completed the videos (which means I am half done, now I have to redo the videos and practice each video). I purchased the original "M is for (Data) Money" but never seemed to be able to work my way through the material without getting stuck (or not motivated enough to keep going). I found the videos kept me motivated and help me understand the issues I had in the original book.Read Less
I give this course 5 stars. Gentlemen, you really outdid yourselves this time! This course is literally for everyone, from someone who's never heard of Power Query before to advance users seeking a refresher course. There's something here ...Read More
I give this course 5 stars. Gentlemen, you really outdid yourselves this time! This course is literally for everyone, from someone who's never heard of Power Query before to advance users seeking a refresher course. There's something here for everyone. There isn't one video on this course that I saw that I didn't say WOW, so that's how this can be done better!! I learned SOOOO much. You have no idea. Now I can do my job quicker and more efficiently. And it’s all thanks to you guys. I cannot thank you enough for putting this course out there, and helping me and the Excel community around the world. A world of thanks!!! CBRead Less
Wow! That was great! PowerQuery is such a magic thing. Thank you!
Wow! That was great! PowerQuery is such a magic thing. Thank you!Read Less
- Welcome to Power Query Academy!
- Support Portal - Demo
- Support Portal - User Activation
- What is Power Query? FREE TRIAL
- Versions of Power Query FREE TRIAL
- Our Suggested Learning Path FREE TRIAL
- Module 0 Handout (PDF Download)
- 'M is for Data Monkey' eBook [1st Edition] (Multiple Formats Download)
- Module 0 Quiz
- Module 1 Sample Files (ZIP Download)
- Module 1 Handout (PDF Download)
- Connecting to Delimited Flat Files (*.csv, *.txt) FREE TRIAL
- Connecting to Data in Excel Workbooks
- Connecting to Data in the Current Excel Workbook
- Connecting to Non-Delimited Flat Files (*.txt, *.prn)
- Module 1 Quiz
- Module 2 Sample Files (ZIP Download)
- Module 2 Handout (PDF Download)
- Step Settings
- Choosing Query Load Destinations
- Query Error Auditing
- The Importance of Defining Data Types
- Module 2 Quiz
- Module 3 Sample Files (ZIP Download)
- Module 3 Handout (PDF Download)
- Unpivoting Columns
- Pivoting Columns
- Split Columns into Other Columns
- Split Columns into Rows
- Filtering Data FREE TRIAL
- Sorting Data
- Transforming and Adding Columns Based on Existing Columns
- Module 3 Quiz
- Module 4 Sample Files (ZIP Download)
- Module 4 Handout (PDF Download)
- Appending Tables Individually
- Appending Tables in the Current Workbook
- Appending Worksheets in an External Workbook
- Combine All Flat Files in a Folder
- Combine a Named Worksheet from Multiple Workbooks
- Combine All Worksheets in Multiple Workbooks
- Merging Tables - Basics
- Merging Tables - Join Types
- Merging Tables - Cartesian Products
- Module 4 Quiz
- Module 5 Sample Files (ZIP Download)
- Module 5 Handout (PDF Download)
- Getting Data from Exchange
- Web Data: Webpage with Table Tags
- Web Data: Files Publicly hosted on the Web
- Web Data: Reading HTML Document
- SharePoint Data: Introduction
- SharePoint Data: Lists
- SharePoint Data: All Files from Site
- SharePoint Data: the From Folder Experience
- Connecting to a JSON File
- Module 5 Quiz
- Module 6 Sample Files (ZIP Download)
- Module 6 Handout (PDF Download)
- SQL Azure Database Credentials and Information
- Connecting to an Access Database
- Connecting to a SQL Database
- Connecting to SQL Server Analysis Services
- Credentials and Privacy Settings on Data Sources
- Direct Connectivity in Power BI Desktop
- Module 6 Quiz
- Module 7 Sample Files (ZIP Download)
- Module 7 Handout (PDF Download)
- Grouping and Summarizing Data
- Pivoting Stacked Data
- Unpivot Subcategorized Data
- Pivoting Vertical Pairs
- Pivoting Horizontal Pairs
- Module 7 Quiz
- Module 8 Sample Files (ZIP Download)
- Module 8 Handout (PDF Download)
- Automating Refresh in Excel
- Sharing Queries
- Query Organization
- Module 8 Quiz
- Module 9 Sample Files (ZIP Download)
- Module 9 Handout (PDF Download)
- Using Power Query Formulas
- Conditional Logic Basics
- Conditional Logic - Manual IF Tests FREE TRIAL
- Conditional Logic - Handling Errors
- Conditional Logic - Working With Multiple Conditions