Chapter 10Analysis Services

Analysis Services is an engine that provides near-real-time and real-time business information for your users. Business intelligence (BI), also known as business information, is the process of pulling useful information from the data your systems store. In this chapter, I explain what BI is along with some common business intelligence scenarios and how you can use SQL Server 2005 features to implement them. The first section of the chapter is not meant to be an exhaustive treatment of the subject; but you do need a background on what a BI system is and a basic understanding of how it works to manage it properly. I give you an overview that will bring you up to speed on the major concepts.

To create the physical layout ...

Get Administrator’s Guide to SQL Server 2005 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.