Microsoft SQL Server 2008 Analysis Services Step by Step and over 2 million other books are available for Amazon Kindle . Learn more

Trade in Yours
For a £3.91 Gift Card
Trade in
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading Microsoft SQL Server 2008 Analysis Services Step by Step on your Kindle in under a minute.

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

Microsoft® SQL Server® 2008 Analysis Services Step by Step [Paperback]

Scott Cameron
3.8 out of 5 stars  See all reviews (4 customer reviews)

Available from these sellers.


Amazon Price New from Used from
Kindle Edition £19.88  
Paperback --  
Trade In this Item for up to £3.91
Trade in Microsoft® SQL Server® 2008 Analysis Services Step by Step for an Amazon Gift Card of up to £3.91, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

18 April 2009 0735626200 978-0735626201 1

Teach yourself to use SQL Server 2008 Analysis Services for business intelligence—one step at a time. You'll start by building your understanding of the business intelligence platform enabled by SQL Server and the Microsoft Office System, highlighting the role of Analysis Services. Then, you’ll create a simple multidimensional OLAP cube and progressively add features to help improve, secure, deploy, and maintain an Analysis Services database. You'll explore core Analysis Services 2008 features and capabilities, including dimension, cube, and aggregation design wizards; a new attribute relationship designer; designer AMO warnings; and using dynamic management views to monitor resources. And as you complete each lesson, you can hone your skills using the practice exercises from the companion CD. Plus, you can review and download code samples illustrating the author’s own, professional techniques—direct from the companion Web site.

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

Product details

  • Paperback: 448 pages
  • Publisher: Microsoft Press; 1 edition (18 April 2009)
  • Language: English
  • ISBN-10: 0735626200
  • ISBN-13: 978-0735626201
  • Product Dimensions: 22.6 x 18.5 x 2.8 cm
  • Average Customer Review: 3.8 out of 5 stars  See all reviews (4 customer reviews)
  • Amazon Bestsellers Rank: 411,754 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

Paul Turley, Joe Kasprzak, Scott Cameron, Satoshi Iizuka, and Pablo Guzman are each business intelligence experts who work for Hitachi Consulting.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt
Search inside this book:

Customer Reviews

3.8 out of 5 stars
3.8 out of 5 stars
Most Helpful Customer Reviews
5 of 5 people found the following review helpful
4.0 out of 5 stars Excellent Book 9 Feb 2011
I have to get up to speed fast with Analysis Services and I believe this book delivers. It takes you through Analysis Services literly Step by step with very clear instructions, explanations, and layout. I was also pretty impressed with the lack of typos and silly errors which can make life very difficult if you are a bit dodgy regarding the subject matter.
I didn't give it 5 stars because I would have liked it to use color where appropriate (diagrams anyway) to improve the readability. I also find all the Analysis Services books tend to use the same Database (AdventureWorks) and this doesn't really reflect the real world or at least the Databases I have to work with on a daily basis :). However given the price and the quality of the content I have no hesitation in recommending this book as a buy especially for someone just dipping their toes in the water.
Comment | 
Was this review helpful to you?
4 of 4 people found the following review helpful
4.0 out of 5 stars A good starter book for Analysis Servivces 23 Feb 2011
I enjoyed this book and was able to work through it very quickly. I liked the fact that all the chapters had independent starter projects so you do not have to work through it in chapter order if you do not want to. I would agree with the other review, in that I did not find many errors, it was very clear and easy to understand. There is not much MDX coverage in this book, but the MDX Step By Step book covers that.
Comment | 
Was this review helpful to you?
2.0 out of 5 stars like wading through treacle 29 July 2013
Format:Paperback|Verified Purchase
I've used SSAS and written MDX queries for about a year now. I have a good understanding of SSAS but I bought this book to get a more rounded knowledge rather than just understanding the features that we use at my current role. The problem is, this book is dismal - and I don't say that lightly. Seriously, the explanation of measures and dimensions was hard to follow even though I understand them, and if you don't get these then the rest of SSAS will remain a mystery to you. I don't understand why Microsoft are using an external consultancy to write their SSAS books - it's Microsoft's technology! This is one of those books that you know the author wrote and thought he did a good job, but he never passed the draft to someone else and said "hey, does this make sense?".
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Great introduction to SSAS ! 5 Feb 2013
By Andre
It is very rare for me to read an IT book from cover to cover - I always have great intentions but somewhere along the line I lose interest and go back to the playstation - this is one of the few I have finished.

You'll need a working knowledge of SQL server before using this book but other than that you're good to go.

It doesn't really cover design of Data warehouses so much so you'll need to read this and other books too.

However I have found that I am already doing Cubes at work and after having read this have a very good usable knowledge of SSAS 2008.

The final chapter on performance is pretty weak - but that must be a huge topic.

I'd say if you read this and the data warehouse toolkit you could put OLAP on your CV and not be lying - recommended.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 3.8 out of 5 stars  19 reviews
21 of 22 people found the following review helpful
5.0 out of 5 stars Easy and breezy - excellent introduction to SSAS OLAP 3 Jun 2010
By David Foley - Published on
This is an excellent starter for the OLAP portion of SSAS.

Chapters 1 and 2 provide a great introduction to some of the initially quirky concepts that SSAS uses. (A proper understanding of fundamental things like attribute hierarchies is crucial, especially if you come to SSAS with dangerous baggage from non-MDX-based BI platforms. If this describes you, make sure you understand these 2 chapters implicitly before proceeding).

Each of the following chapters has the same format - a conceptual overview followed by some exercises. The overview pieces are usually short (yet fairly complete, for overviews), very readable and can absolutely stand on their own - in other words, you can return to the material months later and clarify a concept in 60 seconds without having to wade through pages of rambling blather. I find this quite unusual for what is nominally an exercise-oriented book.

Chapters 8 and 10 contain nuggets regarding Scenario Dimensions and Writeback - personally I would really like to have seen the discussion on Planning applications developed a bit further, but it's probably of fairly narrow interest. Chapter 13 contains the best conceptual overview of Aggregation Design that I have yet seen.

If you find SSAS OLAP the most exciting part of the MS BI stack, and want to focus solely within that area, this is the best place to start. It's an easy (and at only 400 pages, quite breezy) read - you won't be a master when you get through it (specifically, MDX), but you will understand all of the major SSAS concepts, and that's an achievement in itself.

Note to SSAS OLAP newbies: Do NOT use the MSFT Books Online to start with. The tutorials there are adequate when it comes to button-pushing, and the technical reference sections are excellent when you have achieved a level of competency ... however, neither addresses the CONCEPTS properly ... start with this book and save yourself 3-6 months of pain!
4 of 4 people found the following review helpful
3.0 out of 5 stars Missing some inportant steps, but otherwise well written 8 Feb 2012
By Jack Stegman - Published on
Format:Paperback|Verified Purchase
I purchased this book to learn SSAS quickly. I already had extensive experience with Sql Server, SSIS, Data Warehousing and building OLAP cubes. The book did a great job of describing and explaining Data Warehousing and dimensional data concepts. I was rather impressed early in the reading. Unfortunately, I found several issues and missing steps. The first and foremost of these was that the sample database does not install properly. I found other places where the step I was on didn't work because an important prerequisite step had been left out. While I still found the book quite helpful, a true novice would find it frustrating and impossible to use.
6 of 7 people found the following review helpful
5.0 out of 5 stars Great book to get you going 19 Nov 2009
By Daniel R. Gleason - Published on
Format:Paperback|Verified Purchase
Excellent step by step setup, configuring, creating, and so forth. Get this book if you need a guided example so you don't waste your time troubleshooting procedures.
4 of 5 people found the following review helpful
5.0 out of 5 stars Excellent book 30 Nov 2009
By SN - Published on
Format:Paperback|Verified Purchase
I bought this book and started building cubes in a very short time frame. I would highly recommend this book to anyone who is new to SSAS 2008.
6 of 8 people found the following review helpful
5.0 out of 5 stars Good value 16 Nov 2009
By Allen Allegretto - Published on
Very useful book. Easier to comprehend than online help. Well organized with detailed explanations. Also includes CD with example databases and projects.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category