Burndown Excel Report
Updated: July 15, 2016
You can use the Burndown report to help determine how much progress the team has made in completing work for an iteration or other interval of time. The report shows how many hours of work the team has completed and how many hours remain. For information about how to access this report, see Excel reports.
You can view the Burndown report from the Progress dashboard. You can access this dashboard only if your team project portal has been enabled and is provisioned to use Microsoft Office SharePoint Server 2007. For more information, see Configure or redirect process guidance.
To view the report, you must be assigned or belong to a group that has been assigned the Read permissions in SharePoint Products for the team project.
To modify or customize the report, you must be a member of the TfsWarehouseDataReaders security role in SQL Server Analysis Services. You must also be assigned or belong to a group that has been assigned the Members permissions in SharePoint Products for the team project. For more information, see Grant Access to the Databases of the Data Warehouse for Team System.
The Burndown report shows a stacked area chart of the Completed Work and Remaining Work hours that have been tracked for all Tasks during the time interval set for the report. The default interval is the current week through the next three weeks.
The Ideal Trend line calculates a slope or trajectory for when the team will complete work based on the amount of work that remains and the end date of the report. A healthy Burndown chart shows that the team is making steady progress toward finishing the work. The line is drawn from the remaining work on the start date and intersects the x-axis on the end date.
For the Burndown chart to be useful and accurate, the team must perform the following activities:
Define Tasks, and specify the Iteration and Area paths for each.
Specify and update the Completed and Remaining fields for each Task as the team works on it.
If you subdivide a Task into subtasks, specify hours only for the subtasks. These hours are rolled up as summary values for the parent Task and User Story.
You can review the Burndown report to determine the progress that the team made during an iteration. For example, you can find answers to the following questions:
How fast is the team completing remaining work?
Is the team adding work during the iteration? Is the team allowing scope creep?
How much work can the team complete in the available time?
When can the team finish the work?
When can the team finish the current iteration?
You can update the Burndown report by opening the report in Office Excel and changing the filter options for the PivotTable report or change the start date for the report. You can customize this report to support other views as the following table describes.
Burndown for an iteration
Change the filter for Iteration (default=All)
Burndown for a product area
Change the filter for Area (default=All)
Burndown for a specific time interval
In the Reports worksheet, perform the following steps:
For more information about how to work with and customize PivotTable and PivotChart reports, see the following pages on the Microsoft Web site: