Hi all, I am SQL Server DBA. I am investigating different BI options for an organisation. Today I just had QlickView did a demo for us. It is good to know the new trend of in-memory analysis solutions. I know Microsoft has released an Excel add-on Powerpivot which is also capable of in-memory analysis. But as Power Pivot is based on Excel, could you guys shed some lights on the best way of deploying Power Pivot in the following enterprise environment.
5-10 Business analysts/Report developers
5-10 internal report users (in domain)
20-50 external report users who prefer to access report via browser
(outside the domain).
I would like to have a Power Pivot server, if possible, for dataset version control and reduce resource requirement on individual desktop. But I prefer not to use SharePoint. The reason for this is not to increase the scale of the project, as we are not currently running SharePoint
We also have asp.net application we would like to provide on-line analysis service in the future. Does Microsoft has plan to release a in memory BI services, which can be integrated into non-SharePoint web application. (Please let me know if there is such a thing already.) Thank you very much. Discussions are welcome.