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.
Play course overview
Course info
Rating
(25)
Level
Intermediate
Updated
Apr 29, 2019
Duration
2h 1m
Table of contents
Course Overview
Course Overview 1m
Choosing the Right Tool for the Right Job
Choosing the Right Tool 6m What Problem Does Power Query Solve? 6m When Is Power Query the Wrong Tool? 3m Summary 0m
Navigating the Query Editor
What Is a Query? 6m Understanding the Query Editor Components 2m Demo: Accessing the Power Query Editor in Power BI 7m Demo: Accessing the Power Query Editor in Excel 6m Demo: Accessing the Power Query Editor in SSAS 6m Summary 1m
Adding and Removing Steps in Your Data Recipe
How Does Power Query Work? 4m Demo: Adding Steps 3m Demo: Removing Steps 2m Understanding Data Types 10m Demo: Working with Data Types 3m Summary 0m
Accessing the Underlying Query Code
Why Use M Code? 4m Accessing the Advanced Query Editor 3m Demo: Accessing the Advanced Query Editor 5m Sharing and Reusing Code 3m Demo: Creating a Power BI Data Flow 4m Demo: Creating a Custom Data Connector 7m Demo: Copying M Code 4m Summary 1m
Fixing Errors in Your Workflow
Where Do Errors Occur? 2m Demo: Fixing Errors in the Data 2m Demo: Replacing Error Values 2m Demo: Fixing Errors in the Transformation Steps 4m Demo: Using Try Logic 3m Summary 0m
Extending the Query Editor with R and Python
When Is M not Enough? 2m R or Python, Which Is Right for Me? 2m Demo: Installing R 2m Demo: Installing Python 4m Demo: Adding Python to Power BI 3m Summary 1m
Description
Course info
Rating
(25)
Level
Intermediate
Updated
Apr 29, 2019
Duration
2h 1m
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
Eugene Meidinger
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
Handling Streaming Data with Azure Event Hub
Intermediate
2h 23m
May 15, 2020
Distributing Excel Workbooks
Advanced
1h 29m
Jan 22, 2020
Querying and Shaping Data in Power BI Using M
Intermediate
2h 36m
Sep 11, 2019
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.

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT