samuelmarinhoti/flowviz

A Power BI template that provides easy to understand, actionable flow metrics and predictive analytics for your agile teams using Azure DevOps, Azure DevOps Server and/or TFS.

FlowViz - Metrics for teams using Azure DevOps

What is it?

This dashboard is for all Agile teams using Azure DevOps, Azure DevOps Server and/or TFS, who want to leverage their data to have better conversations and make more informed decisions. It was built due to years of frustration with 'velocity' and other traditional agile metrics. These are centered on flow, as well as providing forecasting techniques you can use to give customers greater confidence/transparency in your delivery.

Prerequisites

• Make sure you have the latest version of Power BI Desktop
• Download the appropriate template file:
  • FlowViz - Project (for a single Project)
  • FlowViz - Organization (for all Projects within an Organization)
• Then you're good to get started!

Connectivity

• Open the .pbit file
• Select http/https (only choose http if your Azure DevOps Server is HTTP)
• Add the Analytics / Azure DevOps Server URL - for Azure DevOps services enter 'analytics.dev.azure.com' / for Azure DevOps Server enter your server details
• Add your organization and project name

Don't confuse the team name with the project name, a common mistake. If the URL you use is "http://dev.azure.com/Microsoft-UK/AzureDevOpsTeam/Database", then Microsoft-UK is the Organization Name, AzureDevOpsTeam is the Project name, Database is the team name.

• It should then look something like this:

Azure DevOps Services:

Azure DevOps Server:

• Hit 'Load'

• If you are prompted for a login, you can choose:

  • 'Organizational' and enter your Organization email/password (if required) and sign in
  • 'Basic' and use a Personal Access Token (PAT) to login, entering it in the password field (user can be left as blank - make sure it has 'Read' access to Analytics)

  

• Once signed in hit 'Load' and wait for your charts to populate!

What do these charts mean? How can I learn more?

There is a FlowViz Fundamentals course now available

For questions on charts, how to use them and other questions check out the Wiki.

If you want to embed these charts into Azure DevOps, check out this brilliant blog for guidance.

Screenshots

Feedback

FlowViz is built and maintained by Nicolas Brown and is published using Agile Extensions for assistance (big thank you to them!) Please email [email protected] for ideas, improvements and feedback.

You can also ask in the #flowviz channel in the Azure DevOps Club Slack community:

Thank you

Thank you to all the people who helped inspire and/or build this, providing feedback and answering my questions especially:

• Larry Maccherone
• Troy Magennis
• Daniel Vacanti
• Prateek Singh
• Tim Bayer
• Nic Nilsson
• Jason Padman
• Jack Marsh
• Ravi Nar
• Eric Hulshof
• Bernhard Millauer
• Vincent Quach
• Yunior A. Hernández Andrade