Power BI Data Preparation Playbook

Focused View

Eugene Meidinger

2:01:56

49 View

01 - Course Overview.mp4

00:46

02 - Choosing the Right Tool.mp4

05:54

03 - What Problem Does Power Query Solve.mp4

05:41

04 - When Is Power Query the Wrong Tool.mp4

02:42

05 - Summary.mp4

00:25

06 - What Is a Query.mp4

06:07

07 - Understanding the Query Editor Components.mp4

02:20

08 - Demo - Accessing the Power Query Editor in Power BI.mp4

07:24

09 - Demo - Accessing the Power Query Editor in Excel.mp4

05:58

10 - Demo - Accessing the Power Query Editor in SSAS.mp4

05:30

11 - Summary.mp4

00:44

12 - How Does Power Query Work.mp4

03:34

13 - Demo - Adding Steps.mp4

03:12

14 - Demo - Removing Steps.mp4

02:07

15 - Understanding Data Types.mp4

10:00

16 - Demo - Working with Data Types.mp4

02:51

17 - Summary.mp4

00:24

18 - Why Use M Code.mp4

04:28

19 - Accessing the Advanced Query Editor.mp4

02:44

20 - Demo - Accessing the Advanced Query Editor.mp4

04:54

21 - Sharing and Reusing Code.mp4

02:39

22 - Demo - Creating a Power BI Data Flow.mp4

03:31

23 - Demo - Creating a Custom Data Connector.mp4

06:36

24 - Demo - Copying M Code.mp4

03:33

25 - Summary.mp4

01:15

26 - Where Do Errors Occur.mp4

02:20

27 - Demo - Fixing Errors in the Data.mp4

02:15

28 - Demo - Replacing Error Values.mp4

01:43

29 - Demo - Fixing Errors in the Transformation Steps.mp4

03:36

30 - Demo - Using Try Logic.mp4

02:37

31 - Summary.mp4

00:24

32 - When Is M not Enough.mp4

02:08

33 - R or Python Which Is Right for Me.mp4

02:26

34 - Demo - Installing R.mp4

02:13

35 - Demo - Installing Python.mp4

03:41

36 - Demo - Adding Python to Power BI.mp4

02:35

37 - Summary.mp4

00:39

File.zip

Description

To model your data in Power BI, you need to clean it up first. In this course, you will learn to use Power Query, including how to navigate the Power Query editor, add data transformation steps, fix errors, and make advanced changes.

What You'll Learn?

In order to model your data in Power BI, you need to clean it up first. In this course, Power BI Data Preparation Playbook, you will learn how to do so with Power Query. First, you’ll learn when Power Query is the right tool for the job, and how to navigate the Power Query editor. Next, you’ll explore how to add data transformation steps and access the underlying query code. Finally, you’ll discover how to fix errors and go even further using Python and R. By the end of this course, you'll feel completely comfortable using the Power Query Editor.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Big Data

Microsoft Power BI

Eugene Meidinger

Instructor's Courses

Eugene Meidinger works as an independent BI consultant and Pluralsight author, specializing in Power BI and the Azure Data Platform. He has been working with data for over 8 years and speaks regularly at user groups and conferences. He also helps run the GroupBy online conference.

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.