AZ-400 ยท DevOps metrics and dashboards
Queries and metrics per lifecycle area
Work item queries, Analytics/OData and Power BI for planning, development, testing, security, delivery and operations metrics; choosing a metric for a stated question.
Key points
- Boards data (velocity, burndown, lead and cycle time): work item queries and Analytics views.
- Pipelines and test data (duration, pass rate, flaky tests): Analytics OData queries in Power BI.
- Analytics views: only a flat list of work items.
- OData: filters and aggregates server-side; recommended in Power BI beyond simple Boards reports.
- The metric depends on the question: capacity, test stability, pipeline speed.
Source: https://learn.microsoft.com/en-us/azure/devops/report/powerbi/overview?view=azure-devops
Practice questions
Which kind of Azure DevOps data can an Analytics view expose to Power BI?
- Azure Boards work items
- Azure Pipelines run results
- Azure Repos commit history
- Azure Artifacts package downloads
Show answer
Answer: A. Azure Boards work items
Analytics views only support Azure Boards work item data, as a flat list. Pipelines data needs OData queries.
Which are ways to pull Analytics data into Power BI?
- OData queries
- Azure DevOps Data Connector with an Analytics view
- Power BI's OData Feed connector
- A direct WIQL import connector
- A direct SQL Server connection to the Azure DevOps Services database
Show answer
Answer: A. OData queries, B. Azure DevOps Data Connector with an Analytics view, C. Power BI's OData Feed connector
The three documented methods are OData queries, the Azure DevOps Data Connector (Analytics views) and the OData Feed connector. WIQL has no direct Power BI import path, and Boards has no SQL Server connection for Services.
True or false: An Analytics view can include Azure Pipelines run data, because views are designed to cover every Azure DevOps service.
Show answer
Answer: False
False. Analytics views only support Boards work items and there are no plans to extend the connector to other data such as pipelines.
Practice 8 questions on this topic in Bitzu
Short lessons, instant explanations and spaced review of what you get wrong. Free on iOS and Android.
