Introduction

The Kanban Tabular Model provides a way to extract Kanban board data from Team Foundation Server 2012 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 initial 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 2012. It has not been tested against TFS 2013. Please see "Future Plans" below for more information.

1.1 Update

This update simply includes a PowerPivot model so that an additional server is not required. To update the data sources, the instructions are the same as for the Tabular model except you need to navigate to the PowerPivot window in Excel first by clicking the PowerPivot tab and then clicking Manage from the ribbon. At that point select Existing Connections from the data section and follow the instructions as shown in the included document.

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

Future Plans

Right now the only future plans I have for this model are the following:

• (Done) Create a PowerPivot version of the model so no server is needed
• Add instructions on processing the model (this can be cleaned from searching the web for how to update a tabular model) for automatic updates
• I am currently working on testing and updating the current version for TFS 2013 to take into account the fact that there are now multiple boards for a single team project

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.