Written for those who work with databases on the SQL Server 7 platform, Professional Data Warehousing with SQL Server 7.0 and OLAP Services
gives you what you need to implement a data warehouse successfully. This hands-on tutorial exploits the built-in capabilities of various Microsoft tools.
Besides a general introduction to the world of data warehouses (and data marts) done the Microsoft way, this book is best at showing you how to master tools like OLAP Manager, which lets you effectively create and manage data warehouses. There are dozens of screen shots for a variety of tools in action, including the Data Transformation Services (DTS) Designer (for transforming data from one source to another) and the powerful PivotTable tool (which can be used to analyze information).
This tools-based approach means that you can get up and running with OLAP tools without understanding every theoretical detail. (The book does cover the basics here, but it's the practical focus that will make it useful to the working data architect.) There is also coverage of the powerful (and somewhat quirky) Multidimensional Expressions (MDX) from Microsoft, which extends SQL for querying against dimensional data in "cubes." Chapters on basic and advanced MDX will show you how to get the most out of this standard with your databases. (For samples, the book relies mainly on case studies from the Microsoft Web site.)
It used to be that data warehousing required a lot more work just to get started. Armed with Microsoft tools and this capable guide, most anyone can plan and build a data warehouse successfully for SQL Server 7. This is a solid how-to on an essential topic in enterprise database development. --Richard Dragan
Topics covered: Online Analytical Processing (OLAP) and data warehouse basics; data marts; data mining; Microsoft OLAP and tools; Data Transformation Services (DTS); metadata and the Microsoft Repository; MS OLAP architecture for servers and clients; dimensions and OLAP cubes; drill-down and roll-up; slicing and dicing; star, constellation, and snowflake schemas; virtual cubes; partitions; project design for data warehouses; case studies from Microsoft; techniques for capturing data; OLAP Manager tutorial; using the cube editor; DTS packages and the DTS designer; automating data transformation; data-driven queries; bulk inserts with BCP; beginning and advanced Multidimensional Expressions (MDX); OLAP presentation; using PivotTable; design considerations for data marts; data mining basics; statistics and third-party tools; security; administration and maintenance for data warehouses; replication techniques; optimization and tuning.
From the Publisher
This book discusses the architecture of a data warehouse, and introduces the concept of multidimensional data representation using Microsoft OLAP. This book provides a complete introduction to designing, building and tuning Datawarehouses using SQL Server 7. There are many features new to SQL Server 7 that facilitate storage, retrieval, analysis and distribution of large amounts of data from Data Warehouses. This book covers them all in detailed examples - as well as showing how to design and build a bespoke Datawarehouse in SQL Server. OLAP and Microsoft Decision Support Services, ROLAP, and HOLAP options are covered. How to maximize performance using the new Query Analyzer, Tuning Wizard, and SQL Profiler tools is included as well as how to implement incremental backup. This will enable the analysis of large amounts of complex information with the latest data warehousing technologies. By reading this book you'll learn how best to employ data warehousing and OLAP in your business and how to leverage it to provide your organization with improved revenue and profitability.