If you’ve ever needed to build a Pivot Table from multiple tables at once without resorting to a tangle of VLOOKUPs to merge everything first, Power Pivot and the Data Model is the feature you’ve been missing. In this episode, Mike explains what the Data Model is, why it exists, and how Power Pivot fits into the picture.
The Data Model’s headline feature is its ability to store multiple tables and create relationships between them, so your Pivot Tables can draw from several data sources simultaneously. Mike walks through how to get data into the Data Model correctly and why Power Query is the best route for doing so.
He also covers how to enable Power Pivot, how to define relationships between tables in Diagram View, and what actually happens when a Mac user opens a file that contains a Data Model.
Note: this episode is Windows-only territory as Excel for Mac doesn’t support the Data Model.
Resources