Clean, Transform, and Load Data with Power BI

Focused View

Thomas LeBlanc

59:54

141 View

1. Course Overview

1. Course Overview.mp4

01:56

2. Course Introduction

1. Introduction to Power Query.mp4

06:05

2. Demo - Power Query.mp4

05:54

3. Cleanse Data in Power BI

1. Column Profiling.mp4

02:08

2. Demo - Column profiling.mp4

03:25

3. Replacing Bad Data.mp4

01:29

4. Demo - Replacing Bad Data.mp4

01:35

5. Fill Up or Down and Handling Errors.mp4

01:02

6. Demo - Fill Down and Handling Errors.mp4

01:38

7. Cleansing Summary.mp4

00:24

4. Transform Data in Power BI

1. Steps to Transform Data.mp4

03:11

2. Demo - Steps to Transform Data.mp4

03:41

3. Columns and Row Transformations.mp4

02:30

4. Demo - Columns and Row Transformations.mp4

04:11

5. Summarizing Transformations.mp4

00:39

5. Load Data in Power BI

1. Load Query Functions.mp4

02:04

2. Demo - Merge Queries.mp4

04:08

3. Relationship Keys between Fact and Dimension Tables.mp4

01:39

4. Demo - Multi-column Keys for a Many to Many Relationship.mp4

06:00

5. Data Refreshes.mp4

01:57

6. Demo - Data Refreshes.mp4

02:28

7. Load Data Summary.mp4

01:50

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Power Query

Thomas LeBlanc

Instructor's Courses

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.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.