Power Query Courses and Certifications

Power BI Certification Program

122 ratings at Noble Desktop

Master data analysis and visualization with hands-on Power BI training, from connecting data sources to creating interactive reports and earning Data Analyst Associate certification.

• Noble Desktop
• 18 hours
• On-Demand
• $1,899.00

Power BI Financial Statements

92 ratings at Corporate Finance Institute

A Scenario-Based Deep Dive into Power BI for Financial Statement Automation and Analysis Master the integration of SQL, Power Query, Power BI, Excel, and DAX for comprehensive financial data analysis

• Corporate Finance Institute
• 3 hours 20 minutes
• On-Demand
• Paid Course

Mistrz Power Query w Excelu

1033 ratings at Udemy

Zostań Mistrzem pobierania i analizy danych w Excelu za pomocą Power Query

• Udemy
• 10 hours 25 minutes
• On-Demand
• Paid Course

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

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
• 16 hours
• On-Demand
• Paid Course

ExcelIsFun

Approximate Match Lookup in Power Query - Amazing Functions for Power BI and Excel

Discover powerful approximate match lookup techniques in Power Query using custom functions. Learn to create efficient solutions with Table.SelectRows and List.Accumulate for Excel and Power BI data analysis.

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

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

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

ExcelIsFun

Power Query and M Code to Transform Data and Create Final Marketing Customer Coupon Report - EMT 1902

Master advanced Power Query and M Code techniques to transform data and build complex marketing reports with customer coupon analysis and grouping.

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

ExcelIsFun

Power Query: A Cleaner Way to Import and Append CSV Files - The Transformative Power of M Code

Master a cleaner approach to importing and appending CSV files in Power Query using M code, including extracting filenames, adding columns, and using let expressions to streamline your data transformation process.

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

ExcelIsFun

Power Query Unpivot with 2 Column Variables - Bad Data Into Good Data - Excel Magic Trick 1916

Master Power Query's unpivot technique to transform cross-tabulated data with dual column variables into clean, analyzable datasets using transpose, merge, and split operations.

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

ExcelIsFun

Power Query Custom Function with Parameter to Get and Transform Multiple CSV Files Data - EMT 1919

Master Power Query custom functions with parameters to efficiently import and transform multiple CSV files into a unified dataset using M Code techniques.

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

ExcelIsFun

Power Query Nested Functions in Custom Column - Convert Multiple CSV Files into One Table - EMT 1918

Master nested Power Query functions to transform multiple CSV files with cross-tabulated data into a single, properly structured table using advanced M Code techniques.

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

Simon Sez IT

Master Data Cleaning Essentials with Power Query and Excel

Master essential data cleaning techniques using Excel and Power Query to transform messy datasets into organized, analysis-ready information with automated tools and refreshable reports.

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

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