Expanded Library

Clean, Transform, and Load Data with Power BI

by Thomas LeBlanc

This course will teach you cleansing, transforming, and loading functions of Power BI related to the DA-100 exam.

What you'll learn

Power BI has brought extract, transform and load features to this visualization tool through Power Query. In this course, Clean, Transform, and Load Data in Power BI, you will learn how to use Power Query in Power BI. First, Power Query will be connected to a data source and place in a development environment for cleansing. Next, transforming the data and structure will use Ribbon buttons to drive the final structure. Finally, loading the data involves the final steps for bring the data into the Power BI report canvas. When finished with this course, you will have the skills and knowledge required for passing the DA-100 exam section on clean, transform, and load data in Power BI.

About the author

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.

Ready to upskill? Get started