This project has moved and is read-only. For the latest updates, please go here.

See library of tooling and guidance solutions ( for details.

NOTE: Trend Charts have been added as a feature to Visual Studio Online Update on 21 July 2014 and Microsoft Visual Studio Team Foundation Server 2013 with Update 4. The feature provides all the same functionality that was provided by this CodePlex project, including several additional advantages.

Project Description

Welcome to TFS Reporting Guide where we, the ALM Rangers, will take you on a fascinating journey to discover the exciting and powerful reporting features provided by Team Foundation Server.

This guidance is focused on providing practical guidance and a reference solution to enable Team Foundation Service users to create a tabular store model and generate reports based on WIT data, and to enable TFS users to create valuable reports using the TFS Data Warehouse, based on real-world scenarios.


Visual Studio ALM Rangers

This guidance is created by the Visual Studio ALM Rangers, who have the mission to provide out of band solutions for missing features and/or guidance. This content was created with support from Microsoft Product Group, members of Microsoft Services, Microsoft Most Valued Professionals (MVPs) and technical specialists from technology communities around the globe, giving you a real-world view from the field, where the technology has been tested and used.

image[18] image[19] image[20]


The features included in the guidance are:

  • As Dave, the TFS Admin, I would like practical guidance on creating a tabular model store that can be populated from the TFS Service
  • As Dave, the TFS Admin, I would like a reference implementation which uses the guidance to pull WIT data from the operational store (via OData) and delivers historical WIT trending reports.
  • As Bijan, the ALM Ranger, I would like historical and trend reporting against ALM Ranger projects, so that I understand time invested by the Rangers.
  • As Dave, the TFS Admin, I would like practical guidance and samples for TFS Data warehouse reporting.

External References



Anisha Pindoria, Gordon Beeming, Grant Holliday, Hamid Shahid, Hakan Eskici, Jeff Levinson, Jesse Houwing, Jim Szubryt, Justin Marks, Mattias Sköld, Prasanna Ramkumar, Priyanka Janardhan, Ted Malone

How to submit new ideas?

The recommended method is to post ideas to the Discussions Page or to contact the Rangers at


Post comments on the Discussions Page.


Last edited Jan 17, 2017 at 4:51 PM by wschaub, version 12