O'Reilly logo

Practical Business Intelligence: with SQL Server 2005 by Roger Toren, John C. Hancock

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

Summary

This chapter examined the various components that make up the SQL Server 2005 BI platform. You can decide where you want to install the SQL Server components based on the particular environment that they are deployed into. SQL Server Management Studio enables you to administer all the different components, and the BI Development Studio enables you to design BI solutions.

The SQL Server database engine is a highly reliable, available, and scalable database server used to store the relational data warehouse. Integration Services provides the data ETL services that you use to deliver clean, validated data to your data warehouse.

Analysis Services is an OLAP engine designed to support storing and querying large amounts of data based ...

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