All courses
Resource hub
Featured resource
pluralsight tech forecast
2025 Tech Forecast

Which technologies will dominate in 2025? And what skills do you need to keep up?

Check it out
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

Clean, Transform, and Load Data with Power BI

This course teaches optimizing Power Query in Power BI to load, cleanse, and transform data, which is essential in the PL-300 certification exam.

Thomas LeBlanc - Pluralsight course - Clean, Transform, and Load Data with Power BI
by Thomas LeBlanc
Get started Video play icon Preview course

What you'll learn

Power BI developers and analysts need to get up to speed on using Power Query in Power BI. In this course, Clean, Transform, and Load Data in Power BI, you will learn the three essentials for using Power Query. First, you'll see how data is sourced, and how cleaning the data involves handling nulls and defining descriptions for codes. Next, you'll explore how to transform data using options like first-row headers and pivoting a query’s columns. Finally, you'll discover how query folding completes the load to ensure database-level optimization. When you're finished with this course, you'll have the skills and knowledge required for passing the PL-300 exam section on cleaning, transforming, and loading data in Power BI.

Table of contents

About the author

Thomas LeBlanc - Pluralsight course - Clean, Transform, and Load Data with Power BI
Thomas LeBlanc

Microsoft Data Platform MVP specializing in SQL Server, Microsoft Business Intelligence (SSIS, SSAS & SSRS) and Power BI.

More Courses by Thomas