Power Query Courses and Certifications

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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• Free Video

Simon Sez IT

How to Import External Data in Power Query - Beginners Guide

Learn how to import external data in Power Query with this step-by-step guide. Connect to Excel files, CSV files, databases, and web pages, then explore basic data cleaning and transformation techniques for your analysis needs.

• YouTube
• 12 minutes
• Self-Paced
• Free Video

Simon Sez IT

How to Extract Data and Clean It Using Power Query in 15 Minutes

Master data extraction and cleaning with Power Query in Excel - import raw data, fix common issues, and prepare tables for analysis in just 15 minutes with repeatable techniques.

• YouTube
• 16 minutes
• Self-Paced
• Free Video

Simon Sez IT

Data Cleaning With Power Query - Automate Boring Tasks

Automate data cleaning workflows using Power Query to eliminate repetitive tasks and build refreshable processes that update with one click for faster, reliable Excel results.

• YouTube
• 19 minutes
• Self-Paced
• Free Video

Simon Sez IT

Data Cleaning in Excel - Text Functions and Power Query

12 ratings

Learn essential data cleaning techniques in Excel using text functions and Power Query. Master importing, formatting, and manipulating data for accurate analysis and improved efficiency.

• YouTube
• 1 hour 8 minutes
• Self-Paced
• Free Video

Power BI Basics: Requirements to Visualizations

Master Power BI fundamentals from business requirements to data visualization, covering interface navigation, data modeling, and transformation techniques for beginners.

• Coursera
• 14 hours 52 minutes
• Self-Paced
• Paid Course

Corporate Finance Institute

Financial Statements in Power BI

43 ratings at Coursera

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
• Self-Paced
• Paid Course