Retrieve, Transform, and Combine Data Using Power Query

Aperçu

Targeting the Business Intelligence (BI) Self Service professional, this course teaches you how to obtain and shape data from multiple and various sources to provide useful BI to report viewers. The focus is on mastering Power Query.

Information today exists in multiple locations, from simple text files to social networks like Facebook.

Retrieving and combining related information from such disparate data sources to provide meaningful insights has historically been challenging. In this course, Retrieve, Transform, and Combine Data Using Power Query, you'll see how Power Query serves as the cornerstone to Microsoft's PowerBI solution, tackling this challenge head-on.

Initially, you will learn how to retrieve data from different sources and cleanse and shape it to your desired format—known as mashing up the data.

Next, you'll learn how to combine data from various sources, enabling you to uncover new insights. Finally, you'll discover how to share the queries you've created.

By the end of this course, you'll be proficient in using Power Query to access disparate data sources, cleanse and transform the data, and prepare it to be used in powerful ways to provide fresh insights into your world of data.

University:

Provider

Provider:

Pluralsight

Categories:

Matières