In the last post we saw the final result of what we’re aiming for – the Bug’s Life report . In this post, we’ll start working on the report by actually extracting the data . The TFS Reporting Data Sources TFS supplies us with two different data sources for reporting needs: The data warehouse – A relational data store that is designed using a snowflake schema and is named Tfs_Warehouse. By default, this database is updated within 30 minutes of an anything ‘interesting’ happening in TFS. We query this...