Using Microsoft Excel for Team Foundation Server Reporting
You can create ad-hoc queries and reports in Microsoft Excel to help manage your team project. Microsoft Excel allows you to connect to the Team Foundation data warehouse and display data from the warehouse as a PivotTable or PivotChart report.
To set up the data warehouse as a data source for Microsoft Excel, you will need the Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider installed on the computer where you use Excel. The driver is available online through the Microsoft Download Center at http://go.microsoft.com/fwlink/?LinkID=94415.