Introduction to Power Pivot

Power Pivot in Excel

Nick Edwards

Analyst at Roofstock

Your instructor

Picture of Nick Edwards

Nick Edwards, Analyst at Roofstock

7+ years in FinTech
Former Trader at Rocket Mortgage
Managed and traded billions of dollars worth of real estate assets
Check out my other courses on DataCamp!

"Harnessing the power of data analytics will empower you to make better choices."

Course overview

Cartoon image of business people smiling

Power Pivot in Excel
Prerequisites
- Data Preparation in Excel
- Introduction to Power Query in Excel

What is Power Pivot?

Power Pivot icon

Excel add-in
Analytical tool used to:
- Create models
- Perform calculations
- Generate interactive reports

Is Power Pivot the right tool?

Excel versus Power Pivot vs Power BI

Is Power Pivot the right tool?

A chart comparing Pivot Tables, Power Pivot and Power BI

Is Power Pivot the right tool?

A chart comparing Pivot Tables, Power Pivot and Power BI

Is Power Pivot the right tool?

A chart comparing Pivot Tables, Power Pivot and Power BI

Is Power Pivot the right tool?

A chart comparing Pivot Tables, Power Pivot and Power BI

Power Query + Power Pivot = Powerful!

Big muscles with Power Query and Power Pivot

Is Power Pivot the right tool?

A chart comparing Pivot Tables, Power Pivot and Power BI

Is Power Pivot the right tool?

A chart comparing Pivot Tables, Power Pivot and Power BI

Exploratory data analysis

The process of understanding data and extracting insights from it.

Process flow of exploratory data analysis

Exploratory data analysis

The process of understanding data and extracting insights from it.

Process flow of exploratory data analysis

Exploratory data analysis

The process of understanding data and extracting insights from it.

Process flow of exploratory data analysis

Welcome to Pivotal!

Your role:
- A consultant for Pivotal Mortgage
- Analyze mortgage sales in 2021

Let's practice!

Power Pivot in Excel

Preparing Video For Download...