The Value Proposition of PowerPivot.This says it all.
Value Proposition of PowerPivot (in CIMA Insight) « PowerPivotPro
Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.