O'Reilly logo

Microsoft ® Office 2007 Business Intelligence by Doug Harts

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

4.6. Importing SQL Server OLAP Data into Excel 2007

This section is a fairly exciting look at one of the advanced business intelligence aspects of SQL Server: Analysis Services. Most business users do not know what Analysis Services is, or OLAP in general. But it can have a profound benefit when business users connect to Analysis Services OLAP cubes with Excel 2007. In fact, some people might say that Excel and OLAP cubes, together, are the leading edge of business intelligence on the desktop.

4.6.1. What Is an Analysis Services OLAP Cube?

When people need to evaluate summarized data in a flexible manner, online analytical processing (OLAP) can provide the fastest way to look at the data and create totals/subtotals on the fly. One of the classic ...

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