What is the Analytics service?

Azure DevOps Services | Azure DevOps Server 2020 | Azure DevOps Server 2019

The Analytics service is the reporting platform for Azure DevOps, replacing the previous platform based on SQL Server Reporting Services. Built for reporting, Analytics is optimized for fast read-access and server-based aggregations. Use it to answer quantitative questions about the past or present state of your projects.

Note

If you are looking for information about Azure Analysis Services, see Azure Analysis Services.

Specifically, Analytics provides you with insights about your Azure DevOps projects through the following tools:

  • Analytics widgets that you can add to your dashboards
  • In-context Analytics reports available from select Azure DevOps pages
  • Rollup bars and counts for Azure Boards backlogs
  • Custom reports you can create using Power BI
  • Custom reports you can create using OData queries
  • Support to develop and add your custom Analytics widgets you can add to dashboards
  • Analytics widgets that you can add to your dashboards
  • Custom reports you can create using Power BI
  • Custom reports you can create using OData queries
  • Support to develop and add your custom Analytics widgets you can add to dashboards

Important

Select a version from Azure DevOps Content Version selector.

To view the content available for your platform, make sure that you select the correct version of this article from the version selector which is located above the table of contents. Feature support differs depending on whether you are working from Azure DevOps Services or an on-premises version of Azure DevOps Server, renamed from Team Foundation Server (TFS).
To learn which on-premises version you are using, see What platform/version am I using?

Data available in Analytics

Analytics is generally available for Azure DevOps Service and Azure DevOps Server 2020. It is in preview for Azure DevOps Server 2019. The service provides a concise data model over Azure DevOps.

Data available via the Analytics service depends on your version and platform. For specifics, read Data available in Analytics and Data model for Analytics.

Note

The Analytics service is automatically enabled for all Azure DevOps Services. It is supported for use in production. Power BI integration and access to the OData feed of the Analytics Service are in Preview. We encourage you to use it and provide us feedback. As we add features, we will post them on the Microsoft DevOps Blog.

Note

The Analytics service is automatically installed on all new project collections for Azure DevOps Server 2020. It is supported for use in production. Power BI integration and access to the OData feed of the Analytics Service are in Preview. We encourage you to use it and provide us feedback. If you upgraded from Azure DevOps Server 2019, then you're provided with the option to install the Analytics service during upgrade.

Note

The Analytics service is in preview for Azure DevOps Server 2019. You access Analytics by enabling or installing it for a project collection. Power BI integration and access to the OData feed of the Analytics Service are in Preview. We encourage you to use it and provide us feedback. As we add features, we will post them on the Microsoft DevOps Blog.

Analytics is enabled for all Azure DevOps Services projects and automatically populates itself with all available Azure DevOps data. Once populated, it updates itself as data changes occur. For more information, read Data available in Analytics and Performance and latency.

Analytics is enabled for all projects on new project collections and automatically populates itself with all available Azure DevOps data. Once populated, it updates itself as data changes occur. For more information, read Data available in Analytics and Performance and latency.

Once you've enabled or installed Analytics, the service populates itself with all available Azure DevOps data. Once populated, it updates itself as data changes occur. For more information, read Data available in Analytics and Performance and latency.

Note

TFS 2018 and earlier versions do not support Analytics. For TFS 2018 and earlier, you may use Dashboards with a variety of widgets that don't require Analytics. You may also use SQL Server Reporting.

Dashboard widgets

You can create dashboards and add widgets to them. We provide several widgets based on Analytics. These widgets take advantage of the power of Analytics. Widgets provide the easiest way to get insights from your data.

For example, the Velocity widget shown in the following image provides insights into a team's historical performance over six iterations.

Analytics - Velocity Widget

Here, the Velocity widget shows that this team has a history of closing stories late. It also shows a discrepancy between planned and completed work across all the sprints displayed. The team can drill into the data to determine the root causes. After implementing new practices, the team can use the Velocity widget to track their effectiveness.

Check out Add an Analytics widget to a dashboard for a step-by-step guide to get started with the Velocity widget.

If you want to develop your own widget based on Analytics, see Create an Analytics widget.

In-context reports and roll-up columns

Work tracking in-context reports are now based on Analytics data. These reports appear on the Analytics tab of the product and portfolio backlogs and Kanban boards. In addition, there are some pipelines and test in-context reports. To learn more, see the following articles:

Also, you can add rollup columns to product and portfolio backlogs which provide progress bars, counts of work items, or sums of selected fields. For details, see Display rollup progress or totals.

Custom Power BI reports

Power BI is a suite of business analytics tools. Use it to do ad hoc analysis, produce beautiful reports, and publish for enterprise consumption.

To get started with Power BI and Azure DevOps Analytics:

  1. Read the Power BI integration overview
  2. Check out the Power BI Sample Reports. They will get you started quickly on the most popular reports.

Custom reports based on OData queries

Analytics is fully accessible via OData. If you would like to prepare custom queries and tooling with our OData API, see Extend on Analytics.

Try this next