Publisher's Synopsis
SQL Server 2000 comes with a powerful set of analysis tools, at the heart of which lies SQL Server 2000 Analysis Services. These are a significant extension to the robust OLAP functionality of SQL 7.0 and provide a complete, end-to-end platform for analysis. Features include: data Mining, Web-Enabled Analysis, and Closed Loop Analysis, plus increased speed, scalability and ease of use.;This book covers: data warehousing and data mart principles; Microsoft SQL Server data warehousing and OLAP architecture and features; how to design and administer a data warehouse that will run in SQL Server 2000; SQL Server 2000 tools that make data transformation from development databases to the data warehouse easy; making developing OLAP applications and administering the data warehouse simpler; and using the data mining features in SQL Server 2000.