Professional SQL Server 2000 Data Warehousing with Analysis Services [Illustrated] [Paperback]

Chris Graves (Author), Mark Scott (Author), Mike Benkovich (Author), Paul Turley (Author), Robert Skoglund (Author), Robin Dewson (Author), Sakhr Youness (Author), Denny Lee (Author), Sam Ferguson (Author), Tony Bain (Author), Terrence Joubert (Author)

Book Description

Publication Date: October 2001

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

Editorial Reviews

From the Publisher

This book has been selected by the editors of Wrox Press to be part of the Wroxbase website.

This book is aimed at the SQL Server developer who wishes to learn about the enhanced data warehousing features and new services available in SQL Server 2000 Analysis Services, and IT professionals and managers who wish to investigate SQL Server's data warehousing capabilities.

About the Author

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 [e-mail].

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 [e-mail].

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 [e-mail].

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.

Product Details

• Paperback: 800 pages
• Publisher: Peer Information Inc.; 1st edition (October 2001)
• Language: English
• ISBN-10: 1861005407
• ISBN-13: 978-1861005403
• Product Dimensions: 9 x 7.3 x 1.5 inches
• Shipping Weight: 2.4 pounds (View shipping rates and policies)
• Average Customer Review: 2.5 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #3,344,821 in Books (See Top 100 in Books)

More About the Author

Denny Lee is a Senior Program Manager Lead based out of Redmond, WA in the SQL Customer Advisory Team (SQLCAT) - DW/BI Group. He has more than 15 years experience as a developer and consultant implementing software solutions to complex OLTP and data warehousing problems. His industry experience includes accounting, human resources, automotive, retail, web analytics, telecommunications, and healthcare. He had helped create the first OLAP Services reporting application in production at Microsoft and is a co-author of "Professional Microsoft PowerPivot for Excel and SharePoint", "Professional Microsoft SQL Server Analysis Services 2008 with MDX", "Professional Microsoft SQL Server 2000 Data Warehousing with Analysis Services" and "Transforming Healthcare through Information [Ed. Joan Ash] (2009)". In addition to contributing to the SQLCAT Blog, SQL Server Best Practices, and SQLCAT.com, you can also review Denny's Blog (http://dennyglee.com). Denny specializes in developing solutions for Enterprise Data Warehousing, Analysis Services, and Data Mining; he also has focuses in the areas of Privacy and Healthcare.

Customer Reviews

Most Helpful Customer Reviews

13 of 14 people found the following review helpful:

1.0 out of 5 stars Step by Step is Better, December 16, 2001

By 

Mark Frank (San Francisco, CA USA) - See all my reviews

This review is from: Professional SQL Server 2000 Data Warehousing with Analysis Services (Paperback)

Been a Wrox fan for some time. This is the worst book their team has produced. The material is cursory at best and totally theoretical. Very few practical examples. Never thought I would point to an MSPress Step-by-Step book, however it is far superior to this junk.

8 of 8 people found the following review helpful:

1.0 out of 5 stars Poorly Written and Confusing, September 4, 2003

By 

S. Yi - See all my reviews
(REAL NAME)   

This review is from: Professional SQL Server 2000 Data Warehousing with Analysis Services (Paperback)

Avoid this book. It was written by ten different people and it shows in the text - overlapping material and total lack of flow make it impossible to get a grasp on Analysis Services. It appears that many of the authors have difficulty understanding and adequately explaining the concepts themselves.

The Analysis Services tutorials included with SQL Server and Books Online are much more informative - with deliberate, well documented hands-on tutorials.

This is NOT the reference you are looking for.

0 of 1 people found the following review helpful:

3.0 out of 5 stars A Light in the Data Mining Tunnel, December 26, 2001

By A Customer

This review is from: Professional SQL Server 2000 Data Warehousing with Analysis Services (Paperback)

I found this book to be helpful in understanding how to utilize multidimensional database design. It was nice to see that Microsoft has some affordable alternatives one can turn to in the data mining and data warehousing market. Once again WROX has produced a helpful product for professionals in the computer industry.