What you’ll learn
Want to fully master your data and the art of Data Preparation for Excel and Power BI? Then this is the course that you’re looking for.
We’re known for our practical approach in our courses, and this course is no exception. You can expect real-world scenarios and solutions that both of our world-class instructors have created over the years. This is a course where we focus more and more into the language behind Power Query: the M language.
This course begins with user-interface driven patterns for complex data transformations. From pivoting a single column of data into a full table, to un-pivoting sub-categorized data and more, you’ll learn some of the coolest tricks of the trade. You’ll look at automating Power Query refresh in Excel, as well as how to keep your file solution organized.
And then it’s time to take a deep dive into M; the language behind our data Magic. Not only will you learn how to code using the M language, but you’ll also learn the best way to tackle your scenarios using the M language. A completely new way of thinking on how to approach your Data Preparation scenarios.
Of course, no advanced technical course would be complete unless you learned how to apply the theory in real world scenarios. For that reason, you’ll see lessons on:
- Driving dynamic file paths for Excel solutions
- Building fully dynamic calendar tables for Excel and Power BI
- Future proofing queries against the challenge of dynamic headers
And finally, we show you how we – as experts – set up our Power Query environment to both optimize the development and run time for our solutions.
This course is packed with steps, formulas, and tricks from world-class experts that you can use to save hours of time. It’s the ultimate training to become a Power Query Ninja.
- People who already have the skills provided in our “Power Query Essentials” course (or equivalent experience)
- People who are comfortable with Power Query and want to push their skills to the next level
- People who want total control of their data in Excel or Power BI
What you get with the course
What our students say about the course
Ken Puls, FCPA, FCMA
Is a Chartered Professional Accountant, blogger, author and trainer with over 20 years of business experience. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. He has held the Microsoft MVP distinction since 2006, and has been recognized as a Fellow of his accounting organization.
Is an Excel specialist turned into BI specialist using the latest tools from Microsoft for BI – Power BI. He is the co-author of ‘M is for Data Monkey’, blogger and also Youtuber of powerful Excel video Tricks. He has been recognized as a Microsoft MVP, MCP – MCSA: BI Reporting and a Microsoft Certified Trainer (MCT).