- Course
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.
Intermediate
- Course
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.
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
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.
Clean, Transform, and Load Data with Power BI
Intermediate
Table of contents
Microsoft Data Platform MVP specializing in SQL Server, Microsoft Business Intelligence (SSIS, SSAS & SSRS) and Power BI.