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