Share via

Test Case Readiness Excel Report

You can use the Test Case Readiness report to help monitor the progress that the team is making toward defining and designing Test Cases. This report shows a burndown chart of how many Test Cases were in the design and ready states for the most recent four weeks.

For information about how to access this report, see Excel Reports (Agile).


You can view the Test Case Readiness from the Test 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 Access a Team Project Portal and Process Guidance.

In this topic

  • Data in the Report

  • Interpreting the Report

  • Updating and Customizing the Report

Related topics


A team uses Test Cases to define both manual and automated tests that it can run and manage by using Test Runner and Microsoft Test Manager. By using Microsoft Test Manager, you can create not only Test Cases but also test suites and test configurations that support testing your project. You can use test configurations to define how you want to run your Test Cases and test suites. You can group your Test Cases together by organizing them into a hierarchy of test suites in your test plan. By creating test suites, you can run sets of Test Cases as a group. For more information, see Defining Your Testing Effort Using Test Plans.

Required Permissions

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 Visual Studio ALM and Managing Permissions.

Data in the Report

This report provides a stacked area graph that shows how many Test Cases have been in the Design or Ready state for the most recent four weeks.

Test Case Readiness Excel Report

The report is based on a PivotChart report that shows the data that is stored in the data warehouse for Test Cases.

Required Activities for Monitoring Test Case Readiness

For the Test Case Readiness report to be useful and accurate, the team must perform the following activities:

  • Define Test Cases, and update their State from Design to Ready.

  • (Optional) To support filtering, assign Iteration and Area paths to Test Cases.

Interpreting the Report

You should expect the Test Case Readiness report to vary depending on where you are in your product development cycle. Early iterations should show a gradual increase in how many Test Cases are in the Design state. Toward the end of the product cycle, most Test Cases should be in a Ready state.

You can review the report to find answers to the following questions:

  • How many Test Cases is the test team defining?

  • How many Tests Cases are ready to run today?

  • How many Test Cases must the team still write and review?

  • Does the overall number of Test Cases appear to be enough for the number of User Stories that the team is implementing?

  • What is the percentage of Test Cases that the test team can run today?

  • Will the team be able to have all the Tests Cases ready by the end of the iteration?

Updating and Customizing the Report

You can update the Test Case Readiness report by opening it in Office Excel and changing the filter options for the PivotTable report. You can customize this report to support other views, as the following table describes.



Test Case readiness for an iteration

Change the filter for Iteration (default=All)

Test Case readiness for a product area

Change the filter for Area (default=All)

Test Case readiness for the most recent six, eight, or more weeks

In the Columns PivotTable Field List, replace @@Last 4 weeks@@ with a different Set

For more information about how to work with and customize PivotTables and PivotChart reports, see the following pages on the Microsoft Web site:

See Also


Test Dashboard (Agile)

Test Case Readiness Report

Artifacts (Agile)

Other Resources

Excel Reports (Agile)