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