Summary

In this chapter, examples of using PowerPivot to access and analyze data from a SQL Server database were explored. Included in this chapter were details on the following:

• Using the Table Import Wizard to quickly establish a connection between PowerPivot and SQL Server
• Navigating the PowerPivot Field List to create a PivotTable or PivotChart
• Using PowerPivot to accomplish complex sorting and filtering without using Structured Query Language (SQL) or Multidimensional Expressions (MDX)

PowerPivot for Excel solution (.xlsx) files are compressed folders containing spreadsheet definition and formatting as well as data definitions and connections.