Learn to use Visual Studio, Visual Studio Online, Application Insights and Team
Foundation Server to decrease rework, increase transparency into your application and increase the rate at which
you can ship high quality software throughout the application lifecycle
The data warehouse is a relational database organized in a star schema with an OLAP database derived from that database. The OLAP database allows the reporting tools to access the derived information without degrading the performance of the relational database that actually stores the real-time information from the clients.
The warehouse stores several types of facts contributed by each of the Team Foundation tools as a primary relational table and a cube in the OLAP database that draws from that table. Each fact within a table has details, dimensions, and measures.
For changes that are made to the process template, updates occur on each data load. By default, the data warehouse is updated once per hour. You can control how frequently the OLAP database updates the derived information it provides to the reporting tools. The schedule depends on the needs of your system.