With TFS 2013 and SharePoint 2013 Enterprise version you can use the Excel Services to display a number of reports to the internal and external teams. The Excel reports can provide management that instant view on how a project is progressing. Now a days, manager’s want to have quick real-time dashboard with meaningful data to view for decision making. For example, here are some common reports that can displayed.
Here is another example of SharePoint integration and Excel reporting
In most cases TFS will be installed on a different server then the SharePoint enterprise server. In order to enable the Excel reporting in the SharePoint 2013 enterprise version, you need to configure the Secure Store Service in order to perform a double hop authentication from the SharePoint server to the TFS App and Data tier. The Secure Store Services is required if you want to enable Excel Service for any of the sites within the SharePoint enterprise farm.
To get started. Here is the link that has a video demonstration on how to Configure the Secure Store Service in SharePoint 2013 enterprise
Once the Secure Store Service is setup, you can connect the TFS to the SharePoint farm. Below are links that will walk you thru the process (These links are for 2010, but the processes are the same).
Excel reports in SharePoint can be a powerful tool for displaying project status and other critical matrices to decision makers. With a little bit of work, you can create custom reports that a manager wants to see on a regular basis. By having the reports in the Excel Services and auto refresh set, that bi-weekly status report can be replaced by a simple URL, giving you back time that can be used on other important tasks.