Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Reporting in TFS
  • Table Of Contents Toc
Reporting in TFS

Reporting in TFS

By : Dipti Chhatrapati
4 (1)
Buy this Book
close
close
Reporting in TFS

Reporting in TFS

4 (1)
By: Dipti Chhatrapati
Buy this Book

Overview of this book

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.
Table of Contents (7 chapters)
close
close
close
Preface
Icon
Preface
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. Team Foundation Server Primer
Icon
1. Team Foundation Server Primer
Icon
Chapter objectives
Icon
TFS basics
Icon
ALM and TFS 2013
Icon
The TFS 2013 architecture
Icon
TFS and reporting
Icon
Summary
2
2. Work Item Querying
Icon
2. Work Item Querying
Icon
Team project scenario
Icon
Work item queries
Icon
Search box queries
Icon
Flat queries
Icon
Direct link queries
Icon
Tree queries
Icon
Summary
3
3. Excel Reporting
chevron up
Icon
3. Excel Reporting
Icon
Prerequisites to access Excel reports
Icon
Creating Excel reports
Icon
Excel Project Management reports
Icon
Bug Backlog Management Excel reports
Icon
Build Management Excel reports
Icon
Test Management Excel reports
Icon
Summary
4
4. SQL Server Reporting
Icon
4. SQL Server Reporting
Icon
SQL Server Reporting Services
Icon
SQL Server reporting tools
Icon
Understanding default SQL reports
Icon
Creating custom SQL reports
Icon
Summary
5
5. Team Web Access Reporting
Icon
5. Team Web Access Reporting
Icon
Granting an access level to a user or a group of users
Icon
Team web access standard reports
Icon
Summary
6
Index
Icon
Index

Chapter 3. Excel Reporting

Excel Reporting in TFS helps create effective queries and reports to manage the team project impressively. Microsoft Excel connects with TFS Data Warehouse and displays the data from TFS Data Warehouse on a PivotTable or PivotChart. The project teams can quickly get necessary information about their respective team projects using various reporting dashboards. Dashboards display project data, support investigations, and help the team work on common tasks more swiftly.

In this chapter, we will learn about the following topics:

  • Prerequisites to access Excel reports
  • Excel report creation
  • Excel Management reports
  • Bug Backlog Management Excel reports
  • Build Management Excel reports
  • Test Management Excel reports
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Reporting in TFS
End of Section 3
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon