What on earth is consumerisation and what has it got to do with Business Intelligence? Consumerisation is the recognition that our users are tech savvy and want to have access to the tools and way of working that they have outside of work. Self Service is the result of applying these ideas to BI:
Our users know what they want
My way of looking at the end user BI tools look today is …
the users thinks it’s all green and only the BI IT community worry about the red stuff. On the other hand the more traditional approach to BI might be summed up as..
It’s strategic but can be hard to change and while no one can deny that the MDX query language is very powerful it isn’t easy for business users or for IT (outside the BI industry) to understand. So a third way is need and that would look like this..
i.e. Take the work done in the self service tools and then scale it up put in control and security. Having done that we then want to put it into production and then hook up all the end users familiar tools to interrogate it.
In Denali ctp3 this is now doable using the BI Sematic Model (BISM):
I would stress that this approach is in addition to the traditional approach that has been in SQL Server with analysis services since 2005, and you can verify that and try this approach by pulling down SQL Server Denali ctp 3 , SharePoint 2010 with sp1 and the matching sample databases, reports and tutorials for BISM on codeplex.