Dashboards

Agile teams can quickly find important information about their team projects by using dashboards. Dashboards show project data, support investigation, and help teams perform common tasks more quickly.

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

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.

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. For more information, see Excel reports.

Required Permissions

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. For more information, see Excel reports and Add users to team projects.

Dashboards available to you

The dashboards and dashboard customization features that are available to you depend on the version of SharePoint Products that is installed on your portal, as the following table indicates. Also, the PivotChart reports and Excel Web Access Web Parts that appear in dashboards require that your team project is provisioned with SQL Server Analysis Services.

Task	SharePoint Foundation	SharePoint Server Standard Edition	SharePoint Server Enterprise Edition	Related topics
Quickly access work items that are assigned to you. You can use My dashboard to view and open the bugs, tasks, and test cases that are assigned to you.				My Dashboard (Agile)
Review progress with the team. Agile teams can use the Project dashboard to view their own 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?				Project dashboard (Agile)
Track progress toward completing an iteration. Agile teams can 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?				Progress dashboard (Agile)
Troubleshoot software quality issues with the team. Agile teams can use the Quality dashboard to view the quality of the software that they are creating 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?				Quality dashboard (Agile)
Monitor test progress and find gaps in test coverage. Agile teams can use the Test dashboard to track its own progress toward testing user stories 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?				Test dashboard (Agile)
Monitor bug activity. Agile teams can use the Bugs dashboard to track its own 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?				Bugs dashboard
Monitor code coverage, code churn, and build activity. Agile teams can 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? Note If you use Git for version control, code churn and code coverage report data are not available.				Build dashboard (Agile)

Dashboards and Web parts

Dashboards use SharePoint Products to display Web parts. You can add many types of Web parts to a dashboard. However, the two Web parts that are specific to the display of project data for Team Foundation are Excel Web Access and Team Web Access Web parts. Web parts for Excel Web Access display PivotChart reports or other data that is derived from Office Excel worksheets that access the Analysis Services database for Visual Studio ALM. Web parts for Visual Studio ALM show lists of work items, work item counts, and other project data that is derived from Team Foundation databases.

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

Dashboard element	Element title	Source data	Data displayed
	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.
	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.
	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.
	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.
	Active Bugs	Web part for Team Web Access	A list of active bugs derived from a query.
	Important Dates	Web part for SharePoint Products	A list of upcoming events
	Project Work Items	Web part for Team Web Access	A count of active, resolved, and closed work items. You can open the list of work items by clicking each number. This list is derived from a Team Web Access Web part.
	Recent Builds	Web part for Team Web Access	A list of recent builds and their build status. You can view more details by clicking a specific build. This list is derived from a Team Web Access Web part.
	Recent Checkins	Web part for Team Web Access	A list of the most recent check-ins. You can view more details by clicking a specific check-in. This list is derived from a Team Web Access Web part.

Using the dashboard toolbar

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.

Using the work item toolbar

Web parts for Team Web Access that display a list of work items also provide a work item toolbar. By using this toolbar, you can perform the functions that the following illustration summarizes.

• 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.