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 ...

Get Microsoft ® Office 2007 Business Intelligence now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.