Learn How to Do-It-Yourself!
  Search:       

Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer)

by Sivakumar Harinath, Stephen R. Quinn

List Price:$49.99
Amazon Price:$31.49 & eligible for FREE Super Saver Shipping on orders over $25.
You Save:$18.50 (37%)
Average Rating:3.5 out of 5 stars
Lowest New Price:$23.93
Availablitiy:Usually ships in 24 hours

Buy Now!


Editorial Reviews
Product Description
  • Written by the lead developers of Analysis Services at Microsoft, this book begins with an overview showing how Analysis Services and MDX can be used to build data warehouses and multidimensional databases
  • The authors then describe the development processes for building dimensions and cubes from various data sources
  • Demonstrating a variety of techniques in real-world scenarios, the book shows how MDX can be used to query databases to provide sophisticated analysis of business problems
  • Finally, the book explains how Analysis Services can be used with other components of SQL Server, including DTS, data mining, and Report Services, to provide comprehensive, end-to-end solutions



All Customer Reviews
Average Customer Review:3.5 out of 5 stars
1 of 1 people found the following review helpful:

1 out of 5 starsGood Cop / Bad Cop, 2008-04-18
Half of the chapters in this book are well planned and very readable. But the other half are just terrible. There are two authors of this book, so it's clear what is behind this. The "bad" chapters are loaded with bad grammar, technical errors and explanations that just don't make sense. This would be bad enough, but the larger problem is that there is no overall planning to these chapters, with illogical jumps between topics and a lack of any conceptual flow. I've been reading technical books for over 25 years, and this is without a doubt the poorest offering I've ever seen published. You can gain some value from the book from the "good" chapters, but the other chapters are so frustrating that I recommend avoiding this book altogether. If you need to ramp up on 2005 Analysis Services, the Microsoft Press Step-by-Step book is a much better choice.


3 of 3 people found the following review helpful:

5 out of 5 starsExcellent tutorial on SSAS 2005, 2007-12-23
I am a DBA, and bought this book hoping to learn quickly basics of implementing SSAS project. This book exceeded all my expectations. I would call it a practical tutorial on implementation with explanation of all aspects behind SSAS: basic theory, technologies, tools, security, connectivity. Not only it gives you hands-on approach to learning with 99.9% precision in samples, but also explains usage of Microsoft SQL Server 2005's related technologies: Integrated Services, Reporting Services.
The scope of presenation is also very much oriented on practical needs of SSAS utilization.
In short, I am 110% satisfied on my expectations for this book.

Vladimir Kievsky


10 of 10 people found the following review helpful:

2 out of 5 starsWhat a mess, 2007-03-18
I do not understand why this book gets such high ratings by other readers. I found this book a real mess. My concise evaluation of "Professional SQL Server Analysis Services 2005 with MDX":
· general: bad as a tutorial, but it might serve as a good reference,
· incorrect code: see below,
· incorrect references to other chapters,
· extremely inconsistent use of names of the cube, tables, dimensions, measures, etc., which makes the learning process more like a puzzle,
· subjects, details are scattered over many chapters (which has some advantages as well), but complicates the learning process.

In chapter 3 of this book it starts with code samples, that are incorrect in almost any sense. Not really being a novice, but having my first experience with SSAS (that is: the 2005 version, I had some experience with the 2000 predecessor), I was blaming my ignorance. I could better do not: I simply had to correct about every code sample.
I made a long list of errata, that I have sent to Wiley/Wrox on January 9, 2007. These errata are very detailed and specific, but I do not find the results in the list of errata of this book on the Wiley or Wrox site. They simply did not process my errata.
So, I finally bought "Microsoft SQL Server 2005 Analysis Services" by Melomed, et.al. (Sams, 2007). My first impression: very good, indeed. I just have it for two days now, so my review will take a few more months.
Leendert.


2 of 2 people found the following review helpful:

3 out of 5 starsGreat book if you can get past the poor grammar, 2007-02-20
After reading the previous reviews of this book, I think my expectations may have to been to high. Overall the book is good, but I feel like it could have been more in-depth in numerous areas. I still find myself searching MSDN with help on topics. My main fault with the book was that I constantly had to read sentences over-and-over again due to extremely poor grammer.




21 of 23 people found the following review helpful:

5 out of 5 starsGreat Book, 2006-08-31
I needed to know quickly how to implement a BI solution and ordered three books: Delivering Business Intelligence with Microsoft SQL Server 2005 by Brian Larsen, Applied Microsoft Analysis Services by Teo Lachev, and this book. Of the tree books, this is the only one I really needed. This book had everything I wanted to know about Analysis Services. I was also impressed with the knowledge and information regarding how to design dimensions and cubes especially when it comes to tough situations such as how to apply security. If you need to implement a BI solution, I highly recommend this book.




Price is accurate as of the date/time indicated. Prices and product availability are subject to change. Any price displayed on the Amazon website at the time of purchase will govern the sale of this product.
Related Products