Filling the Gap with PowerPivot for Excel
PowerPivot for Excel takes advantage of technologies that are a part of SQL Server 2008 R2, to enable an information worker to manipulate, filter, and sort millions of data rows on a commodity PC. Because of this, PowerPivot for Excel is uniquely positioned to fill the gap between the corporate data store and other related data, which is required for a complete decision picture. Data can be combined from any of the sources below into a single PowerPivot for Excel solution, for analysis without knowledge of Structured Query Language (SQL) or Multidimensional Expressions (MDX).
- SQL Server relational database
- Microsoft Access database
- SQL Server Analysis Services
- SQL Server Reporting Services (SQL 2008 ...
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.
