Team Foundation Reporting - Tips, Tricks, and Triviahttp://blogs.msdn.com/b/tompatton/atom.aspxTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)2006-02-08T18:39:00Zhttp://blogs.msdn.com/b/tompatton/archive/2006/05/07/591713.aspx2006-05-07T03:45:00Z2006-05-07T03:45:00Z<P>This attachment contains a variety of samples, experiments and untested reports for use with the Team Foundation Data warehouse. There is a brief overview document describing the reports and how to deploy them.</P> <P>Please post back to this blog with any questions or comments.</P> <P>-Tom</P><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=591713" width="1" height="1">Tom Pattonhttp://blogs.msdn.com/Tom-Patton/ProfileUrlRedirect.ashxhttp://blogs.msdn.com/b/tompatton/archive/2006/02/08/527786.aspx2006-02-08T21:39:00Z2006-02-08T21:39:00Z<font face=Verdana size=2> <p class=MsoNormal style="MARGIN: 0in 0in 0pt"><font face=Tahoma>Hi! I’m a Program Manager with the Visual Studio Team Foundation Server team. I work on the reporting and data warehousing capabilities that enable reports and metrics to be generated from the project data gathered across the suite of tools in Team System.</font></p> <p class=MsoNormal style="MARGIN: 0in 0in 0pt"><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p><font face=Tahoma>&nbsp;</font></o:p></p> <p class=MsoNormal style="MARGIN: 0in 0in 0pt"><font face=Tahoma>I’ll be using this space to share tips and tricks on how to get the most out of the Team Foundation data warehouse to enable project managers and team members to </font></p> <p class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p><font face=Tahoma>&nbsp;</font></o:p></p> <ul style="MARGIN-TOP: 0in" type=disc> <li class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-list: l1 level1 lfo1; tab-stops: list .5in"><font face=Tahoma>Promote visibility and transparency of the software development lifecycle.</font></li> <li class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-list: l1 level1 lfo1; tab-stops: list .5in"><font face=Tahoma>Identify trends and historical data that can help tune the development process to be more effective.</font></li> <li class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-list: l1 level1 lfo1; tab-stops: list .5in"><font face=Tahoma>Provide insight into the current status of software projects in order to aid in tactical decision making.</font></li></ul> <p class=MsoNormal style="MARGIN: 0in 0in 0pt"><font face=Tahoma>Topics will range from:</font></p> <p class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p><font face=Tahoma>&nbsp;</font></o:p></p> <ul style="MARGIN-TOP: 0in" type=disc> <li class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo2; tab-stops: list .5in"><font face=Tahoma>Techniques to build reports on the data warehouse using SQL Server Reporting Services</font></li> <li class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo2; tab-stops: list .5in"><font face=Tahoma>Techniques for using Excel to mine project data</font></li> <li class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo2; tab-stops: list .5in"><font face=Tahoma>Interpretation of the reports that we provide as a part of the process templates included with Team Foundation server</font></li> <li class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo2; tab-stops: list .5in"><font face=Tahoma>Whatever else is a hot-topic on the forums</font></li></ul></font><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=527786" width="1" height="1">Tom Pattonhttp://blogs.msdn.com/Tom-Patton/ProfileUrlRedirect.ashx