TFS Business Intelligence Reporting

In December, I spoke at the Queensland VSTS User Group about reporting on TFS using the Analysis Services cube that is included on the data tier. At the end of this post I have included links to my slides and some sample reports in Excel 2007 to get you started.

Reports are only as good as the data. Using TFS Working On to help accurately report the time spent, or at least remaining hours on your work items has been working very well for my development team. Due to this, the next version should be released shortly, and hopefully continually improved quickly as we are all using it in anger.

Before you can use the Excel reports you must change the TFS cube connection:

  1. Open the Work Book
  2. Select the Data Ribbon
  3. Select Connections, Properties… and the Definition tab
     
  4. Update the Data Source in the Connection String to the Analysis Services instance containing the TFS Cube
  5. Click OK, Close

 http://cid-ccb05a30bca0ff01.skydrive.live.com/embedrowdetail.aspx/Public/QVSTSUG-TFSBIReporting-Dec08-MatthewRowan.ppsxhttp://cid-ccb05a30bca0ff01.skydrive.live.com/embedrowdetail.aspx/Public/TFSBIReports.xlsx

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s