Create an account to use AI

Create a free account to unlock all features:

Ask questions about videos with AI
Use smart search (AI)
Save your favorite videos
Bookmark your favorite categories
Organize your favorite subcategories
Access your personalized favorites page
Access your conversation history
Personalize your homepage with your favorites

Create an account

Already have an account? Log in

How POWER PIVOT Works in Excel | COMPLETE BASICS

Nils Maier

Here you will learn step by step the complete basics to combine datasets into a data model using Power Pivot, expand this data model, and create meaningful reports (with KPIs, graphs, etc.) based on it.

Datasets to WORK WITH (in a file): https://docs.google.com/spreadsheets/d/1f12vdRhzS2_oOyrFWTEUcqsMVbey4ByPrYJG291MIls/edit?usp=sharing

00:00 Introduction

00:31 Data Source

01:43 Adding Power Pivot

02:34 Merging Datasets

05:46 Relationships

08:07 Expanding Data Model

12:21 Creating Measures

17:45 Visualization with Pivot Tables

20:34 KPIs

22:27 Graphs

23:30 Slicer

24:15 Timeline

24:55 Outro

How POWER PIVOT Works in Excel | COMPLETE BASICS | Knoovi