Today, I\u2019m announcing that advanced reporting capabilities are coming soon to VS Team Services.\u00a0 You\u2019ll be able to stay tuned through the \u201cfeatures under development\u201d section on our features timeline<\/a>.\u00a0 We think of the new reporting service as the beginning of an analytics service \u2013 our vision is to unlock analytics over your data and surface insights in an simple and meaningful way to drive action.\u00a0 The reporting experience will be available first in VS Team Services, and eventually replace the existing on-premises TFS data reporting warehouse.<\/p>\n Custom reporting capabilities<\/strong><\/p>\n The public preview of the cloud reporting experience will enable custom reporting over your VS Team Services data.\u00a0 The service is backed by SQL Server and uses the Open Data Protocol v4.\u00a0 It is architected and built to be fast, performant, and scalable.\u00a0<\/p>\n You\u2019ll have the full power of OData available to you, including aggregation extensions.\u00a0 You\u2019ll also be able to use data analytics tools like Excel, Power BI, Tableau, or even the Business Intelligence and Reporting Tools (BIRT)<\/a> in Eclipse to mashup data from multiple sources and create powerful visualizations of your data.\u00a0 And since it\u2019s OData, there are a number of other ways to access data \u2013 programmatically with .NET or Java, or via direct URL queries in the browser.\u00a0 It\u2019ll also be possible to build a VS Team Services dashboard widget<\/a> or extension<\/a> using the data service.<\/p>\n Let me give you an example.\u00a0 Let\u2019s say I wanted to get the sum of all remaining work in my account.\u00a0 With the on-prem TFS reporting options, that would not be an easy number to get.\u00a0 With the new reporting service, I can construct a direct URL and use aggregation extensions to easily return that value using the query below:<\/p>\n To grab all work items and then group them by type, I can use the Now let\u2019s take the result of that query and bring it in to Power BI.\u00a0 Using the treemap visualization you now have a view of all the work items we have in mseng<\/em>, the VS Team Services account that we use to build VS Team Services and TFS.<\/p>\n <\/p>\n Work Item Data<\/strong><\/p>\n The first type of data available will be work item data, followed by version control, test, build, and release data.\u00a0<\/p>\n There will be a number of new capabilities that you can report on that weren\u2019t available previously, such as:<\/p>\n The schema below shows you the richness in the current data model we have for work items.\u00a0 Keep in mind that this isn\u2019t comprehensive, but an early look at what\u2019s there.<\/p>\n We expect to have a public preview of our cloud reporting experience for work item data for your Visual Studio Team Services accounts in Q3 of 2016.<\/p>\n Thanks!<\/p>\n<a href=\"https:\/\/[collection\">https:\/\/[collection<\/a> name].analytics.visualstudio.com\/DefaultCollection\/_odata\/WorkItems?$apply=aggregate(RemainingWork with sum as SumOfRemainingWork)<\/code><\/p>\ngroupby<\/code> clause and the following query:<\/p>\n<a href=\"https:\/\/[collection\">https:\/\/[collection<\/a> name].analytics.visualstudio.com\/DefaultCollection\/_odata<\/code>\/WorkItems?$apply=groupby((WorkItemType), aggregate(Count with sum as Count))<\/font><\/p>\n![\"image\"](\"https:\/\/devblogs.microsoft.com\/devops\/wp-content\/uploads\/sites\/6\/2016\/01\/3581.image_thumb_0E0FC2D7.png\" "\\"image\\"")
<\/p>\n\n
![\"image\"](\"https:\/\/devblogs.microsoft.com\/devops\/wp-content\/uploads\/sites\/6\/2016\/01\/6327.image_thumb_0BD5CACC.png\" "\\"image\\"")
<\/p>\n