The basic difference between these technologies is a place where the data is storaged and processed. The traditional approach claims that there exists the central data repository, where client tools are strictly connected with the server repository.
Self-Service BI (often called as Personal BI) is something different. It doesn’t need central object in its architecture, but the role of client tools is enhaced. Using these tools it is possible to create analytical models. The user can also modify existing solutions or even create them, without need to involve a lot of people. Self-Service BI, in contrast to the traditional approach, doesn’t require expensive investment in machines. But it also doesn’t guarantee “the only one version of the truth” and easy documents sharing.
The existence of several different solutions of the same business area can cause a real implementational problem. However, both solutions may exist simultaneously giving an opportunity to eliminate defects and emphasize advantages. One of the hybrid solutions is rearing Pover Pivot model on Sharepoint server. Thereby, a lot of final users can use a specific model, modify it and share with others.
Presently a lot of software providers allow to create Self-Service BI solutions, e.g. Microsoft Self-Service BI or QlikView.
Self-Service BI conception in Microsoft technology is based on MS Excel.