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 2000 Analysis Services Step by Step [Paperback]

Microsoft Corporation
3.9 out of 5 stars  See all reviews (21 customer reviews)

Available from these sellers.

Save Up to 90% on Textbooks
Hit the books in Amazon.ca's Textbook Store and save up to 90% on used textbooks and 35% on new textbooks. Learn more.
Join Amazon Student in Canada

Book Description

Sept. 6 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.

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

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.

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
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?
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?
4.0 out of 5 stars Good for getting started with Analysis Services April 18 2001
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.
Was this review helpful to you?
3.0 out of 5 stars Analysis Services Dec 6 2000
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.
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?
Most recent customer reviews
3.0 out of 5 stars Some examples doesn't work...
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. Read more
Published on May 25 2004 by Mauricio Leyzaola
5.0 out of 5 stars Delivers well written and concise basics
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... Read more
Published on March 1 2004 by T. Mccobb
1.0 out of 5 stars Lacks the Details
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. Read more
Published on March 21 2003 by Bob
4.0 out of 5 stars Great Intro to OLAP using SQL Server 2000/Analysis Services
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... Read more
Published on Oct. 23 2002 by Benjamin S. Prusinski
4.0 out of 5 stars Good for getting start OLAP
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... Read more
Published on Sept. 19 2002 by Xidong Zhang
4.0 out of 5 stars Good for beginners. Doesn't go into depth.
This is a good book that will help you get started on Microsoft's SQL Server Analysis Services.
You'll get to learn how to build a Cube, build a Dimension and the different... Read more
Published on May 15 2002 by Kimon Andreou
4.0 out of 5 stars Good Book - but MDX is very weak
The good thing about this book is the CD. However, the author did not do a good job on MDX section. It made me very confusing.
Published on April 23 2002
5.0 out of 5 stars NEAT BOOK!
This author is able to explain complex ideas simply. Everything works! Not only is this author knowledgeable, the text reflects actual experience in using Analysis Services to do... Read more
Published on Feb. 1 2002 by E. A. BABB
2.0 out of 5 stars Not what it needs to be
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. Read more
Published on Nov. 11 2001
5.0 out of 5 stars Very well done
This book does an excellent job of covering the important aspects of datawarehousing and walks you through analysis services in a clear and sensable way. Read more
Published on May 29 2001
Search Customer Reviews
Only search this product's reviews

Look for similar items by category