Analytics & Reporting documentation

Reporting in Azure DevOps enables software development teams to make data driven decisions and deliver value to their customers faster.

Configure charts & dashboards

Overview

• About dashboards, charts, reports & widgets
• Quick reference
• Widget catalog

Tutorial

• Add, rename, and delete dashboards
• Add a widget to a dashboard
• Configure Burndown & Burnup widgets
• View and configure team velocity

How-To Guide

• Create status and trend query-based charts

Work tracking status and trends

Tutorial

• Burnup and burndown
• Sprint burndown
• Cumulative flow
• Cycle and Lead time
• Velocity
• Work item query-based query charts

Pipeline reports

Concept

• Review code coverage
• Pipeline Analytics reports
• Historical graph for agent pools

Explore Analytics OData model

Tutorial

• Construct OData queries
• Define basic queries

Overview

• Best practices to use when querying Analytics

Analytics OData Reference

Reference

• Calendar date, Project, and User metadata
• Azure Boards metadata
• Azure Pipelines metadata
• Azure Test Plans metadata

Test status and trends

Concept

• Test result trends
• Test status, progress, and result charts
• Trace test requirements
• Test Analytics and failure analysis

Create Power BI reports

Overview

• About Power BI integration
• What is Analytics
• What are Analytics views?
• Reporting roadmap

Tutorial

• Create an Analytics view
• Connect to Power BI data connector
• Connect with data by using Power BI and OData queries
• Create a Power BI report with an OData Query

Sample Power BI reports

Overview

• Sample reports using OData queries
• Data available from Analytics

How-To Guide

• Add a column for last refresh date
• Calculate time-in-state

Extend Analytics with OData

Overview

• About Power BI integration
• Quick reference

Quickstart

• Query work tracking data
• Project and organization-scoped queries
• Aggregate work tracking data

Reference

• Query guidelines for Analytics with OData

View SQL Server Reports (Legacy)

Overview

• Reporting Services reports

How-To Guide

• Create Excel reports from a work item query
• Create a Detailed Report using Report Designer
• Add reports to a team project