Microsoft® SQL Server® 2008 Analysis Services Step by Step (Step by Step Developer) 1st edition by Cameron, Scott (2009) Paperback

by Scott Cameron

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.

Paperback

First published April 8, 2009

Reviews

[Cait · Rating 2 out of 5]

This book drove me nuts. What I wanted was a technically-minded overview of SSAS; what I got was a mash-up of management-level metaphors and step-by-step walkthroughs of the IDE for building cubes.

...Which, to be fair, is probably what I should have expected, at least in the second part. It may be that this is a perfectly enlightening book for people who aren't already DBAs. (I'll keep it around in case it comes in handy as a tutorial someday.) For others out there who are DBAs, at the moment I'd recommend the book I picked up when I gave up on this one -- it's twice as long but more than twice as engaging, and unlike this "Step by Step" book is written so that familiar sections can be easily skimmed.