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.
Author Name: Thomas LeBlanc
Author Description:
Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Enthusiast in Baton Rouge, La. He started his IT career as a COBOL programmer in 1989 while at LSU. Since then he has spent years as a developer, DBA and Data Warehousing/Business Intelligence Architect. Community involve includes the local SQL Server and Analytics User Groups as well as SQLSaturday. Speaking engagements have been a blessing at SQL Pass Summit, Live 360, VSLive and IT Dev Connections.

Table of Contents

• Course Overview
  1min
• Course Introduction
  11mins
• Cleanse Data in Power BI
  11mins
• Transform Data in Power BI
  14mins
• Load Data in Power BI
  20mins