This sessions dives deep into understanding Team Foundation Server 2012 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.
For more information, check out this course on Microsoft Virtual Academy: