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.

Pro VS 2005 Reporting Using SQL Server and Crystal Reports offers aproven methodology for building reporting solutions. The authors focuson SQL Server 2005 and Crystal Reports, but also cover other populartechnologies like Oracle and ActiveReports, to give you a thoroughgrounding in the reporting field. The book presents the requirements fora real-world reporting application in a distributed environment, and covers all the phases of development.