Tom Patton

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.

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

• Promote visibility and transparency of the software development lifecycle.
• Identify trends and historical data that can help tune the development process to be more effective.
• Provide insight into the current status of software projects in order to aid in tactical decision making.

Topics will range from:

• Techniques to build reports on the data warehouse using SQL Server Reporting Services
• Techniques for using Excel to mine project data
• Interpretation of the reports that we provide as a part of the process templates included with Team Foundation server
• Whatever else is a hot-topic on the forums