Introduction to Power Pivot: Excel's data model

Power Pivot: Excel's data model has two main features: Create Pivots from multiple tables using one to many table relationships, and write your own custom measures using DAX code. I go through both here as well as how to set it up

00:00 - Introduction
02:28 - Create relationships
04:04 - Custom measures
06:50 - Relationship errors
09:22 - DISTINCT COUNT
10:48 - Convert Pivot to formulas
11:16 - Power Pivot window
12:29 - Power Pivot tab on ribbon
13:01 - Get Power Pivot add in