Getting Started with Power Query - Part I

Today we're starting with the first step of the data analysis process: Discover and Get Data.

Power Query allows you to easily discover and connect to data from public and corporate data sources. This includes new data search capabilities to facilitate discovery, as well as capabilities to easily transform and merge data from multiple data sources, so you can analyze the data in Excel.

In the following video you'll learn how to:

Perform an Online Search, import public data results, and visualize these results in 3 easy steps with Excel

Apply some easy transformations to your newly gathered data with the Power Query editor

Connect to external Data Sources

Files

Data Bases

Web

Perform more complex data transformations such as changing the data type, deleting columns and adding calculated fields while saving your steps on the Query editor