Monthly Archives: January 2019

Project Reporting Part 7 – Display Related Work Items from Azure DevOps Project in a Single Power BI Report

In this series of blog posts regarding Power BI and Azure DevOps, we have discussed how to connect Power BI to data held in Azure DevOps projects using Analytics View, using Power BI visualisations to display and compare work item statistics, and how project team members can contribute to ensure the data held in Azure DevOps are up to date to ensure accurate reporting. In this final post, we focus on display detailed data of parent and children work items in a Power BI report page.

Continue reading Project Reporting Part 7 – Display Related Work Items from Azure DevOps Project in a Single Power BI Report

Advertisements

Project Reporting Part 6 – Historical Data Reporting with Azure DevOps Analytics View

If your project team uses Azure DevOps to manage your project delivery, one thing that the built in dashboard widgets do not do well is the visualisation of historical statistics from the project. In this post we discuss how this can be achieved by using Analytics View and Power BI visualisation.

Continue reading Project Reporting Part 6 – Historical Data Reporting with Azure DevOps Analytics View

Project Reporting Part 5 – Analysing Closure Trends with Azure DevOps Analytics View

What are some of the questions that project team use reporting to help them understand? At the end of a sprint the team might wish to take a look at how work items were closed. In this blog post we take a look at work item closure trends and how Power BI reporting of data from Azure DevOps based on Analytics Views can be used to help with these investigations.

Continue reading Project Reporting Part 5 – Analysing Closure Trends with Azure DevOps Analytics View

Project Reporting Part 4 – Azure DevOps Analytics View Data Model and Power BI Report Designs

In previous post we explored how data from Azure DevOps projects can be exposed and made available for reporting in Power BI using Analytics View. In this post we look at the data model from Analytics View and some of the basic Power BI design concepts.

Continue reading Project Reporting Part 4 – Azure DevOps Analytics View Data Model and Power BI Report Designs

Project Reporting Part 2 – Why Report on Delivery Data with Power BI

If you use Azure DevOps (formerly Visual Studio Team Services) you would already be familiar with their Dashboards and widgets you can add to the Dashboards (e.g. see the example dashboard in the 1st post). So when would you need to consider using Power BI for reporting?

Continue reading Project Reporting Part 2 – Why Report on Delivery Data with Power BI

Project Reporting Part 1 – Crucial Contribution Project Team Makes in Reporting

Recently I wrapped up a project where I spent a lot of time doing delivery reporting out of the old Team Foundation Service 2015 (TFS 2015). I became interested in how the reporting might have improved in the latest online version of Azure DevOps (formerly Visual Studio Team Services – VSTS). In this series of blog posts I shall dive into the reporting capabilities of Azure DevOps for project management and later the currently beta release of a Power BI connector to Azure DevOps.

Continue reading Project Reporting Part 1 – Crucial Contribution Project Team Makes in Reporting