CHAPTER 35
Introducing Power Pivot
Recognizing the importance of the business intelligence (BI) revolution and the place Excel holds within it, Microsoft has made substantial investments in improving Excel's BI capabilities, specifically focusing on Excel's self-service BI capabilities and its ability to manage and analyze information better from the increasing number of available data sources.
The key product of this endeavor is Power Pivot. With Power Pivot comes the ability to set up relationships between large, disparate data sources and to merge data sources with hundreds of thousands of rows into one analytical engine within Excel.
Starting with the release of Excel 2013, Microsoft has incorporated Power Pivot directly into Excel. This means the powerful capabilities of Power Pivot are available to you right out of the box!
In this...
