Data is everywhere, but when you need to use it it’s rarely in the right format or error free. 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 or Excel.
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.
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.
