I'm installing SQL Server 2008 R2 which would be helpful in
A. querying database.
B. Analysis Services
C. Reporting services and BIDS (SSRS)
D. Powerpivot in Sharepoint
During installation I get two options:
a. SQL Server feature installation: this would install database engine, analysis services, reporting services etc
b. SQL Server for powerpivot for sharepoint: This would be helpful for powerpiviot in Sharepoint. Not sure this option would install all the options mentioned in first option - SQL Server feature installation.
My Question: Which option I should select? If i go for option-a at present, can I later change it to powerpivot option i.e option b.???