SQL Server Reporting Services are supported for more advanced reporting against the data warehouse or the Analysis Services data cube.These installations can be on the same system or on different systems.
'Oe' configuration database per TFS instance stores project collection metadata.
Data from the project collection databases is aggregated into the warehouse database, which denormalizes the data in preparation for loading into an Analysis Services cube.
Microsoft Project can be used to schedule work when conforming to a waterfall software development methodology.
Both Excel and Project support bi-directional updates of data.
These tools provide full access to the features in TFS.