Stepping beyond the Power Query User Interface

Become an advanced data analyst! Learn more about Power Query (including M) and take your knowledge to the next level!

Created by: Krešimir Ledinski
Microsoft Certified Trainer (MCT) for PowerBI/Excel

What Will I Learn?

• Clear understanding when and where to use Power Query.
• How to clean and transform the most known types of data sources, accompanied by comprehending the logic behind connecting to any data source.
• Lots of simple and useful tricks to speed up data preparation.
• How to combine multiple data sources into a single solution (both with merging or appending tables)
• Understanding of M language and its most important building blocks (queries, parameters, functions)
• Techniques to utilize functions that can transform and clean hundreds of different sources, no matter how dirty the source data is.

Requirements

• No previous knowledge is required to enroll in this course, only to have a Power BI desktop application installed.

Target audience

• The course is for Power Query users that are interested in improving their knowledge about Power Query and the M Language. It starts with the basics of Power Query and soon upgrades to the advanced level of M scripting. It is ideal for those who want to understand the range of abilities of Power Query and learn how to use the most powerful data transformation tool.