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:

Index

Charts

Query-based chartsAgile tools charts

Dashboards

VS Team Services, Power BI

Get StartedCreate charts and reports

On-premises TFS

Charts

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.

A view of 4 charts for a 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.

Choose Suite and Outcome for chart

You can also see how many tests each tester has left to run.

Choose Tester and Outcome for chart

Dashboards

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.

Example dashboard

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.

Bug trends example reportBuild status example report

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 reportsBuild and code quality
ProgressBug trackingTest 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.

Stories Overview example report

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 qualityProgress (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.

ScrumAgileCMMI

Customize reports

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.

Related notes