C H A P T E R  8

images

PowerPivot As a Data Source

If I have seen further it is only by standing on the shoulders of giants.

—Sir Isaac Newton

At the most basic level, there are three tiers that comprise a business intelligence (BI) solution. The most immediately visible tier is the consumption or user interface tier, which provides a means for user actions to be translated into the information presented in filtering, formatting, or both. Examples of tools and products in this tier would include SQL Server Reporting Services, Excel, and dashboards in SharePoint.

The consumption tier can be thought of as a window into the next tier, the data tier. ...

Get PowerPivot for Business Intelligence Using Excel and SharePoint now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.