Buy Used
+ £2.80 UK delivery
Used: Very Good | Details
Condition: Used: Very Good
Comment: Expedited shipping available on this book. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Microsoft® SQL Server(TM) 2000 Analysis Services Step by Step Paperback – 10 Oct 2000

See all formats and editions Hide other formats and editions
Amazon Price New from Used from
"Please retry"
£8.77 £0.01

Product details

  • Paperback: 400 pages
  • Publisher: Microsoft Press; 1 edition (10 Oct. 2000)
  • Language: English
  • ISBN-10: 0735609047
  • ISBN-13: 978-0735609044
  • Product Dimensions: 18.7 x 3.1 x 23.5 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 1,962,193 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

About the Author

OLAP Train is a curriculum-development company that specializes in OLAP and related data-warehousing technologies. Microsoft licenses OLAP Train's courseware for Microsoft SQL Server 2000 worldwide as Microsoft Official Curriculum titles.

Reed Jacobson is a senior architect in Hitachi Consulting’s Business Intelligence practice. He has authored several training courses and books, including Microsoft SQL Server 2000 Analysis Services Step by Step.

Inside This Book (Learn More)
First Sentence
Suppose that you are the president of a small, new company. Read the first page
Explore More
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

5.0 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See both customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

27 of 34 people found the following review helpful By MR PAUL A HOLMES on 17 April 2001
Format: Paperback
Originally an orange spine on a Microsoft book meant 'serious' - Inside SQL Server for example got right under the skin of the RDBMS.
It now looks like Microsoft Press have realised that orange is simply a colour that will stand out amongst the myriad of other books on the shelf. And I'm pleased it does.
Jacobson's book might start at the very beginning (it is, after all, subtitled Step by Step) but keeps up a manageable but swift pace, heading off into Office and Web Integration, MDX et al.
There's no doubt it could go further, but that's probably for another book. This gets you along way down the line, in only a matter of days. Not only that, but it has some good tips on things to avoid and some of the (few) limitations of the product.
I'm now about to deliver a project in half time I expected. Now all I want is the hardcore 'Inside.' guide... :-)
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
12 of 18 people found the following review helpful By A Customer on 22 Feb. 2001
Format: Paperback
Step by step - Microsoft SQL Server 2000 Analysis Services is an excellent guide to the wonderful world of OLAP technology. This book is highly recommendable for everyone starting to work with Analysis Services.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Helpful Customer Reviews on (beta) 26 reviews
28 of 29 people found the following review helpful
Good for getting started with Analysis Services 18 April 2001
By Douglas Welzel - Published on
Format: Paperback
This Step by Step guide serves as a great starting point for getting familiar with Microsoft's Analysis services. It starts with a quick introduction to data warehousing (without resorting to giving an entire history of the subject, as seems so common today) and how it relates to OLAP and then moves right into the Analysis Servies tools.
The chapters are well written and get you the information you need, without missing any major details. Even if you don't plan to take the "step by step" approach, this book is worth having by your side.
All right... now for the downsides. At best this book is good for beginners. These are some of the areas where I found it came up short:
- Sizing systems that will support Analysis Services. The book talks a bit about how big cubes are, but there is no information about cube performance/cube sizing, etc. Basically, this book won't help you develop a hardware plan for hosting Analysis Services.
- Accessing Analysis Services via the web. All of Microsoft's literature talks about how SQL Server 2000's great support for the web/XML. Strangely, it is very hard to find this information for Analysis Services, and this book doesn't provide any guidance. Right now it seems that the best you can do to find this information is hunt around Microsoft's site.
Overall I still think this is good book. However, if you are going to be building a large Analysis Services system, expect to be looking for other sources to answer all of your questions.
16 of 16 people found the following review helpful
Analysis Services 6 Dec. 2000
By "johnr98798" - Published on
Format: Paperback
This book is very basic and should provide a good foundation for those people who are not familiar with SQL 7's OLAP or the newer implementation called 'analysis services'.
It is easy to read, the examples on the cd work perfectly and the tutorials provide a good overview of how to create your own cubes.
It's pretty thin and after reading through the first few chapters I found myself putting it down and just diving into designing my own stuff with microsoft's interface. It's a very logical application and with little or no resource materials people could easily figure this out with the tutorials included with the software.
This is not a good reference book, though I'm at a loss as to what would be a decent reference book on this subject since it's one of those things you either know or you don't.
MDX is VERY thin, and since you can teach the basics to yourself, a reference/primer book on MDX may suit you better.
12 of 12 people found the following review helpful
Not what it needs to be 11 Nov. 2001
By A Customer - Published on
Format: Paperback
This book shows some basic examples by mousing through the menus with a pre-cooked script, but the on-line tutorial does about the same thing. However, there are no explanations why one would select one option over another, no explanations about how to construct different cubes to solve problems and no explanations about the syntax of Analysis services. There is no overriding theory presented that allows one to gain an understanding about how to frame and solve problems using Analysis services nor about what kinds of problems can and can't be solved. After reading the book I have a high level understanding about potentially what can be done, but I have not gained enough information to build anything useful.
9 of 9 people found the following review helpful
Delivers well written and concise basics 1 Mar. 2004
By T. Mccobb - Published on
Format: Paperback
Not only is this book useful, it has the added advantage of being well written. I picked it up after spending a few days wandering around in Books On Line and reading Erik Thomsen's book for some theoretical background. This book was a great help to bringing all the various aspect of OLAP objects together in the specific context of MS Analysis Services.
After I purchased the book I noticed the one-star reviews given by two readers. They did not do anyone any favors with those reviews. One reviewer admits he did not read beyond the first chapter, and the other complains that custom rollups and unary operators are never mentioned in the book. Apparently he never got to page 105, where both are discussed. I think you are safe to ignore those jokers.
Enjoy 'Step by Step' for what it is. If you want more on MDX, be prepared to buy another book - I recommend Spofford.
8 of 8 people found the following review helpful
A really great book 6 Nov. 2000
By A Customer - Published on
Format: Paperback
A really great book for someone wanting to come to grips with the SQL Server OLAP or Analysis Services. The book takes one through the processes of creating cubes and reporting from them, in a step by step, orderly manner. The book was recommended by several attendees at the recent PASS conference in San Francisco. I bought the book and installed the analytic services on an NT server and have been working with it for the past 10 days. The reading is easy and helps one come up to speed in an efficient and effective manner. For a beginner or some one with some OLAP product training, the book is really great.
Were these reviews helpful? Let us know