Comparing Analysis Services and PowerPivot
As more customers are getting aware of PowerPivot, they’re looking for more guidance on when to use what it vs. Analysis Services. This post is our view of the BI landscape and how SQL Server Analysis Services and PowerPivot satisfy needs across the organization. After going through it, hopefully you’ll also get a deeper understanding of the key design points for each.
The Business Intelligence Continuum
In our view, Business Intelligence (BI) provides business insights to all employees leading to better, faster, more relevant decisions. Microsoft recognizes decisions are made at employee, team and organization levels, and that in order to be successful, BI technology must support needs across this continuum.