Dashboards and reports
Visual Studio Team Services | Visual Studio 2015 | Previous versions
Gain insight into the progress you're making and the quality of your software development projects. You can collect status and trend charts into dashboards that you share with your team and stakeholders.
For more complex reporting requirements, you can open or customize a dashboard or report. Your choices depend on whether you're working in the cloud or on-premises:
VS Team Services, Power BIGet Started
The quickest way to view progress is to create work item or test result charts. These charts are always up-to-date because they get data directly from the TFS data stores.
Status or trend charts
You can create several types of charts -- such as pie, column, or trend -- for the same flat-list query.
Test results and test status charts
Visualize the test status for a specific test suite or progress made in testing a user story.
You can also see how many tests each tester has left to run.
Teams can create multiple dashboards to share information, access quick links and other functions, and view status, progress, and trends. Easily add and rearrange widgets on the dashboard to show recent changes made to source control folders, build status, and charts created from work item queries.
Excel Reports (on-premises TFS)
You can track your team project's burn rate, bug backlog, software quality, test progress, and other metrics by viewing an OOB Excel report.
Here are examples of two of the Excel reports.
OOB Excel reports require that your team project is configured with SharePoint Products, SQL Server Analysis Services, and SQL Server Reporting Services. If these reports aren't available to you, you can create ad-hoc reports in Excel from a work item query or by connecting to the Analysis Services cube.
|Adhoc status and trend reports||Progress||Bug tracking||Test tracking|
SQL Server Reporting Services Reports (on-premises TFS)
Several OOB reports gather several data points into a single report. For example, the Stories Overview (Agile) report presents a snapshot of the work that has been performed for the filtered set of user stories to the current date.
Each default process provides several OOB Reporting Services reports.
These reports require that your on-premises TFS was configured with SQL Server Analysis Services and Reporting Services Reports.
If you didn't add these services previously and want to add them now, go here
|Build and code quality||Progress (Scrum-specific)||Progress (Agile and CMMI)||Bug and test tracking|
To manage the data warehouse or troubleshoot problems that occur, you use the Warehouse Control Web Service. See Manage TFS reports, data warehouse, and analysis services cube
SharePoint dashboards (on-premises TFS)
SharePoint dashboards collect a number of Excel reports and team project data within a single view hosted on the project portal. For example, the Quality dashboard provides an overview of progress occurring in the test, development, and build areas as they relate to the quality of the software under development.
Dashboards available to you depend on the version of SharePoint Products configured to integrate with TFS.
Different dashboards are available to you based on the process you selected to create your team project.
To create or customize Reporting Services reports, see Create and manage Reporting Services reports.
Add custom fields
You can add data to support reporting requirements in the following ways:
Add work item fields to the data store, relational database, or data warehouse. See Add or modify work item fields to support reporting.
Incorporate data from other resources to an Excel report using PowerPivot. PowerPivot for Excel 2010 is a data analysis add-in for Microsoft Excel 2010. By using this add-in, you can generate reports that combine data from other data stores or databases with data from Team Foundation Server. For more information, see Microsoft PowerPivot.
Create an adapter to add new data types to the data warehouse. An adapter is a managed assembly that implements IWarehouseAdapter. An adapter uses the warehouse object model to interact with the TFS data warehouse. When an adapter adds data fields to the warehouse, it programmatically extends the schema that defines data that is moved to the warehouse. For more information, see Data Warehouse Extensibility and How to: Create an Adapter.
- Choose a process provides an overview of the three default processes used to create and update team projects
- Support rollup of work and other fields provides information on how to generate rollup data when working with parent-child linked work items
- Components of the TFS data warehouse provides more information on the structure and relationship of the warehouse and reports
- Feature index for VSTS and TFS