Using PowerPivot in Excel 2013 - Business Intelligence in Microsoft SharePoint 2013 - page 111

The Manage Relationships and the Create Relationship dialog boxes are similar to the correspond-
ing dialog boxes in previous versions of PowerPivot.

Working with the data Model
After you create the Data Model in a workbook and have related tables, you can create PivotTables,
PivotCharts, and Power View reports. Power View is a new Excel 2013 add-in that you use to ana-
lyze data visually. (For more information about Power View, see Chapter 5.) PivotTables and Pivot-
Charts that you create in the Data Model have the following advantages over classic PivotTables and
PivotCharts:

You can work with considerably more data. You can import and work with hundreds of mil-
lions of rows thanks to the compression algorithms used by the Data Model's xVelocity engine.

■

You can work with multiple tables and easily import, create, and manage relationships
between tables.

■

PivotCharts that you create with the Data Model do not require a corresponding PivotTable.

■

Regardless of whether you use PivotTables and PivotCharts with Data Models or the classic Excel
PivotTables and PivotCharts, you can create implicit measures, apply custom calculations, use slicers,
and use a Timeline (new to Excel 2013). However, you can substantially extend the analysis capabilities
of Data Model-based PivotTables and PivotCharts by using PowerPivot.

PowerPivot 2013

Up to this point, you've already seen that you can do many things with Excel 2013 right out of the box
when creating simple reports by using the Data Model. But, to create richer, more complex reports,
KPIs, hierarchies, perspectives, to use DAX to work with data, or even to view or delete a table, you
need the PowerPivot Add-in.

More Info The subjects of data modeling and DAX with Excel 2013 and PowerPivot are
large topics, deserving topics of their own. A full explanation is beyond the scope of this
topic, but you can ind a more complete and in-depth view of DAX and PowerPivot for
Excel features in Microsoft Excel 2013: Building Models with PowerPivot (2013, Microsoft
Press), by Alberto Ferrari and Marco Russo.

PowerPivot comes with Excel 2013. Unlike the add-in for Excel 2010, you no longer need to
download anything. PowerPivot 2013 provides essentially the same functionality as the 2010 version,
although a few things have changed in the user interface.

PowerPivot 2013 is not enabled by default. To enable it, click the File tab to display the Backstage
view and then click the Options tab, as illustrated in Figure 4-19.