Power View within Excel 2013
This section describes using Power View within Excel 2013, which requires the ProPlus Edition of Office 2013. Note that Power View is not supported within Excel 2010 or earlier versions.
Setup
Power View is an add-on in Excel 2013 that you can enable by following these steps:
In Excel, navigate to FILE | Options | Add-Ins.
In the Manage box, click on the drop-down arrow and select COM Add-ins. Now, click on Go.
Check the Power View checkbox and click on OK.
If the Power View add-on has not been enabled, it will be grayed out on the Excel Insert menu.
Data models
Excel 2013 (ProPlus Edition) now has native support for data models. A data model is a brand new approach to integrating data from multiple tables, in essence, building a relational data source right inside an Excel workbook. The data models are used transparently to provide the tabular data used in a Power View report.
When importing relational data, a data model will be created implicitly when you select multiple...