Power Query Courses and Certifications

Data Preparation and Modeling

Learn to prepare, clean, and model data effectively using Power Query and Power BI. Master relational data concepts, DAX language, and create efficient data models for analysis.

• Udacity
• 3 weeks, 5-6 hours a week
• On-Demand
• Paid Course

Intermediate Power Query in Excel

Building on your foundational Power Query in Excel knowledge, this intermediate course takes you to the next level of data transformation mastery

• DataCamp
• 4 hours
• On-Demand
• Free Trial Available

Case Study: Ecommerce Analysis in Power BI

In ecommerce, increasing sales and reducing costs are key. Analyze data from an online pet supply company using Power BI.

• DataCamp
• 4 hours
• On-Demand
• Free Trial Available

Corporate Finance Institute

Financial Statements in Power BI

Comprehensive walkthrough on creating financial statements in Power BI, covering data modeling, DAX measures, and Excel integration for retail company automation and visualization.

• Coursera
• 6 hours 9 minutes
• On-Demand
• Free Online Course (Audit)

Data Preparation and Management

Master data preparation essentials using Power BI to connect, transform, and optimize diverse data sources. Learn ETL processes, storage configuration, and cleaning techniques for creating reliable, analysis-ready datasets.

• Coursera
• 17 hours 22 minutes
• On-Demand
• Free Online Course (Audit)

Excel: Working Together with Power Query and Power Pivot

1296 ratings at LinkedIn Learning

Learn how to combine Power Query and Power Pivot, two robust features of Microsoft Excel, to analyze data.

• LinkedIn Learning
• 51 minutes
• On-Demand
• Free Trial Available

Excel: Creating a Dashboard with Power Query (Office 365/Microsoft 365)

1124 ratings at LinkedIn Learning

Learn how to create data-rich Excel dashboards using Power Query.

• LinkedIn Learning
• 1 hour 20 minutes
• On-Demand
• Free Trial Available

Retrieve, Transform, and Combine Data Using Power Query

72 ratings at Pluralsight

This course targets the Business Intelligence (BI) Self Service professional who needs to obtain and shape data from multiple and various sources so that the data can provide useful BI to report viewers. The focus of this course is Power Query.

• Pluralsight
• 1 hour 53 minutes
• On-Demand
• Free Trial Available

Power BI Data Methods

56 ratings at LinkedIn Learning

Get a comprehensive overview of the data end of Power BI—also known as Power Query—and learn how to use it to automate the data querying process and restructuring of data sets.

• LinkedIn Learning
• 3 hours 12 minutes
• On-Demand
• Free Trial Available

SQLBits

New Features in Power Query for Power BI, Fabric, and Excel

Discover the latest Power Query features in Power BI Desktop, Fabric Dataflows, and Excel, enhancing data transformation capabilities.

• YouTube
• 54 minutes
• On-Demand
• Free Video

SQLBits

Power Query in 20 Minutes - How it Works

Explore Power Query's internals and gain a deeper understanding of this increasingly prevalent tool in Power BI and Fabric technologies.

• YouTube
• 19 minutes
• On-Demand
• Free Video

SQLBits

Query Folding in Power Query: Importance for Performance

Discover query folding's importance for Power Query performance and learn factors that can hinder its effectiveness.

• YouTube
• 21 minutes
• On-Demand
• Free Video

Data Transformation with Power Query in Microsoft Excel

Power Query adds significant data preparation capabilities to many of Microsoft’s most popular data products. This course will teach you to connect, transform, combine, and load data from various sources using Power Query with Microsoft Excel.

• Pluralsight
• 48 minutes
• On-Demand
• Free Trial Available

ExcelIsFun

Master Power Query M Code and Data Shaping for Data Analysis

Master Power Query M Code for advanced data shaping and analysis. Learn M Code values, expressions, data types, operations, custom functions, and key functions like Table.AddColumn and Table.Group.

• YouTube
• 1 hour 50 minutes
• On-Demand
• Free Video

ExcelIsFun

Lookup Manager Names in Column Headers to Create Report - Excel Magic Trick 1866

Master Excel techniques to create reports by looking up manager names in column headers using functions like TOCOL, UNIQUE, IF, TEXTJOIN, and Power Query transformations.

• YouTube
• 12 minutes
• On-Demand
• Free Video