Creating Reports, Charts, and PivotTables

You can use PivotTable reports, PivotChart reports, and Reporting Services reports to summarize, analyze, explore, and present summary data. PivotTables and PivotCharts can be created in both Excel and PowerPivot for Excel. However, when you use PowerPivot, the following features are available to make analysis even more powerful:

  • Enhanced Slicers, which can be used interactively to display data changes when you apply filters.

  • The Data Analysis Expressions (DAX) language, for easily building formulas that use columns and tables.

  • The ability to create relationships between tables, to use lookups, and to calculate using table lookups.

If you are new to PivotTables, Excel online Help provides many walkthroughs and tutorials. If you are familiar with PivotTables and want to learn how to use the new features in PowerPivot, see the topics in this section.