Power Query (M Language) Scripting for Beginner BI Developers

Master Power Query's interface, data connection, and transformation capabilities to build robust data models for impactful BI dashboards and reports.

...

Power Query Fundamentals: Interface, Connections, and Core Transformations

Unit 1: Getting Started with Power Query

Unit 2: Connecting to Data

Unit 3: Core Data Transformations

Unit 4: Understanding Applied Steps & M Code

Advanced Data Shaping: Custom Columns, Merging, Appending, and Error Handling

Unit 1: Crafting New Data with Custom Columns

Unit 2: Integrating Data from Multiple Sources

Unit 3: Robust Queries: Error Handling & Parameters