PowerPivot is a great free add-in for Excel from Microsoft that enables sophisticated business intelligence solutions and dashboards in three ways:
- Process millions of records from multiple databases, files, and other data streams
- Join tables and data in Excel , specify relationships without needing build queries in SQL or Access.
- Build sophisticated analyses based on pivot tables using DAX functions (similar to Excel functions, but more powerful)
It’s a free addin from Microsoft and exists in 32 bit and 64 bit versions.
PowerPivot (free download)
MSDN has extensive tutorials . and sample datasets
PowerPivot Pro blog from a PowerPivot expert
PowerPivot for Excel 2010: Giving Your Data Meaning
This book gives an overview of concepts and techniques with a lot
of examples on integrating data, creating DAX formulas, and building
dashboards and charts using Powerpivot.