Power BI Data Preparation Playbook

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.
Course info
Level
Intermediate
Updated
Apr 29, 2019
Duration
2h 2m
Table of contents
Description
Course info
Level
Intermediate
Updated
Apr 29, 2019
Duration
2h 2m
Description

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.

About the author
About the author

Starting out as an accidental DBA and developer, Eugene Meidinger now focuses primarily on BI consulting. He has been working with SQL Server for five years now, and is certified in Querying and Administering SQL Server 2012. He regularly presents at various SQL Saturday events.

More from the author
Querying and Shaping Data in Power BI Using M
Intermediate
2h 37m
Sep 11, 2019
Deploying and Publishing Power BI Reports
Intermediate
1h 45m
Oct 16, 2018
More courses by Eugene Meidinger
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name's Eugene Meidinger, and welcome to my course, Power BI Data Preparation Playbook. I'm an independent business intelligence consultant. Power query was designed to be an approachable data preparation tool that doesn't require any coding experience. In this course, we're going to cover navigating the query editor, adding and removing data transformations, accessing the underlying M code, and identifying and resolving errors. By the end of this course, you'll know how to clean your data with Power Query. Before beginning this course, you should be familiar with Power BI Desktop or Excel.