What is the Analytics Service?

Azure DevOps Services | Azure DevOps Server 2019

The Analytics Service provides the reporting platform for Azure DevOps and Azure DevOps Server. Use it to answer quantitative questions about the past or present state of your projects. This service provides a concise data model over Azure DevOps. Built for reporting, the Analytics Service is optimized for fast read-access and server-based aggregations.

Note

The Analytics Service is generally available for all organizations using Azure DevOps Services. It provides several advanced widgets. Power BI integration and access to the OData feed of the Analytics Service is 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.

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

Note

The Analytics Service is in preview for Azure DevOps Server 2019. While in preview, it is available to everyone free of charge. We encourage you to use it and provide us feedback. As we add features, we will post them on the Microsoft DevOps Blog.

You access the Analytics Service by installing the Analytics Marketplace extension. Installing it provides several advanced widgets, Power BI integration, and access to the OData feed.

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

The Analytics service 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 Service and Performance and latency.

Once you've installed the Analytics extension, the Analytics 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 Service and Performance and latency.

You can access the Analytics service through dashboard widgets, Power BI, and OData. In addition to the work tracking widgets, you can analyze test results via the test analytic charts for builds and releases.

Dashboard widgets

You can create dashboards and add widgets to them. We provide several widgets based on the Analytics Service. These widgets take advantage of the power of the Analytics Service. 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 Service - 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 the Analytics Service, see Create an Analytics widget for Azure DevOps.

Power BI

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

The easiest way to pull Azure DevOps data into Power BI is to use the Power BI Data Connector. The Azure DevOps Power BI Data connector works with Analytics views. For more information, read What are Analytics views.

Power BI Azure DevOps Connector (Beta)

Power BI Azure DevOps Server Connector (Beta)

Also, you'll find additional ways to pull Azure DevOps data into Power BI as described in Power BI integration overview.

OData

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

Data available in the Analytics service

At this point, not all data is available via the Analytics service. For more information, read Data available in Analytics.

Availability for Azure DevOps Server

Azure DevOps Server 2019 and later versions support Analytics. 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 the Analytics Service. You may also use SQL Server Reporting.

Try this next