Microsoft Excel 2013: Building Data Models with PowerPivot

Chapter 4. Understanding data models

The first chapters of this book introduced some basic Microsoft PowerPivot features for generating interesting reports from existing data. In several examples, you discovered the need to model your data to make them easier to understand and manage. Nevertheless, because all the examples were introductive ones, data modeling was not an issue. It is now time to perform a deeper analysis of data modeling, so you can learn what it is and how to handle different data models.

Data modeling is not a new concept for database analysts and administrators. These technicians already know that a good data model is the foundation of a good database solution. In the world of Microsoft Excel, the same applies: a good data model ...