Book Image

Microsoft Team Foundation Server 2015 Cookbook

By : Tarun Arora
Book Image

Microsoft Team Foundation Server 2015 Cookbook

By: Tarun Arora

Overview of this book

Team Foundation Server (TFS) allows you to manage code repositories, build processes, test infrastructure, and deploy labs. TFS supports your team, enabling you to connect, collaborate, and deliver on time. Microsoft's approach to Application Lifecycle Management (ALM) provides a flexible and agile environment that adapts to the needs of your team, removes barriers between roles, and streamlines processes. The book introduces you to creating and setting up team projects for scrum teams. You'll explore various source control repositories, branching, and merging activities, along with a demonstration of how to embed quality into every code check-in. Then, you'll discover agile project planning and management tools. Later, emphasis is given to the testing and release management features of TFS which facilitate the automation of the release pipeline in order to create potentially shippable increments. By the end of the book, you'll have learned to extend and customize TFS plugins to incorporate them into other platforms and enable teams to manage the software lifecycle effectively.
Table of Contents (16 chapters)
Microsoft Team Foundation Server 2015 Cookbook
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Index

Analyzing code churn with TFS analysis services cube


The TFS analysis services cube computes large datasets that enable users to answer questions about their software project. The TFS data warehouse empowers user to join up various datasets and understand trends in code churn, code coverage, builds, bugs, and so on. In this recipe, you'll learn how to connect Excel with TFS analysis services cube and analyze the code churn in the FabrikamTFVC project.

Getting ready

In order to connect TFS analysis services as a data source using Excel, you need your Windows account permissioned on the TFS data warehouse. Alternatively, use a Windows user name and password that already has access.

How to do it...

  1. Open Excel, in the DATA tab click on From Other Sources and choose From Analysis Services. In the data connection wizard, enter the TFS analysis server connection details and click on the Next button:

    Note

    If you are unsure about the warehouse connectivity details, you can check and verify them through...