Retrieve, Transform, and Combine Data Using Power Query

Pluralsight
Course Summary
This course targets the Business Intelligence (BI) Self Service professional who needs to obtain and shape data from multiple and various sources so that the data can provide useful BI to report viewers. The focus of this coures is Power Query.
-
+
Course Description
Information today exists in multiple locations, from a simple text file, to social networks such as Facebook. Retrieving and then 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, Retrieve, Transform, and Combine Data Using Power Query, you'll see how Power Query provides the cornerstone to Microsoft's PowerBI solution which aims to solve just this problem. First, you'll learn how learn how to retrieve data from various sources, as well as how how to cleanse and shape the data so that you have the data in the format you desire. This is also known as mashing up the data. Next, you'll learn how to combine data from different sources. At this stage, you're able to provide new insights into your data. Finally, you'll learn how to share the queries you've created. By the end 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.
-
+
Course Syllabus
Course Overview- 1m 53s
—Course Overview 1m 53sIntroduction & Concepts- 18m 44s
—Power Query Introduction and Concepts 1m 38s
—Overview of the BI Tools in Excel 3m 52s
—Introduction to the Power Query Component Parts 5m 8s
—Review of Which Versions of Excel Can Use Power Query 2m 57s
—Demo - Install Power Query in Excel 2010, 2013, and 2016 3m 32s
—Summary 1m 33sData Retrieval- 17m 27sWorksheet vs. Excel Data Model- 12m 57sData Cleansing- 21m 27sCombining Queries- 16m 35sSharing and Reusing Queries- 12m 33sSummary- 11m 11s