| title | Analytics query tools |
|---|---|
| titleSuffix | Azure DevOps |
| description | Learn about the tools you can use to query the Analytics service. |
| ms.custom | analytics |
| ms.subservice | azure-devops-analytics |
| ms.author | chcomley |
| author | chcomley |
| ms.topic | overview |
| monikerRange | <=azure-devops |
| ms.date | 08/12/2022 |
[!INCLUDE version-lt-eq-azure-devops]
You can query Analytics from a web browser or other supported tools. To create reports, we recommend you use Power BI. Power BI is free and provides a suite of business analytics tools that you can use to perform impromptu analysis, produce reports, and publish reports for enterprise consumption.
To help you get started, use the guidance provided in the following table to determine which tool you should use based on the task you want to accomplish.
| Task | Tool | Notes |
|---|---|---|
| Query the metadata | Any supported web browser | Review the Analytics data model consisting of EntityTypes, properties, enumerated member names, supported functions, and more. To get started, see Query the Analytics service. |
| Create a status or trend report for work tracking data | Analytics views Power BI |
Use a default view or create a custom view to filter work tracking data. For more information, see Create a Power BI report with a default Analytics view. |
| Create a report from a work item query | WIQL to OData extension Power BI |
Install the extension to get an OData query based on the filtered set of work items. Then use Create a Power BI report with an OData Query. |
| Create reports or dashboards based on Analytics data | Power BI | You can specify a Power BI query or OData query within Power BI to filter the data. For more information, see Overview of sample reports using OData queries. |
| Write and test OData | Visual Studio Code OData for Visual Studio Code |
Visual Studio Code is a free code editor available on Windows, Mac, and Linux. The OData extension provides syntax highlighting and other functions that are useful for writing and testing queries. |