Chapter 1. Designing the Data Warehouse for Analysis Services

The focus of this chapter is how to design a data warehouse specifically for Analysis Services. There are numerous books available that explain the theory of dimensional modeling and data warehouses; our goal here is not to discuss generic data warehousing concepts, but to help you adapt the theory to the needs of Analysis Services.

In this chapter, we will touch on just about every aspect of data warehouse design, and mention several subjects that cannot be analyzed in depth in a single chapter. We will cover some of these subjects in detail, such as Analysis Services cube, and dimension design, in later chapters. Other aspects, which are outside the scope of this book, will require ...

Get Expert Cube Development with SSAS Multidimensional Models 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.