Skip to content

A Power BI template which will show you how strong the correlation of story points is for your respective Agile teams who use Jira (Cloud), Azure DevOps, Azure DevOps Server and/or TFS.

License

Notifications You must be signed in to change notification settings

nbrown02/Story-Point-Correlation

Repository files navigation

Story Point Correlation

Most teams believe Story Points are something you MUST do as part of any Agile framework. This is a Power BI template to challenge this notion, allowing you the ability to connect to your Jira, Azure DevOps, Azure DevOps Server and/or TFS data and see the correlation (or not!) of story points.

Prerequisites

Connectivity for Azure DevOps

  • 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: alt text

Azure DevOps Server: alt text

  • 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)

    alt text

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

Connectivity for Jira

  • Open the .pbit file in Power BI Desktop

  • Add your Jira URL

  • Add your Jira Project Key(s) - don't confuse the project name with the project key, a common mistake! Your project key will be in the URL when viewing an item.

  • Add your field value for story points

  • It should then look something like this:

image

  • For multiple projects, it should look like:

image

  • Hit 'Load'
  • You will be prompted for a login, choose Basic and enter:
    • Your email associated with your Jira account for your username
    • Your API token you created in the Prerequisities

alt text

  • Then hit 'Connect' and wait for the data and charts to load!

Screenshots

alt text

alt text

alt text

Example of looking at multiple teams data and story point correlation with the best result seen (note: not comparing teams to each other!)

Euq4843XYAQ3ZuZ