My colleague Rene van Osnabrugge has written a great post on utilising the true power of you TFS data! Using Excel’s PowerPivot functionality combined with slicers you get highly performant reports.
Read more about these great capabilities here: http://roadtoalm.com/2014/07/17/tfs-reportsunleash-them-with-powerpivot/
Happy Pivoting!