Project portal dashboards

 

Updated: July 15, 2016

Teams can quickly find important information about their team projects by using dashboards. Dashboards show project data, support investigation, and provide tools for teams to quickly perform common tasks.

System_CAPS_tipTip

See Dashboards for information about creating dashboards in the web portal. If you work in Visual Studio Team Services (VSTS), you can also Create Power BI dashboards and reports. This topic discusses SharePoint site dashboards.

To view a dashboard, choose Go to project portal from the Documents page in Team Explorer.

Requirements

  • To view dashboards, your team project must have a project portal enabled and be associated with a SharePoint site. To view the project portal, you must also be a member of the Visitors or Members group for the portal.

  • PivotChart reports and Excel Web Access Web Parts that appear in dashboards require that your team project is provisioned with SQL Server Analysis Services.

  • To update or refresh Excel reports that appear in the dashboard, you must belong to a group that is granted access to the Single Sign-on enterprise application definition, or you must belong to the TfsWarehouseDataReaders security role in SQL Server Analysis Services.

  • To view the dashboard, you must be assigned or belong to a group that has been assigned Read permissions in SharePoint Products for the team project.

  • To create or modify work items from the dashboard, you must be a member of the Contributors group or your Edit work items in this node permissions must be set to Allow. See Add users to team projects.

The dashboards that are available to you depend on the version of SharePoint Products that is installed on your portal and the process template used to create your team project. The following dashboards are installed with the Agile and CMMI process templates. When you create a team project with the Scrum process template, you only have access to the Release dashboard.

Task

SharePoint Server Standard Edition

SharePoint Server Enterprise Edition

Quickly access work items that are assigned to you. Use My dashboard to view and open the bugs, tasks, and test cases that are assigned to you. 

check mark
check mark

Review progress with the team. Use the Project dashboard to view team status and progress and to answer the following questions:

  • Is the team on track?

  • Is the team likely to finish the iteration on time?

  • Will the team complete the planned work based on the current burn rate?

check mark

  

Track progress toward completing an iteration. Use the Progress dashboard to view its own progress and to answer the following questions:

  • Is the team on track?

  • Is the team delivering value (closing stories)?

  • How well did the team plan the iteration?

  • How many hours remain in the iteration?

  • How much work has been added to the iteration?

  

check mark

Troubleshoot software quality issues with the team. Use the Quality dashboard to view the quality of the software and to answer the following questions:

  • Is the team testing the correct functionality?

  • Is the team fixing bugs effectively?

  • Are tests stale?

  • Does the team have sufficient tests?

  

check mark

Monitor test progress and find gaps in test coverage. Use the Test dashboard to track the team’s progress toward testing user stories or requirements and to answer the following questions:

  • Is authoring of test cases on track?

  • Is the team analyzing automated test results?

  • Are automated tests broken?

  • Is the team's automation of test cases on track?

  

check mark

Monitor bug activity. Use the Bugs dashboard to track the team’s progress toward finding and resolving code defects and to answer the following questions:

  • Is the team fixing bugs quickly enough to finish on time?

  • Is the team fixing high priority bugs first?

  • What is the distribution of bugs by priority?

  • How many bugs are being reactivated?

  • Is the team resolving and closing reactivated bugs quickly enough?

  

check mark

Monitor code coverage, code churn, and build activity. Use the Build dashboard to track the quality of the builds and to answer the following questions:

  • How much code is being tested?

  • How much is the code changing every day?

  • Is the quality of the builds improving?

System_CAPS_noteNote

If you use Git for version control, code churn and code coverage report data are not available.

  

check mark

Dashboards use SharePoint Products to display web parts. You can add many types of web parts to a dashboard. TFS web parts show lists of work items, work item counts, and other project data that is derived from TFS databases. These are the web parts that TFS provides:

  • Completed Builds Web Part

  • Go to Work Item Web Part

  • New Work Item Shortcuts Web Part

  • Project Portal Links Web Part

  • Query Results Web Part

  • Recent Check-ins Web Part

  • Team Project Portal Shortcut Web Part

  • Work Item Summary Web Part

The following illustration and table show and describe a sample dashboard, Bugs dashboard. For more information, see Bugs dashboard (Agile and CMMI).

Bugs Dashboard

Dashboard element

Element title

Source data

Data displayed

Step 1

Bug Progress

Bug Progress Excel Report

A visual representation of the cumulative count of all bugs, grouped by their state for the past four weeks.

Step 2

7-Day Bug Trend Rates

Bug Trends Excel Report

Line chart that shows the rolling average of the number of bugs that the team has opened, resolved, and closed for the past four weeks. The rolling average is based on the seven days before the date for which it is calculated.

Step 3

Active Bugs by Priority

Bugs by Priority Excel Report

A visual representation of the cumulative count of all bugs, grouped by their priority, for the past four weeks.

Step 4

Active Bugs by Assignment

Bugs by Assignment Excel Report

A horizontal bar chart with the total count of active bugs, grouped by priority, that are assigned to each team member.

Step 5

Active Bugs

Query Results Web Part

A list of active bugs derived from a query.

Step 6

Important Dates

SharePoint Events Web Part

A list of upcoming events

Step 7

Project Work Items

Work Item Summary Web Part

A count of active, resolved, and closed work items. You can open the list of work items by clicking each number.

Step 8

Recent Builds

Completed Builds Web Part

A list of recent builds and their build status. You can view more details by clicking a specific build.

9

Recent Checkins

Recent Check-ins Web Part

A list of the most recent check-ins. You can view more details by clicking a specific check-in.

From the dashboard toolbar, you can create a work item, an Excel report, or a copy of the current dashboard. Or, you can open a work item based on its ID. The following illustration shows these functions.

Dashboard toolbar

By using the following toolbar which is displayed within a work item query web part, you can perform the functions that the following illustration summarizes.

Toolbar for Query Results Web Part
  • Create a task, bug, test case, or other work item.

  • Refresh the items in the list from the query that it references.

  • Add or remove columns, and change the sort order of the items in the list.

  • Run the query behind the work item list.

  • Copy work items to the Clipboard.

  • Send work items to Office Outlook. 

  • Create a linked work item.

Here’s how you can customize a SharePoint dashboard:

  • Add columns, or sort columns in an existing work item list.

  • Change the query that is referenced by one of the existing work item lists.

  • Add a custom query Web part that displays the list of work items that the query finds. For example, you can add a query that lists all active requirements, issues, or other types of work items that are assigned to you.

  • Add other SharePoint site supported Web parts that integrate with Office Outlook or search functions of SharePoint Products.

  • Change the filters of each report in Office Excel to focus on specific product areas or iterations.

  • Add existing or adhoc Excel reports.

For more information about how to work with and customize reports in Office Excel, see these articles:

Show: