Bitzu

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

Single choice

Which kind of Azure DevOps data can an Analytics view expose to Power BI?

  1. Azure Boards work items
  2. Azure Pipelines run results
  3. Azure Repos commit history
  4. 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.

Select all that apply

Which are ways to pull Analytics data into Power BI?

  1. OData queries
  2. Azure DevOps Data Connector with an Analytics view
  3. Power BI's OData Feed connector
  4. A direct WIQL import connector
  5. 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

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.

Download on the App StoreGet it on Google Play

More AZ-400 topics in this module