Vous voulez voir cette page en français ? Cliquez ici.

Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

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

Sakhr Youness , Chris Graves , Terrence Joubert
2.2 out of 5 stars  See all reviews (5 customer reviews)

Available from these sellers.

Join Amazon Student in Canada

Book Description

October 2001 1861005407 978-1861005403 illustrated edition
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

Special Offers and Product Promotions

  • Join Amazon Student in Canada

Product Details

Product Description

From the Publisher

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

Christopher Graves is President of RapidCF, a ColdFusion development company in Canton Connecticut. 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.

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.

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Customer Reviews

2.2 out of 5 stars
2.2 out of 5 stars
Most helpful customer reviews
1.0 out of 5 stars Big "professional" disappointment Dec 2 2001
By tlachev
I tried really hard to find anything positive to say about this book...but alas. Being a Wrox fun for a few years, I was greatly disappointed by this book. Don't be misled by the "Professional" word in its title. You won't find anything "professional" in it. It doesn't even succeed in giving you a good panoramic view of the SQL Server Analysis Services. Example, try to find some information about LookupCube - forget it. The authors seem to be completely out of sync with each other. At some point, the book says that the private dimensions have no advantages over shared dimensions. Later it says that private dimensions preserve shared memory because the shared dimensions are cached.
I highly recommend the "Step by Step" book or "Professional SQL Server 2000 DTS" if you want to learn something of value about data warehousing with Analysis Services.
Was this review helpful to you?
1.0 out of 5 stars Poorly Written and Confusing Sept. 4 2003
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.
Was this review helpful to you?
5.0 out of 5 stars Better than the last book! Jan. 7 2002
I bought Sakhrs version of this book for SQL Server 7. This is not just an upgrade but a look at the new functionlity found within SQL Server 2000.
This book is a dream if you are involved within Analysis and even looking at the new DTS Analysis functions has helped me.
Comparing this with other books, by far this is the one that is well written and doesnt just come out with the obvious.
Was this review helpful to you?
3.0 out of 5 stars A Light in the Data Mining Tunnel Dec 26 2001
By A Customer
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.
Was this review helpful to you?
1.0 out of 5 stars Step by Step is Better Dec 16 2001
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.
Was this review helpful to you?
Want to see more reviews on this item?
Search Customer Reviews
Only search this product's reviews

Look for similar items by category