This book is for anyone who wants to develop an understanding of data warehousing using SQL Server 7.0. It is the best introduction to building enterprise data warehousing solutions with SQL Server 7.0 . Data warehouses help users look at information in new ways so that they can sport patterns and trends, gain insights, and make better business decisions. But building data warehouses can be difficult without practical knowledge of how to define user needs, map corporate data, and consolidate information in a coherent format. This book simplifies this complex process by showing you how to take advantage of the features of SQL Server 7.0 to design, build, and manage a data warehouse. The book introduces and explains data warehousing and then discusses planning and design, online analytical processing (OLAP), star schemes, data transformation services (DTS), multidimensional query language (MDX), developing SQL server cubes, and more-with extensive sample databases and utilities. The companion CD-ROM contains extensive sample databases and utilities to help you get started .