O'Reilly logo

Microsoft SQL Azure: Enterprise Application Development by Jayaram Krishnaswamy

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Consuming SQL Azure data with PowerPivot

PowerPivot with SQL Azure gives an enormous amount of power to SQL Azure. The reason for this, is that PowerPivot can work with massive amounts of data in reasonable time compared to other methods. PowerPivot teaming with SQL Azure is the best way for business intelligence to achieve excellent performance. PowerPivot is an add-in for Excel2010, which means you need to have Excel2010 on your computer. The data that PowerPivot extracts from the database will be stored in a local OLAP database engine in memory, which provides the analytic capability to Excel2010. Call it a combo Excel + Analysis services in one package.

In this short section, we will not look at any of the exotic things you can do with PowerPivot, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required