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.

Microsoft® SQL Server(TM) 2000 Analysis Services Step by Step [Paperback]

Reed Jacobson , OLAP Train , Reed Jacobsen
3.9 out of 5 stars  See all reviews (21 customer reviews)

Available from these sellers.

Join Amazon Student in Canada

Book Description

Oct. 10 2000 0735609047 978-0735609044 1

MICROSOFT® SQL SERVER™ 2000 ANALYSIS SERVICES STEP BY STEP shows Microsoft Excel and Access experts, IS managers, and database developers how to build applications that take advantage of the powerful data-analysis services in Microsoft SQL Server 2000. You’ll discover why these services make it easier to analyze huge amounts of data quickly, and you’ll learn how to develop a wide range of advanced dimensional-data applications—from enterprise reporting tools to advanced decision-support systems. The book’s easy-to-follow lessons begin with clear objectives and include real-world business examples, with a companion CD full of sample files that support each lesson.

This title shows you how to:

  • Administer the Analysis Manager: Understand the fundamentals behind data dimensions and hierarchies, data warehousing, and the Microsoft Analysis Services architecture, and use the Microsoft Analysis Manager application to define and populate data cubes.

  • Create and display cubes: Define and modify measures and dimensions. Design, build, process, and view cubes, from simple to advanced, with cube and dimension editors. Use Microsoft Excel PivotTable® Reports and the PivotTable List in Microsoft Excel to browse cubes, and create cubes using Microsoft Office.

  • Query cubes: Use multidimensional expressions (MDX) values and sets and the MDX Sample application to query and display dimensional data.
  • Perform advanced administration: Choose data storage options and the Storage Design Wizard to optimize, manage, and update data efficiently. Automate the Analysis server to process an OLAP database. Work with partitions and automate updates, and apply security to cubes.

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

Product Details

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:

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

Most helpful customer reviews
3.0 out of 5 stars Some examples doesn't work... May 25 2004
I will say this breifly:
1. You are not going to learn more from this book than from the books on line included with sql server 2000.
2. The fact that the example of writing a cube from Excel didn't work makes me feel complete frustration. It was the reason why i bought this book.
However the book is not bad if you are new to olap technics. It is a good introduction.
Was this review helpful to you?
5.0 out of 5 stars Delivers well written and concise basics March 1 2004
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.
Was this review helpful to you?
1.0 out of 5 stars Wasn't useful - save your money Aug. 1 2003
By A Customer
I bought the book hoping to get a good start on learning Analysis Services. Chapter one gives a decent overview of terms and definitions for a beginner - but I know there are probably alternate places on the web to find this same information.
Then I reached chapter two and couldn't believe what I saw. It was the same exact tutorial I had just done in SQL Server Analysis Services. Yes, when you install Analysis Services there is a tutorial section in the application. I had only completed the first tutorial section and then went to buy this book.
I can only imagine the rest of the chapters in the book are the remaining tutorials in the application. Even the description on the back of the book almost matches the titles in the application tutorial.
Of course, I won't waste my time checking, but I feel pretty confident the tutorial and the book are pretty identical. Just from flipping through that 2nd chapter I could see they used the same exact screen shots, the same instructions, etc.
I plan to return the book and just go through the remaining tutorials.
Was this review helpful to you?
1.0 out of 5 stars Lacks the Details March 21 2003
By Bob
The book skims over Analysis Services. Case in point: Nowhere in the book does it cover the unary operators and/or how to apply them to create custom rollups. Actually the term "custom rollup" is not even mentioned in the book (though it is a key term for Analysis Services).
Knowing what I know now, I wish I'd saved my money.
Was this review helpful to you?
5.0 out of 5 stars Training, Most Excellent...Dude Feb. 24 2003
You would probably pay thousands of dollars for the level of training that Jacobson's book on Analysis Services provides.
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.
Was this review helpful to you?
After digging thru most SQL Server DBA books without finding much if any coverage of how to build an OLAP solution for Data Warehousing I found this text to be perfect for my transition to building my MOLAP data warehouse with SQL Server 2000 from Oracle data warehousing. Granted the book is not perfect but where else can you learn how Analysis Services 2000 and building an OLAP solution on MS SQL Server? The only other texts that even cover it are the MS SQL Server 2000 Resource Kit (also quite good book too with great tools on CDROM) and the MS SQL Server 2000 Reference Library (another must have for hardcore DBAs like me). You will be up and running a starter OLAP solution in no time flat.
Was this review helpful to you?
4.0 out of 5 stars Good for getting start OLAP Sept. 19 2002
It a great book for OLAP. According to Microsoft Analysis Services, it should include Data Mining. It would be perfect and I would give five stars if it includes the content of data mining.
Was this review helpful to you?
3.0 out of 5 stars Basic introduction May 22 2002
I was trying to sum it up for myself. I am in agreement with other reviewers, and borrow some of their words.
This book is very basic, and functions as a complete beginner's introduction.
It is easy to read, the examples on the cd work fine, and the tutorials provide a good overview of how to create your own cubes. Then again, so do the product tutorials.
It's pretty thin and after reading through the first few chapters I found myself putting it down. I already had dealt with the first version of the product, maybe that makes me not a good reviewer. But I don't think it will make a beginner more than a well-informed beginner. If you read it once or twice, you may never read it again.
It is not a good reference book. In fact, it occasionally presents simplifications that are inaccurate.
MDX is VERY thin, and since you can teach the basics to yourself, a reference/primer book on MDX may suit you better.
Was this review helpful to you?
Want to see more reviews on this item?

Look for similar items by category