Professional SQL Server 2000 Data Warehousing with Analysis Services

Data warehouses have evolved to cope with the huge volumes of data flowing through the workplace by separating the data used for reporting and decision making from the operational systems. The purpose of the data warehouse is simply to store the raw data, and in combination with Microsoft SQL Server 2000 Analysis Services, this data can be transformed into accessible information that reflects the real factors affecting the enterprise.

In this book, we introduce the key concepts of data warehousing, OLAP, and data mining. In addition to coverage of Data Transformation Services (DTS) and MDX, this book also demonstrates how to develop an Analysis Services client application, and how to secure and optimize your data warehouse. There is also an in-depth discussion of the exciting new topic of Web Housing.

By reading this book, you will 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.

This book covers:

Understanding Analysis Services Architecture
Designing Data Warehouses and Data Marts
Using Data Transformation Services (DTS) in Data Warehousing
Techniques for Data Mining and Analysis
Building OLAP cubes with Analysis Manager, and programmatically through DSO
Securing, Administrating and Optimizing a Data Warehouse and OLAP system
Using Multidimensional Expressions (MDX) to query OLAP cubes
Building OLAP client applications with Visual Basic and ASP
English Query, PivotTable Service

Chris leads projects with Oracle 8i and SQL Server 2000 typically coupled to web based solutions.

Mark Scott serves as a consultant for RDA, a provider of advanced technology consulting services. He develops multi-tier, data-centric web applications. He is a Microsoft Certified System Engineer + Internet, Solution Developer, Database Administrator and Trainer.

As a partner of a consulting firm, Applied Technology Group, Mike Benkovich has a broad range of experience with development technologies and platforms. Besides SQL Server, he has worked extensively with Informix, Oracle, C++, Visual Basic, PowerBuilder and Unix. Mike can be reached at mbenko@atgmn.com.

Paul Turley is a Senior Instructor and Consultant for SQL Soft+ Training and Consulting in Beaverton, Oregon and Bellevue, Washington. He specializes in database solution development, software design, programming, and project management frameworks.

Robert Skoglund is President and Managing Director of RcS Consulting Services, Inc. Robert also provides certified training services to Microsoft Certified Technical Education Centres nationwide and internationally. He can be reached at rskoglund@rcs-consulting-inc.com.

Sakhr Youness is a senior architect at Commerce One, Inc. He is a professional engineer and a Microsoft certified solution developer who has experience in data modelling, business-to-business (B2B) applications, client server and database application development. He can be reached at syouness@home.com.

Denny Lee is the Lead OLAP Architect at digiMine, Inc. (Bellevue, WA), a leading analytic services company specializing in data warehousing, data mining and business intelligence. His primary focus is delivering powerful, scalable, enterprise-level OLAP solutions that provide customers with the business intelligence insights needed to act on their data.

Robin Dewson is currently working on a system called "Vertigo", replacing the old trading system called "Kojak". He has been with a large US Investment bank in the City of London for over 5 years.

Sam Ferguson is an IT Consultant with API Software, a growing IT Solutions Company based in Glasgow, Scotland. Sam works in various fields but specialises in Visual Basic, SQL Server, XML, and all things .Net.

Tony Bain (MCSE, MCSD, MCDBA) is a senior database consultant for SQL Services. While he has experience with various database platforms, SQL Server has been the focus of his attention. During this time he has been responsible for the design, development and administration of numerous SQL Server based solutions.

Terrence Joubert is a Software Engineer working with Victoria Computer Services. He also works as a freelance Technical Reviewer for several publishing companies. As a developer and aspiring author, Terrence enjoys reading about and experimenting with new technologies, especially the Microsoft .Net products.