Power BI Data Preparation Playbook

by Eugene Meidinger

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.

Preview this course

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.

Table of contents

Course Overview
1min
Choosing the Right Tool for the Right Job
15mins
Navigating the Query Editor
28mins
Adding and Removing Steps in Your Data Recipe
22mins
Accessing the Underlying Query Code
31mins
Fixing Errors in Your Workflow
13mins
Extending the Query Editor with R and Python
14mins

About the author

Eugene Meidinger

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.

See more courses by Eugene Meidinger
Ready to upskill? Get started