5. Creating and Managing Relationships

One of the massive benefits of PowerPivot is the possibility of creating pivot tables from multiple tables. When you have two or more tables, you are going to rely on the concept of relationships to join the tables together.

Good news: Relationships are easier to define than VLOOKUPs are to set up.

Mildly good news: In some simple cases, PowerPivot can autodetect the relationship correctly.

Good news: If you don’t want to rely on automatic ...

Get PowerPivot for the Data Analyst: Microsoft now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.