Deep Dive into Microsoft Visual Studio 2010 Team Foundation Server Reporting

1. SESSION CODE: DEV405 Deep Dive into Microsoft Visual Studio 2010 Team Foundation Server Reporting Steven Borg, Principal ALM Consultant Northwest Cadence Steven.Borg@nwcadence.com

2. This sessions dives deep into understanding Team Foundation Server 2010 reporting. We very briefly overview the provided reports, both SSRS and Excel that come out of the box, before diving into what makes these reports possible. We dive into the behind-the-scenes data stores: the TFS_Warehouse and the OLAP cube, and understand their relationship as well as their structure. Then we step back up into the world of reporting where we create and extend reports from WIQL queries (built-in capability), create new Excel pivot-table reports and host them on a SharePoint portal, and modify SSRS reports. Finally, we look at how to make decisions about what data to capture to help drive overall process improvement.

3. What is Quality?

4. Reporting Deep Dive – Demo Roadmap • Introduction to TFS 2010 Reporting • Overview of Existing Reports • Understanding the TFS Data Warehouse and Cube • Creating Ad-Hoc Reports using Excel Pivot Tables • Generating Excel Reports from WIQL Queries • Hosting Excel Reports on SharePoint • Modifying and creating SSRS Reports

5. Introduction to TFS 2010 Reporting Demo

6. Overview of Existing Reports Demo

7. Understanding the TFS Data Warehouse and Cube Demo

8. Creating Ad-Hoc Reports using Excel Pivot Tables Demo

9. Generating Excel Reports from WIQL Queries Demo

10. Hosting Excel Reports on SharePoint Demo

11. Modifying the Built-in SSRS Reports Demo

12. Characteristics of Effective Metrics

13. Final thoughts… Wrap up

14. Enable Communication

16. Run the Work Remaining report. Immediate To-Do

18. Required Slide Track PMs will supply the content for this slide, which will be inserted during the final scrub. Track Resources • Visual Studio – http://www.microsoft.com/visualstudio/en-us/ • Soma’s Blog – http://blogs.msdn.com/b/somasegar/ • MSDN Data Developer Center – http://msdn.com/data • ADO.NET Team Blog – http://blogs.msdn.com/adonet • WCF Data Services Team Blog – http://blogs.msdn.com/astoriateam • EF Design Blog – http://blogs.msdn.com/efdesign

19. Required Slide Resources Learning • Sessions On-Demand & Community • Microsoft Certification & Training Resources www.microsoft.com/teched www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers http://microsoft.com/technet http://microsoft.com/msdn

20. Required Slide Complete an evaluation on CommNet and enter to win!

21. Sign up for Tech·Ed 2011 and save $500 starting June 8 – June 31st http://northamerica.msteched.com/registration You can also register at the North America 2011 kiosk located at registrationJoin us in Atlanta next year

22. © 2010 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.