Chapter 2. Understanding OLAP and Analysis Services

In this chapter, you will learn how to:

  • Understand the definition of OLAP and the benefits a multidimensional OLAP database can add to a business intelligence system.

  • Understand the advantages of Microsoft SQL Server 2008 Analysis Services.

  • Understand the role Analysis Services plays in the Microsoft business intelligence platform.

  • Understand the tools for developing and managing Analysis Services databases.

Business intelligence (BI) is a way of thinking. A data warehouse is a general structure for storing the data needed for good BI. But data in a warehouse is of little use until it is converted into the information that decision makers need. In this chapter, you will first learn the general benefits ...

Get Microsoft® SQL Server® 2008 Analysis Services Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.