O'Reilly logo

SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond by Tom Carpenter

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

Understanding and Installing Analysis Services

SQL Server Analysis Services is a core BI component within the SQL Server system. Analysis Services provides the DBA with the ability to create multidimensional data structures. If you're familiar with pivot tables in Microsoft Excel, think of the multidimensional data structures as 3D pivot tables. Much as you use pivot tables to analyze large amounts of data, Analysis Services provides fast analysis of extremely large amounts of data. For example, analyzing millions of rows in several joined OLTP tables can take several minutes compared to a few seconds with an Analysis Services data source.

Analysis Services can work with data warehouses, data marts, or production operational databases.

Data Warehouses ...

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