Overview of 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.

In This Section

• Create a PivotTable or PivotChart Report

• Create a Reporting Services Report with PowerPivot Data

• Create a Measure in a PivotTable or PivotChart

• Create and Change the Field Layout in a PivotTable or PivotChart Report

• Delete a PivotTable or PivotChart Report

• Filter Data using Slicers

• Work with Relationships in PivotTables

• Change the Display Language

See Also

Concepts

Introducing PowerPivot for Excel

Share Data from PowerPivot

Other Resources

Add and Maintain Data in PowerPivot

Prepare Data for Analysis in PowerPivot

Data Analysis Expressions (DAX) Language

UI Reference (PowerPivot for Excel)