O'Reilly logo

PowerPivot for Advanced Reporting and Dashboards by Robert Bosco J

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 3. Data Model

In business intelligence technology, the prominent logic of the data model design is that if the user designs a good logically designed schema, they can easily analyze a large volume of data. This chapter gives the fundamental concepts of a data model and how to design the logical schema based on the data sources.

A successful importation of two industry-type data for the analysis has been done in the previous chapter. In this chapter, a fundamental idea about the data model design will be given and we will continually learn how to practically design a data model for the imported data with the use of PowerPivot functionalities.

Data model

The preceding diagram illustrates how a data model inside the PowerPivot Workbook will ...

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