Microsoft Business Intelligence without SharePoint

This might be a strange topic given that the release of SharePoint 2010 is just around the corner, but I wanted to respond to a couple of questions and debates I have been involved with in my temporary role in the partner team.

I would like to start by going back to the early days of Microsoft BI, analysis services (and OLAP services before it) were just getting established but there was no analysis services client from Microsoft to give users full access to the cubes in analysis services.  There were two third party contenders out there Panorama NovaView and ProClarity.  These were both web clients and as they evolved they both developed portals form which reports and content could be accessed and changed.  They also had security baked into them on top of what was in analysis services itself.  ProClarity was acquired by Microsoft and the descendants visualisations in that tool (such as the decomposition tree) are now in SharePoint 2010 enterprise.

Panorama continues to be a Microsoft partner and is a good choice for business who just want a web client to get at their analysis services cubes, or even to get more functionality out of PowerPivot.  They also continue to have their own portal or can integrate with SharePoint as desired.  There also another 40+ products form partners out there which also provide web access to cubes, and here is a good a list as I’ve found of them

The other key Microsoft BI offering is reporting services which either has its own portal complete with security (Report Manager) or can be integrated into SharePoint.

So you don’t have to use SharePoint to provide Microsoft based BI to your users, but I would submit you are going to need some sort of portal, even if this is just a set of web pages where users can see content they are allowed to see and add more content to it (again subject to security).

However if you want to provide access to reporting and analytics to your users then SharePoint or a similar dedicated portal would be a better option as you can then provide a single point of entry and a single security mechanism to control access to BI.

On the question of cost you could just use SharePoint Foundation (the successor to Windows SharePoint Services), and SQL Server Standard edition, this would give you reporting services integration, and the other key parts of the Microsoft BI stack (analysis services and integration services). However you won’t get the performance point monitoring and analytics (which is in SharePoint enterprise) so the money you save by doing this must be off set against the need to buy a third party tool (like those I have listed above) to replace this functionality.  You might not actually save any money and the solution could be more complex, but it might be exactly what your users need.  This is a good thing, both for business and for Microsoft:

• Its good for business as you have a choice in which BI client tools you want to use and you can choose how locked into SharePoint you want to be.
• It’s good for Microsoft as this ecosystem helps put Microsoft at the forefront of BI vendors and offers a wider set of capabilities than Microsoft alone can provide.

What I would suggest is to at least have a look at SharePoint 2010 as it’s scarily easy to set up and use even for this old DBA.

Comments

• Anonymous
  April 12, 2010
  Hi Andrew, Thanks for sharing this insight and info. I was not aware of Sharepoint Foundation, and came to learn about it from this article. I intend to soon blog about it :)

• Anonymous
  April 22, 2010
  Andrew, good article.   I think it's important to remember that many people are still using WSS 3.0 and SQL 2005.  For those folks, the decision to 'go SharePoint' feels like a strategic thing which requires much evaluation. The approach you describe can be pitched as a no-cost 'proof of concept'.  Further, when combined with the new Dundas widgets in SSRS 2008 can be a real eye-opener to people used to bulky report listings. It just requires a bit of initiative. Cheers, Donna Kelly

• Anonymous
  April 23, 2010
  Andrew, What about Excel for accessing the Cube, this does not 'need' Sharepoint. and most of my users have it on thier desktop and 'know' how to use it.

• Anonymous
  April 26, 2010
  Alun Of course you are right Excel is a very good cube browser. However what I should have made clearer in this post was that I was looking at web based tools, whihc is why I didn't mention it. apologies for the confusion, Andrew

• Anonymous
  June 26, 2012
  Nice article.

• Anonymous
  February 11, 2014
  Andrew, Now with SharePoint 2013 and SQL BI, do we need both in order to deliver BI? Thank you, Alkis

• Anonymous
  February 12, 2014
  What I have written here still applies however I can't really answer this as I don't know what you need from BI. For example SharePoint extends BI by allowing for collaboration. This means as a BI Business guy I can build a model and share it without needing help from IT. Also many decision are made partly by looking at the numbers and by looking at qualitative data in reports which are also stored in SharePoint. SharePoint also provide a security model which can be used to restrict access to sensitive data. So you could find yourself trying to build something like SharePoint anyway and my advice if there is an off the shelf tool to suit your needs use it! Hope this helps but if note please drop me an e-mail