Power Pivot and Power Query Essentials

3 courses , 43 lessons , 9 exercises , 3 exams

Learn the core functionality of Power Pivot and Power Query, including how to connect to, transform, and manipulate datasets.

Course List (3)

Introducing Power Pivot

Power Pivot is a data modeling tool available within Excel. This course will introduce the important points of the Excel data model, and show you how to create Pivot Tables and Pivot Charts using the data model.

15 lessons
55 minutes
Created with Sketch. Intermediate
Developing and Visualizing Your Data Model

In our second course on Power Pivot, we will look at more of the important features of Power Pivot, such as date tables and hierarchies. We will also look at options for displaying your data that go beyond Pivot Tables, such as Power Maps and Power View.

11 lessons
50 minutes
Created with Sketch. Intermediate
Power Query

Power Query (or Get and Transform in Excel 2016) lets you import data from a variety of sources into Excel. You can also transform awkwardly formatted data into an appropriate layout for data analysis, as we’ll see in this course.

17 lessons
1 hour 1 minute
Created with Sketch. Intermediate