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

Creating a report using the PowerPivot interface

Now, the users will have a clear idea about general data analysis and report creation, the traditional BI concepts, and especially multidimensional (OLAP) analysis, which have been clearly explained; some typical report explanations have also been given. PowerPivot supports the multidimensional data source which can only be added from Microsoft SQL Server Analysis Services (SSAS).

An OLTP system is nothing but an operational data source from which SQL queries can be used to get millions of rows from/to many tables connected by simple relations. Let's take Point-of-Sale applications ( POS ), wherein, in the operational database, there are around 214 tables and each table has lots of attributes. In ...

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