Professional Team Foundation Server 2013

Chapter 15Reporting and SharePoint Dashboards

What's in this chapter?

• Learning about the changes and new features
• Understanding the Team Foundation Server data warehouse
• Understanding the tools available to create and manage reports
• Using the new Work Item Charting in Web Access
• Creating and customizing reports using Excel
• Extending and customizing the data warehouse and dashboards

One of the key value propositions for Team Foundation Server has always been the reporting features that it provides. When you have your source control, work-item tracking, and build and test case management systems all integrated in a system like Team Foundation Server, the reporting can provide powerful insight into the status of your projects. The data collected and the reports provided by Team Foundation Server gives your projects a level of transparency that allows you to react and adjust to changing conditions.

In this chapter, you will first learn about the Work Item Charting tools that are new in Team Foundation Server 2013 Web Access. Then you will see changes that were first introduced in Team Foundation Server 2010 and the minor changes since. These changes are designed to support multiple team project collections on a single server and, thus, improve reporting capabilities. You will then learn about the three data stores in the Team Foundation Server data warehouse. This chapter also provides an overview of how to set up and configure the integration with SharePoint, and how to take advantage ...