Expanded Library

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.

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.

About the author

Ready to upskill? Get started