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