Advanced Data Cleaning Using M in Power Query

In this Masterclass you will learn to work beyond Power Query’s User Interface and solve difficult datacleaning problems using the M Language in Power Query.  Start creating more robust and dynamic queries that won’t break if the source data changes. You will be able to create efficient and scalable data models in Excel and Power BI using clever Power Query techniques at the end of this Masterclass.

What topics will be covered?

• Working with Lists, Records, and Tables
• Solving iterative looping problems
• Creating custom functions to scale your Power Query work
• Recipes, solutions and patterns for tricky (yet common) data cleaning problems

Who is this for?

This Masterclass is for people who already know and have worked with Power Query’s user interface (either in Excel or Power BI) and want to explore advanced problem solving using the M Language.

• Business Intelligence or Data Analytics professionals
• Every day Excel or Power BI users who want to learn an in-demand business skill and build advanced Power Query skills
• Professionals willing to experience Power Query in new ways

Prerequisites

Excel365 / Power BI Desktop should be installed on your laptop prior to the beginning of this Masterclass.

Skill Level:‍

Some experience of working with Power Query’s User Interface is required. Not for beginners.