Often, a key to that question is training of the users. Training can often be a critical step to creating momentum that is needed to ensure long-term use, and therefore success. Unfortunately, many of the data warehouse analysis tools are still not that user friendly. Becoming a skilled and proactive user still takes training and hand-holding. This one is tricky because it's quite important that you make the right choices right from the beginning.
Many options are available.
Because it is so important, The Institute presents a great deal of information in this area at each one of our conferences. But you must be careful. A different architecture might be looked at for a short term, urgent, limited solution than an architecture for a solution that is more robust, longer term and broader scope. When things seem to slow down in IT on your project, it is these kinds of issues that are being evaluated. And there are a wide variety of foundations to choose from.