Data Preparation with Power Query in Power BI
This course will teach you how to use Power Query to load, cleanse, manipulate, and prepare your data for visualization and use in Power BI.
What you'll learn
Information today exists in many locations, from a simple text file, to databases and social networks such as Facebook. Retrieving and combining related information from such disparate data sources in order to provide meaningful insights into the information has, historically, been a difficult, if not impossible task. In this course, Data Preparation with Power Query in Power BI, you'll see how Power Query provides the cornerstone to Microsoft's Power BI solution which aims to solve just this problem. First, you'll learn how to retrieve and load data from various sources into Power Query. Next you’ll discover how to manipulate the data by fixing errors and inconsistent values, but also you’ll learn how to infer new data from the existing data. Finally, you'll explore how to combine data from different sources, and present a single, unified dataset. When you’re finished with this course, you'll know how to use Power Query to access disparate data sources, cleanse and transform the data, and prepare it so that it can be used in super powerful ways to provide new insights into your world of data.
Table of contents
About the author
Ben is a Power BI & Data Specialist with a healthy interest in Microsoft BI and planning tools. He has over 30 years of customer and implementation experience, has been a Microsoft MVP for 14 years, is a frequent speaker at several European conferences, and blogs and creates videos on a semi-regular basis. He is actively engaged in providing consultancy to UK FTSE companies, and co-runs the Manchester Power BI User Group.