This is the start of a series of posts that will hopefully help you understand how you can utilize the warehouse in Team Foundation Server to generate reports on your test management data.
Out of the box you get a number of useful reports that should go a long way in getting you the information you are looking for. If you look on the SharePoint site that is created with your new team project, under the Excel Reports/Test Management folder, you will see five work books. Build Quality, Test Team Productivity, Test Team Progress and Testing Gaps.
Each of these work books contains a few work sheets that have either tabular or chart data on them and help answer a specific question.
Build Quality – contains two work sheets that focus on answering questions about testing on specific builds
Test Team Productivity – contains four work sheets that focus on answering questions about how productive your test team is about executing tests and finding bugs
Test Team Progress – contains five work sheets that focus on tracking how the team is progressing towards completion of their planned testing.
Aside from the excel work books there are a number of other reports that are built using sql server reporting services. The unique thing about these reports is they can use the power of the MDX query language to bring data together from different parts of your life cycle. Probably the most useful of these reports is the stories over view report and the description of the report says it all
and the screen shot is even better
This report gives you a singular view into the status of your users stores as it relates to completion (hours), testing (number of cases), test coverage (pass/fail) and quality (bugs).
I hope this post has given you a quick insight into some of the resources that are available to use out of the box with TFS. In the subsequent posts in this series I will dig into more details of the structure of the analysis services cube and what the various measures and dimensions mean. In addition I will show you how you can build some other commonly requested reports, in fact if you are using test management with VS 2010 and you are looking for a particular report please post in the comments and I will see if I can include that as one of my examples.