Creating Project Reports with Azure Boards

This is the second article covering creating a report using Microsoft Add-Ins for DevOps integration. If you miss setting up the add-ins, read this post: How to Create Project Report in Azure DevOps (ridilabs.net). This article will discuss creating a readable Excel report for project managers or product owners to understand their project progress.

Step 1 – Creating Query

Create your default query by visiting Boards à Backlogs à … à Create Query.

Give the default name. And save it.

Step 2 – View the Query

See your query by visiting Boards à Queries à All. You will find the query in the my queries or shared queries. It should be saved in shared or my queries.

Step 3 – Connect to the Query

Like in the How to Create Project Report in Azure DevOps (ridilabs.net), you can connect by creating a new list. After that, you will get the default view, as shown below.

Step 4 – Configure the Query

In the Team menu, select choose Columns

You should choose

1. Work item type
2. Title
3. State
4. Effort
5. Business Value
6. Start Date
7. Target Date
8. Activated Date
9. Closed Date
10. Reason

You will find this shiny report, feel free to filter your view such as product backlog, view, etc