THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Denis Gobo

Which SQL Server 2005 Analysis Services Book Should I Get?

Who can recommend a good SQL Server 2005 Analysis Services book?


I know SQL Server 2000 Analysis Services but did not work with SQL Server 2005 Analysis Services yet. As a matter of fact I haven’t touched Analysis Services in 2 years. I don’t need a book which explains what a start or join schema is, I know what a slowly changing dimension is, I also know the difference between a fact table, a dimension table and MOLAP/ROLAP/HOLAP.


The 2 books that I used previously are the WROX book (Professional SQL Server 2000 Data Warehousing with Analysis Services) and the MS Press Step by Step book. I remember liking both of them, are their successors as good?

The problem with the reviews on Amazon is that it doesn’t match my expectations; the WROX 2000 book only got 2.5 stars which I think is way too low. While the book is not perfect it deserves more than 2.5 stars.



Here are the 5 books I am considering


Microsoft SQL Server(TM) 2005 Analysis Services Step by Step


Delivering Business Intelligence with Microsoft SQL Server 2005


Professional SQL Server Analysis Services 2005 with MDX


Microsoft SQL Server 2005 Analysis Services


The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset



BTW I don’t need the book right now, I won’t actually start working with this until next year. If you know of a book that is coming out between now and January please let me know also.

Published Monday, June 18, 2007 10:40 AM by Denis Gobo



Adam Machanic said:

June 18, 2007 10:34 AM

Denis Gobo said:


Thanks,  I'll check it out

June 18, 2007 10:39 AM

James Luetkehoelter said:

I agree 100% with Adam - that's the best one out there in my opinion. It is very dense though - Teo packs a lot of information in those pages :)

June 18, 2007 11:39 AM

Bob Sullivan said:

I would have to agree with Adam's recommendation. i would also like to state that the author is very good at responding through the books forum site.

June 25, 2007 8:14 AM

Beth Ludwig said:

I find I use Wrox "Professional SQL Server Analysis Services 2005 with MDX" much more often than "Microsoft SQL Server 2005 Analysis Sevices" by Melomed et al.  I think it's easier to read & understand and I'm also more of a beginner.

June 25, 2007 10:37 AM

G D Milner said:

I like Teo Lachev's book, too -- Adam's choice. If you are going to work with ETL at all (i.e., if you are making a data warehouse), then I would consider the "The Microsoft Data Warehouse Toolkit" Kimball book absolutely essential to cover the crucial planning phases. It will save you months of do-over work. I have both and use both.


June 26, 2007 5:42 PM

Denis Gobo said:

Just ordered the book Adam has recommended

January 30, 2008 4:43 PM

uli said:

November 6, 2011 3:22 AM
New Comments to this post are disabled

About Denis Gobo

I was born in Croatia in 1970, when I was one I moved to Amsterdam (and yes Ajax is THE team in Holland) and finally in 1993 I came to the US. I have lived in New York City for a bunch of years and currently live in Princeton, New Jersey with my wife and 3 kids. I work for Dow Jones as a Database architect in the indexes department, one drawback: since our data goes back all the way to May 1896 I cannot use smalldates ;-( I have been working with SQL server since version 6.5 and compared to all the other bloggers here I am a n00b. Some of you might know me from or even from some of the newsgroups where I go by the name Denis the SQL Menace If you are a Tek-Tips user then you might know me by the name SQLDenis, I am one of the guys answering SQL Questions in the SQL Programming forum.

This Blog


Privacy Statement