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?
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.
Excel365 / Power BI Desktop should be installed on your laptop prior to the beginning of this Masterclass.
Some experience of working with Power Query’s User Interface is required. Not for beginners.