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.
Author Name: Ben Howard
Author Description:
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.

Table of Contents

• Course Overview
  1min
• Introduction & Concepts
  18mins
• Data Retrieval
  17mins
• Worksheet vs. Excel Data Model
  12mins
• Data Cleansing
  21mins
• Combining Queries
  16mins
• Sharing and Reusing Queries
  12mins
• Summary
  11mins