SSRS is a great tool for canned reports, and reports that need a variety of parameters. It is not a what-if tool. Most people understand Excel, so I think a great ad-hoc reporting tool is either Excel or PowerPivot which is very Excel like. It is possible to configure them to connect directly to a data model or data source.