This is a great treatise on the TFS data warehouse and the TFS cube, giving some concrete information on perspectives and creation of reports...

Link to Teams WIT Tools : Understanding the TFS Cube