Chapter 4. Data Models

The first three chapters of this book introduced some basic Microsoft SQL Server PowerPivot for Excel features for generating interesting reports from existing data. In our examples, you discovered the need to model your data to make it easier to understand and manage. Nevertheless, because all the examples were introductory, data modeling was not an issue. It is now time to perform a deeper analysis of data modeling, discover 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. The PowerPivot world is not exceptional in that regard: a good data model ...

Get Microsoft® PowerPivot for Excel® 2010 now with O’Reilly online learning.

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