Demo - tutorial 2: Building TFS reports using Excel and Excel Services

Here's another demo from the same reporting talk I presented sometime last year (video #1 available here).

This demo shows building TFS reports in Excel that go against the TFSWarehouse Cube. Excel 2007 had some great features that make building such reports a breeze. Advanced formatting/charting/pivoting capabilities, cubeset functions (not demoed) make Excel a very powerful BI tool.

Excel Services makes it very easy to share these reports with a wider audience. Data connection management, security, dashboards, KPIs make Excel Services a very powerful BI platform.

Here's the demo, hope you find it helpful.

Comments

• Anonymous
  February 24, 2008
  PingBack from http://msdnrss.thecoderblogs.com/2008/02/24/demo-tutorial-2-building-tsf-reports-using-excel-and-excel-services/
• Anonymous
  June 04, 2008
  Here are some notes and a list of questions and answers regarding the TFS Reporting architecture. I gave
• Anonymous
  February 12, 2009
  TFS work items can provide a wealth of information that can be used for decision making and analysis,