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.