PowerPivot & MDS Architecture

Question

Hi,

I would to rollout PowerPivot to key users, im not too sure whats the best setup
I am setting up 2 VM (Storage DB Engine, Analytics Presentation)

1. How do i go about the architecture
   A. PPivot > On Storage VM create Views, affect ETL etc?
   OR B. PPIvot > on OLAP Cubes only?
   OR C. PPivot > have DB engine setup on Presentation VM to store views for PPivot Only?

2. Does the Presentation VM also be 120/64 processors?

3. The Goal is to process cubes on Strage VM and robocopy the databases over to presentation once completed, will this not lock when cube active or better methods used?

4. Is MDS also on Storage VM, I want to share the WEB for users > best practise?

Server does not do paralism well, so im not sure where ppivot connects and processes data?

Thank You

Answer 1

Thank You so much, does sql dw & cubes remain.
Is this kust a presentation tool on top of olap cubes?