Reporting in TFS
Reporting in TFS by Dipti Chhatrapati
English | April 9, 2015 | ISBN: 1782176136 | 177 pages | AZW3 | 9.42 Mb
English | April 9, 2015 | ISBN: 1782176136 | 177 pages | AZW3 | 9.42 Mb
Create and customize reports in Team Foundation Server using Excel and SQL Server Reporting Services.
About This Book
Build rich and descriptive reports using familiar design tools
Analyze project data to make better decisions based on accurate reports
Gain experience through engaging tutorials in a clear and understandable language
Who This Book Is For
This book is intended for developers, testers, architects, and project managers who want to explore and make use of the reporting facilities of Team Foundation Server 2013. Although no previous experience of reporting is required, a basic understanding of the Team Foundation Components and project templates would be a plus.
What You Will Learn
Get to know about TFS 2013, Reporting Architecture, and Application Lifecycle Management (ALM)
Generate work item reports
Explore Excel standard reports (bugs, tracking, and test)
Create reports based on SQL Server data using Report Designer
Manage SSRS reports in Report Manager
Display visual reports as charts and graphs in Team Web Access
In Detail
This book starts with giving the reader a walkthrough of TFS and the reporting architecture, guiding you to master the comprehensive reports that are part of Team Foundation Server.
You will explore the Team Project Scenario with work item queries, flat queries, direct link queries, and tree queries. Moving ahead, you will learn about the Excel reporting generation process and how to create ad hoc queries and reports in Microsoft Excel to help manage a team project. Microsoft Excel allows users to connect to the TFS Data and display results as a PivotTable or PivotChart report. Then the book describes each of the standard report dashboards such as SharePoint Dashboard, Project Dashboard, Progress Dashboard, Quality Dashboard, Test Dashboard, Bugs Dashboard, and Build Dashboard. Finally, you will learn how to use the powerful tools available in SQL Server Reporting Services to create and customize robust reports and also learn how to design and customize a dashboard of reports relevant to you.