Announcing Reporting Capabilities for Visual Studio Team Services

This post announces the upcoming public preview of advanced reporting capabilities for Visual Studio Team Services, which will eventually replace the on-premises TFS data reporting warehouse. The new service is backed by SQL Server and uses the Open Data Protocol v4, offering custom reporting over VS Team Services data. It highlights the ability to perform aggregations and use tools like Excel, Power BI, and Tableau. Specific OData queries are provided as examples for calculating the sum of remaining work and grouping work items by type. The initial data available will be work item data, followed by version control, test, build, and release data. New reporting capabilities include velocity (estimated and actual), capacity, team filtering, Kanban metrics (median days in state, lead time, cycle time), trend and rollup data, and tags. The post also shows a schema for the work item data model and expects the public preview for work item data in Q3 2016.