This module covers the basics and background to Power Query for Excel and Power BI. <ul><li>You will get to know the trainer, the training mode, and the benefits you receive from the training.</li><li>The module introduces you to Power Query covering a number of use cases so you can appreciate the power of the tool.</li><li>You will also receive a broad overview of the Power Query user interface for Excel both and Power BI.</li></ul>
Power Query for Excel and Power BI
This is an online video training course for Power Query. The course consists of more than 40 video lessons explaining how to use Power Query for Power BI and Excel. It starts at the beginning and covers the basics right through to advanced techniques and patterns to solve real world problems.
There are a few free introductory videos that cover an outline of the course, an overview of the user interface and also an explanation of some of the various ways you can use Power Query. These free samples will give you a taste of what this training material is like to help you determine if it will be useful for you.
After purchasing the course you will be able to view the content online for a single user for 36 months from the date of purchase. The videos are not available for download and you are required to have an internet connection to access the material.
Modules
Introduction to Power Query
Loading From Data Sources
This module covers the various sources that can be accessed by Power Query along with some guidance on how to use the major types.
Lessons
Transforming Data
This module covers the foundation skills of working to transform your data in rows, columns, and other general manipulations.
Lessons
Foundation Concepts
Building on the skills you have learnt so far, this module will cover a range of concepts that can be used in many scenarios
Lessons
Power Query Patterns
This module covers a range of standard patterns that solve real business problems using the skills learnt so far.
Lessons
Tips and Tricks
This module has a grab bag of tips that will give you ideas of how to work faster and more efficiently.
Lessons
Advanced Concepts
These more advanced concepts can be used to take your Power Query usage to the next level.
Lessons
Tricky Examples
This last module covers some more complex solutions to business problems and demonstrate how powerful Power Query can be.