Panorama Business Intelligence

I recently contributed a thought leadership article to the Microsoft SQL Server Team Blog around PowerPivot and the value it brings to the Analysis Services platform. It’s a hot topic these days, so please share your thoughts & ideas here or on the Microsoft Blog, and join the conversation!

“As Microsoft PowerPivot is gaining more popularity and exposure, BI professionals ask more and more questions about PowerPivot’s role in the organization in trying to understand what value the new in-memory BI solution from Microsoft brings, along with the benefits and the limitations of it. Is PowerPivot going to replace SQL Server Analysis Services? If so, how soon? What should be done with the existing BI solution? Or maybe both can coexist and serve different needs?

In order to answer these questions and understand both short and long term impacts of the new products on your BI solution we need to understand what motivated Microsoft to release this new creature and where do they position it. Microsoft are trying to achieve two main goals – introduce a new in-memory engine for data processing and promote the self-service BI concept extending the usage of BI systems to a wider audience.”

Read full article at Microsoft SQL Server Team Blog: PowerPivot & Analysis Services – The Value of Both