TFS Warehouse Cube
Wrapping up a few technical articles I hadn't had the time to look at in the past, I want to point you to the following blog entry:
https://blogs.msdn.com/teams_wit_tools/archive/2007/04/30/understanding-the-tfs-cube.aspx .
A good overview over the TFS Cube, it's dimensions and a great quick start to reporting with Excel Pivot tables on the TFS cube. This helped me to understand a bit more topics related to the cube reporting. The blog entry is really outstanding becuase of its included video demos. Have a look: