Clean, Transform, and Load Data with Power BI

Focused View

Thomas LeBlanc

1:03:28

26 View

01. Course Overview

01. Course Overview.mp4

02:06

02. Understand How to Clean Transform and Load the Data with Power BI

02. Get Data.mp4

02:51

03. Demo-Get Data.mp4

03:17

04. Power Query Home Menu.mp4

02:45

05. Demo-Basic Transformations.mp4

02:12

06. Transform and Add Column Menus.mp4

04:42

07. Demo-Transform and Add Column Menus.mp4

04:15

08. Advanced Editor and M Code.mp4

03:15

03. Cleanse Data in Power BI

09. Profile Data.mp4

03:09

10. Demo-Profiling Data.mp4

03:11

11. Cleanse Data by Using Replace Values.mp4

02:16

12. Demo-Replace Values.mp4

01:45

13. Cleanse Data with Errors and Blanks.mp4

01:24

14. Demo-Fill and Save Errors.mp4

02:18

04. Transform Data in Power BI

15. Column Transformations.mp4

02:54

16. Demo-Column Transformations.mp4

02:26

17. Transforming Rows.mp4

01:30

18. Demo-Transforming Rows.mp4

02:41

05. Load Data in Power BI

19. Loading with Queries.mp4

02:05

20. Demo-Merge Queries.mp4

02:46

21. Dimensional Model Keys.mp4

01:48

22. Demo-Concatenate Columns for Keys.mp4

03:21

23. Data Refreshes.mp4

04:31

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

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.