Introduction

The Kanban Tabular Model provides a way to extract Kanban board data from Team Foundation Server 2013 to a separate cube for reporting and analysis. Because this data is stored in a tabular model, it is easy to extend and add additional measures. In this release the following data is supported:

• Trend data for creating Cumulative Flow Diagrams
  • This is the view shown in Team Web Access only the model provides a more granular view
  • This is provided by the Kanban Work Item Count measure
• Time data for analyzing cycle time and flow time
  • These are made possible through the Duration, Average Duration, Min Duration and Max Duration measures

Included in the download is a document explaining how to install a tabular analysis server, how to install the model and examples of how to use the various measures which incudes sample graphs.

* Please note that the version of Visual Studio is immaterial but I had to select one to upload it. This version is compatible with Team Foundation Server 2013. It will not work with TFS 2012 because of certain data schema changes.

Special Thanks

This model could never have been built without the invaluable help of the Microsoft product team. I would like to specifically call out for their help the following individuals:

• Gregg Boer
• Aaron Bjork
• Hakan Eskici
• Ahmet Akkas

An excellent reference on the subject of tabular models is Applied Microsoft SQL Server 2012 Analysis Services Tabular Modeling by Teo Lachev. It's the best book on the subject I've come across. If you are unfamiliar with tabular models, this is a good place to start.