Chapter 2. Understanding OLAP and Analysis Services

After completing this chapter, you will be able to:

  • Understand the definition of OLAP and the benefits an OLAP tool can add to a data warehouse.

  • Understand how Microsoft SQL Server Analysis Services 2005 implements OLAP.

  • Understand tools for developing and managing an Analysis Services database.

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. The large relational databases typical of data warehouses need additional help to convert the data into information. In this chapter, you will first learn the general ...

Get Microsoft® SQL Server™ 2005 Analysis Services Step by Step 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.