Summary
The ability for Excel users to combine multiple, related datasets and create compelling, insightful analytics is the principal feature of PowerPivot for Excel. After completing this chapter and related examples, you should understand the following:
- The principal use-case for PowerPivot for Excel is combining data from structured sources (data warehouses, data marts, or transactional databases) with data that lies outside the administration of the enterprise.
- PowerPivot for Excel can utilize data from a number of sources, including data at very high volumes. The only requirement is a logical relationship between the data.
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.
