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.
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.
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.
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.