24 February 2008

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

# MSDN Blog Postings » Demo - tutorial 2: Building TSF reports using Excel and Excel Services said:

PingBack from http://msdnrss.thecoderblogs.com/2008/02/24/demo-tutorial-2-building-tsf-reports-using-excel-and-excel-services/

24 February 08 at 8:57 PM
# Vince Blasberg's Blog said:

Here are some notes and a list of questions and answers regarding the TFS Reporting architecture. I gave

04 June 08 at 11:22 AM
# Teams WIT Tools said:

TFS work items can provide a wealth of information that can be used for decision making and analysis,

12 February 09 at 3:46 PM
Anonymous comments are disabled

About Ameya

I am a program manager in the Visual Studio Team System team. I work on Team Foundation Server. Previously, I worked as a program manager in the Project team.
Page view tracker