Business Intelligence with Excel : Power Query

What you will learn?

Connect to data sources from a variety of sources using Power Query

Transform data using Power Query's built-in functions and wizards

Combine data from multiple sources into a single query using Power Query

Load data into Excel worksheets, pivottables, and pivotcharts using Power Query

Group data and create data models using Power Query

Add custom columns and perform complex data transformations using Power Query

Use the Advanced Editor to write M code to customize your data transformations