Power Query Courses and Certifications

ExcelIsFun

The Magic of Power Query to Import, Transform & Load Data

Learn to import, clean, and transform data using Power Query in Excel. Master techniques for efficient data handling, report creation, and automated updates.

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

ExcelIsFun

Power Query Group By Feature and Table.Group Function - Examples

Learn Power Query's Group By feature with five practical examples, including calculating totals, standard deviation, joining names, and ranking sales.

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

ExcelIsFun

Power Query - 6 Types of Joins, 6 Types of Merges - 9 Examples

Explore Power Query's 6 types of joins and merges through 9 practical examples, enhancing your data analysis skills in Excel with step-by-step guidance.

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

ExcelIsFun

Power Query - Excel.CurrentWorkbook Function to Append All Excel Tables in Excel Workbook

Master Excel's Power Query to efficiently append tables, handle recursion issues, and manipulate data using advanced functions like Excel.CurrentWorkbook and Table.ColumnNames.

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

ExcelIsFun

Power Query Power BI - Transform 2 Fact Tables to Star Schema Data Model - Invoice Data

Transform invoice data into a star schema using Power Query, creating a single fact table for improved reporting and analysis in Power BI Desktop.

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

ExcelIsFun

Excel Basics - Power Query (Get & Transform) to Clean & Transform Data into Proper Data Set

Learn to use Power Query in Excel for data cleaning, transformation, and analysis. Master importing, combining, and refreshing data from various sources to create proper datasets and pivot tables.

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

ExcelIsFun

Power Query Count & Extract Customer Names for 8 Sales Coupon Groups

Learn advanced Power Query techniques to analyze customer coupon usage across multiple stores, including counting and extracting customer names for various coupon groups.

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

ExcelIsFun

Standard Deviation with Criteria - Power Query, PivotTable, or Array Formula

Learn advanced Excel techniques for calculating standard deviation using Power Query, PivotTables, and array formulas. Master data analysis with practical examples and step-by-step guidance.

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

ExcelIsFun

Backwards One to Many Relationship Report - Excel, Power Query or SQL?

Learn advanced Excel techniques for calculating average GPA across related tables using array formulas, DAX, Power Query, and SQL. Master data analysis skills for complex relationships.

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

Career Certificate

Learn Data Visualization with Power BI

162 ratings at Boot.dev

Master Power BI fundamentals: connect data sources, create interactive visualizations, use DAX for complex modeling, and build compelling dashboards that transform raw data into insights.

• Boot.dev
• 12 hours
• Self-Paced
• Paid Course

Career Certificate

Power BI Bootcamp

133 ratings at Noble Desktop

Master data visualization and analysis with Power BI by learning to create interactive reports, transform data using ETL processes, build custom visualizations, and effectively manage datasets and dashboards.

• Noble Desktop
• 12 hours
• Self-Paced
• $799.00

Introduction to Power BI

4 ratings

Master the Power BI basics and learn to use the data visualization software to build impactful reports.

• DataCamp
• 4 hours
• Self-Paced
• Free Trial Available

Power BI Fundamentals

Gain the essential skills you need to use Power BI. Create your own visualizations and dashboards from scratch. No prior experience required.

• DataCamp
• 17 hours
• Self-Paced
• Free Trial Available

Data Analyst in Power BI

Co-created with Microsoft—gain the Power BI skills you need to prepare, model, and visualize data for the PL-300 Data Analyst certification.

• DataCamp
• 2 days 2 hours
• Self-Paced
• Free Trial Available

Data Modeling in Power BI

Learn the key concepts of data modeling on Power BI.

• DataCamp
• 3 hours
• Self-Paced
• Free Trial Available