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

A data model in PowerPivot

Preparation of data for analysis has been done, but for full and meaningful analysis relationships have to be created between the tables that were imported from different data sources. By creating a relationship, integration of columns, creation of attribute formats, metrics, and calculation of columns using DAX for our analysis and advanced reporting can be done as per the requirements. One of the prominent things here is that a hierarchy can be created based on these attributes. So finally the logical design of the PowerPivot interface will be based on the star schema, the snowflake schema, or the constellation schema. After all these processes in the PowerPivot interface are completed, it will fulfill the third principle ...

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