O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 22. Analysis Services

Business systems capture data from ongoing operations, whether the data is entered by a human being or generated by an automated process, and often store this data in a relational database. As a database administrator, you’re already familiar with the virtues of a relational database for supporting business operations. You’ve also likely encountered its limitations when people want to start using the relational database as a source for analysis. At its simplest, the preparation of data for analysis requires summarization of detailed transaction data. However, data preparation becomes more difficult when you need to support ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required