O'Reilly logo

Microsoft® PowerPivot for Excel® 2010 by Alberto Ferrari, Marco Russo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required