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 ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.
