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.
Overview
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.
Syllabus
- Course Overview 1min
- Course Introduction 11mins
- Cleanse Data in Power BI 11mins
- Transform Data in Power BI 14mins
- Load Data in Power BI 20mins
Taught by
Pluralsight
