Retrieve, Transform, and Combine Data Using Power Query

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 course is Power Query.
Course info
Rating
(36)
Level
Intermediate
Updated
Jan 27, 2017
Duration
1h 53m
Table of contents
Description
Course info
Rating
(36)
Level
Intermediate
Updated
Jan 27, 2017
Duration
1h 53m
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.

About the author
About the author

Ben is a Microsoft Project, Project Server/Online consultant, and Data Specialist with over 20 years of implementation experience. He has been a Microsoft MVP for nine years, as well as blogging on various project server scenarios, has articles published on the Microsoft Project User Group (MPUG), and is the author of Microsoft Project 2013 Plain & Simple.

More from the author
Displaying Tables with Excel
Advanced
1h 35m
Oct 17, 2019
Summarizing and Organizing Data in Excel
Beginner
1h 3m
Aug 20, 2019
More courses by Ben Howard
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone, my name is Ben Howard and welcome to my course called Retrieve, Transform, and Combine Data using Power Query. I'm a principle consultant at Apple Park Limited. Now I first got interested in Power Query several years ago with the introduction of Project Online. It soon became apparent that Power Query provided me with the tools to analyze and visualize the Project Online data using oData, Power Query, Power BI, and Excel and I became an overnight convert to the world of self service BI or business intelligence. And in truth, I haven't looked back since. In this course we're going to look at how to install Power Query in the various versions of Excel and then we'll cover off the following topics. We'll learn how to retrieve data from various sources. We'll learn how to cleanse and shape that data so that we have it in the format that we desire, this is also known as mashing up the data. We'll learn how to combine data from different sources, at this stage we're able to provide new insights into our data. Finally, we'll learn how to share the queries that we've created and finessed. By the end of this course you'll know how to use Power Query to access disparate data sources, cleanse and transform data and prepare it so that it can be used in super powerful ways to provide new insights into your world of data. Before beginning this course you should, of course, be familiar with Excel. I now hope you'll join me on this journey to learn more about Power Query with Retrieve, Transform, and Combine Data using Power Query course at Pluralsight.