The TFS Datawarehouse schema is well documented here

http://msdn.microsoft.com/en-us/library/ee620640(v=vs.120).aspx

As an example, let's say we wanted to get this kind of data in the following form into Excel.

We can use the following SQL statement.

Use Tfs_Warehouse

Go

Select IterationPath, StartDate, FinishDate from DimIteration order by StartDate, IterationPath

This yields as follows:

If we were to create new iterations, we can process the Warehouse immediately through a web service. Select ProcessWarehouse link from the following URL.

http://msdn.microsoft.com/en-us/library/ff400237.aspx

This provides the following screen.

Finally, use the following link to use the query to populate an Excel spreadsheet.

http://office.microsoft.com/en-us/excel-help/use-microsoft-query-to-retrieve-external-data-HA010099664.aspx