Data Warehousing With Microsoft Sql Server 7.0. Technical Reference (Microsoft Technical Reference) - Softcover

Inhaltsangabe

Discover how to build and manage enterprise data warehouses efficiently. Data warehouses help users view information in new ways to spot 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. " DATA WAREHOUSING WITH MICROSOFT SQL SERVER 7*0 TECHNICAL REFERENCE " 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. Coverage includes : Introduction to data warehousing : operational versus analytical data, data warehouses and data marts, characteristics of a successful data warehouse, planning and design. Online analytical processing (OLAP) services for performing rapid, sophisticated analysis of complex relational data. Data Transformation Services (DTS) for transporting data across heterogeneous sources supported by open database connectivity (ODBC) and OLE DB. Advanced query processor and the multidimensional expressions (MDX) query language for executing complex queries. SQL Server cubes and the Pivot TableO service. High-performance utilities for managing and tuning data resources. Appendixes about Microsoft Query and Microsoft Repository. CD-ROM with extensive sample databases and utilities to help you get started. This book is the best introduction to building enterprise-wide data warehousing solutions with maximum efficiency. It shows you not only how SQL Server 7*0 can help you create data warehouses but also what steps you need to take to implement its powerful features in the enterprise.

Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.