The purpose of the data warehouse to store raw data only, and in combination with Microsoft SQL Server 2000 Analysis Services, this data can be transformed into information that can be accessed that reflects the factors that significantly affect the company. In addition to coverage of Data Transformation Services (DTS) and MDX, this book also shows how to develop an Analysis Services client application, and how to secure and optimize your data warehouse. This book covers: Understanding Analysis Services Architecture Designing Data Warehouse and Data Mart Using Data Transformation Services (DTS) in Data Warehousing Data Mining and Analysis Techniques Building OLAP cubes with Analysis Manager, and programmatically through DSO Securing, Administer and Optimizing Data Warehouse and OLAP systems Using Multidimensional Expressions (MDX) to query OLAP cubes Building OLAP client applications with Visual Basic and ASP English Query, PivotTable Service