In my roles as a technical lead and a consultant, I have been often posed with this question – which is the best BI tool for this set of requirements and what is the best mode of presentation for this? I learned to answer this question from the various experiences I had in my projects since the past few years. Well, I am glad to say that answering this question should not be much of an issue even for a less experienced person with the latest whitepaper that has been released by Microsoft – Choose the right business intelligence technology to suit your style (white paper) 
The title might be a bit deceptive as it talks only about the Microsoft BI suite, but hey, did you really expect something else to come out of Microsoft? Overall, it is a good read for anyone who wants to understand which MSBI tool to use where and when. Read and get enlightened.
How to Choose the Right Business Intelligence Technology to Suit Your Style
