SQL Server Analysis Servics vs Excel 2010 PowerPivot (and PowerPivot for SharePoint)

In a meeting with some BI/accounting specialists last week I was challenged with the following question:

  • You talk about Analysis Services, PowerPivot and PowerPivot for SharePoint, but what is right for us, and when to use which tool?

I'm not at BI / Analysis Services specialist, but I really would like to bring to the table some guidlines that both explains the different tools and when to use what. Luckily I didn't have to create this comparison myself - Microsoft have already done it.

It really depends on your focus:

  • Organisational BI => Analysis Services

  • Personal BI => PowerPivot

  • Team BI => PowerPivot for SharePoint 2010

Read the whole article:

No comments: