I don't really know how to compose this question. My complay has been using Microsoft ProClarity for few years and we have a quite a few users using it publising books and doing ad-hoc analysis. With the new Microsoft BI solutions, it seems like they are completely going away from ProClarity and replacing the OLAP analysis with Excel. I understand the with SharePoint and integration with PerformancePoint and reporting services the dashboards and reports would be done in SharePoint but what about the analysis? Any ideas?
+1
A:
Not to sure if this answers ypur question, but nhe new version of Excel (2010) and SQL server 2008 R2 use PowerPivot for making BI easier (and more powerful) for (end-)users.
Colin
2010-05-09 10:07:52