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
Average Rating:
Rating: - Good Reference, but Don't Expect Tips and Tricks or even Ideas on Problem Solving
I bought this book because I was facing a few specific problems while implementing Analysis Services. This book did not help much there. As I was reading, I found that this book does have great content on the design of MS-AS2005. It's a great reference book to have handy because it consolidates information in one book and often describes the motivations for certain designs. Likewise, the book never discussed the significant missing feature in the product, nor workarounds to handle some of the ... Read More
Rating: - Get this book if you want to master SSAS
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 ... Read More
Rating: - Avoid
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
Rating: - Best SQL 2005 Business Intelligence book
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 ... Read More
Rating: - Best Book on SSAS 2005 for Professional Consultant
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 ... Read More
- Good Reference, but Don't Expect Tips and Tricks or even Ideas on Problem Solving
- Get this book if you want to master SSAS
- Avoid
