- 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: