- Series: DV-DLT Fundamentals
- Paperback: 400 pages
- Publisher: Microsoft Press (October 7, 2000)
- Language: English
- ISBN-10: 0735609047
- ISBN-13: 978-0735609044
- Product Dimensions: 7.4 x 1.2 x 9.2 inches
- Shipping Weight: 1.8 pounds
- Average Customer Review: 26 customer reviews
- Amazon Best Sellers Rank: #5,167,206 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Microsoft® SQL Server 2000 Analysis Services Step by Step (DV-DLT Fundamentals)
Use the Amazon App to scan ISBNs and compare prices.
There is a newer edition of this item:
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
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.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
Even though this is an introductory book, it is aimed squarely at IT and database professionals.
In this well thought out and perfectly executed training guide, Jacobson does three things: a) he reviews in concise fashion the various OLAP and administrative operations provided by Analysis Services, b) more importantly, he explains to you why you would be interested in them, and c) most important, he shows you in exquisite detail how to perform the operations.
I was very impressed by the fact that the hands-on instructions are very clear and that the all the samples worked perfectly.
After you finish Jacobson's book, you come away knowing the basics of OLAP and you will be comfortable performing basic tasks in the Analysis Services product. You will have a very thorough grounding in Analysis Services so that you can probe deeper into the more advanced topics of Analysis Services.
The coverage in this book is broad and so doesn't go into great depth in some areas, such as MDX. However, Jacobson does go into some depth in the administrative areas of Cube optimization and Cube security.
best suits me. Would highly recommend this book to anyone who does data analysis for systems with SQL Server
as the backend.
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.
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.
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.
Most recent customer reviews
1. You are not going to learn more from this book than from the books on line included with sql server 2000.