|
Microsoft SQL Server 2005 Analysis Services (SQL Server Series) | 
 enlarge | Authors: Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman
Publisher: Sams
Category: Book
List Price: $59.99
Buy New: $33.58
You Save: $26.41 (44%)
New (35) Used (9) from $33.58
Avg. Customer Rating:  16 reviews
Sales Rank: 64613
Media: Paperback
Edition: 1
Number Of Items: 1
Pages: 864
Shipping Weight (lbs): 2.8
Dimensions (in): 9.1 x 7 x 2.1
ISBN: 0672327821
Dewey Decimal Number: 005
EAN: 9780672327827
ASIN: 0672327821
Publication Date: December 25, 2006
Availability: Usually ships in 1-2 business days
Condition: All orders ship same business day via standard shipping (USPS Media Mail) if received by 1 PM CST.
|
| Also Available In:
|
| Similar Items:
|
| Editorial Reviews:
Product Description
Microsoft SQL Server Analysis Services provides fast access to data by means of multidimensional data structures and the multidimensional query languag MDX. Analysis Services provides the capability to design, create, and manage multidimensional cubes based on data warehouse tables, and it serves as the foundation for the Microsoft Business Intelligence strategy. Microsoft SQL Server 2005 Analysis Services gives the reader insight into the way Analysis Services functions. It not only explains ways to design and create multidimensional objects, databases, dimensions, and cubes, but also provides invaluable information about the reasons behind design decisions made by the development team. Here's what you will find inside: - Understand the key concepts of multidimensional modeling
- Explore the multidimensional object model and its definition language
- Learn the main concepts of the MDX language and gain an in-depth understanding of advanced MDX concepts
- Understand the mechanisms of integrating multidimensional and relational databases
- Learn how to build client applications to access data in Analysis Services
- Examine server architecture, including main data structures, data processing, and query resolution algorithms
- Gain a deep understanding of the internal and external protocols for data transfer, including the XML/A protocol
- Explore how Analysis Services manages memory
- Explore the security model, including role-based security, code-access security, and data security
- Discover how to monitor and manage Analysis Services
All the code for the sample database used in the book can be found at www.informit.com/title/0672327821.
|
| Customer Reviews: Read 11 more reviews...
 Get this book if you want to master SSAS June 15, 2008
I came from the world of Hyperion Essbase and decided to switch to Microsoft SQL Server Analysis services. The SQL server books online seemed to be lacking in some details (or examples) and other SSAS printed books seem to be more of the beginner level books or step by step tutorial books. They are good to start with but not deep enough. If you are just starting in the BI and OLAP world, get those books first.
This book is not a general BI book and is more specific to SSAS details. Because of my prior understanding of of data warehousing and OLAP, I was able to build SSAS cubes in no time but there were some lingering questions on how do I do this in SSAS (compared to doing it in Essbase) and other low level details. This is the only SSAS book that I found so far that goes into enough details of SSAS that no other book goes into.
If you are just starting with Microsoft BI and need to learn the concepts of data warehousing (star and snowflake schema), OLAP, ETL and SSIS, get one of the other books first. Then do the SSAS books online tutorials. Once you are ready to dig deeper into SSAS and build enterprise class analysis services cubes, this book would be a great help.
Here is a quote from Nigel Pendse of The OLAP Report in the foreword of this book:
"This book is not intended to teach new users how to use Analysis Services 2005; it is for technically competent implementers who want to make the most of Analysis Services by understanding how it really works..."
 Avoid May 24, 2008
0 out of 1 found this review helpful
If you must, avoid this book. Looks like they threw in all chapters in a bin and did a pot luck. No flow whatsoever. Only good for quick lookup. But then you have MSDN. I am utterly dissappointed
Best SQL 2005 Business Intelligence book April 15, 2008
1 out of 1 found this review helpful
I have read 3 SQL 2005 Business Intelligence books and this one is the best by far. For one, it provides a working sample SQL 2005 Business Intelligence Project Solution. This solution is a predesigned HOLAP. The OLTP database is also provided.
The level of expertise of the authors is very high. They go into granular detail on the architecture of the SQL 2005 BI (but not as much as I have liked). They also go into details on how one can improve the performance of SQL 2005 BI. Administration and security features are also covered. It was little weak on ETL (SSIS) but that topic has few thick books of its own.
SQL 2005 Business Intelligence is very different (conceptually and architecturally) from its SQL 2005 OLTP counterpart. It is not an exaggeration to say they are completely different products integrated into one. If you have no previous BI background, then expect a steep learning curve.
I highy recommend this book for anyone who is interested in learning SQL 2005 BI.
Here are the contents:
1)Introduction
2)Creating Multidimensional Models
3)Using MDX
4)Creating Data Warehouse
5)Bringing Data into Analysis Services
6)Analysis Server Architecture
7)Accessing Data in Analysis Services
8)Security
9)Management
Best Book on SSAS 2005 for Professional Consultant April 9, 2008
2 out of 2 found this review helpful
As a professional consultant for microsoft, I know what a good book on SSAS look like and this book is a great book compared to many other ones. I want in depth coverage for the saavy professional so I bought it and read it cover to cover. I used this as a reference guide when I'm stuck on some design issues. This book has helped me delivered many projects for large customers.
I wish we have a new version for SSAS 2008 !!! (the author informed me that he's considering it !!! and this is great news).
 In depth but a difficult read December 19, 2007
4 out of 4 found this review helpful
I agree with a previous reviewer that you should not use this book to learn Analysis Services. Read another book for that, then come to this book if you need a more in depth theoretical understanding of the product.
However I have to emphasize that the book is a very difficult read. I don't know how to say it better than that - it requires intense concentration to try and read through it and understand, and even then it's not easy. I would have preferred more clear examples that explained what they're talking about.
I can't recommend this book simply due to the difficulty of reading it. It should have been written in a more accessible, clearer way. I believe only the most determined readers will complete the book.
Again it does have some excellent in depth information on the product and why it was designed as it was, and gives a different perspective on everything which is indeed valuable - it's just hard to read, which in my opinion is a huge flaw.
|
|
|
Copyright 2008 - RailroadBookstore.com
| |
