Stop relying on complex VBA and manual formulas—automate your data transformation workflows with the industry-standard tool for Excel and Power BI.
This course provides a comprehensive guide to using Power Query as a primary tool for data transformation, cleaning, and automation. It covers the transition from unstructured raw data sources to structured models, emphasizing the use of the M language, query optimization, and advanced data manipulation techniques. Learners will explore the differences between Power Query implementations in Excel and Power BI, including connector availability, AI insights, and query diagnostics. The curriculum focuses on building efficient, repeatable scripts that replace traditional manual processes and complex VBA programming.
12 activities • 67 videos • duration: 7h 59m

Power BI Consultant & Trainer
Microsoft Certified Trainer (MCT), Power Platform advisor and FMCG business consultant. For 10+ years I worked daily with Microsoft data tools across 70+ system implementations on Power BI, Fabric, Analysis Services and the Power Platform. Deep expertise in Power BI positioning, DAX and M programming, and data modeling - and an early adopter of AI/LLMs in modern data stacks.