Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

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.

Subscriber Reviews

Average Rating: 4.833333333333333 out of 5 rating Based on 6 Ratings

"Great introduction" - by Andy Russell on 05-FEB-2013
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
One of the few IT books I have read from cover to cover. I am quite new to SSAS and as an introduction this is superb - already using it at work. The chapter on performance , the last chapter, is very weak but apart from that it's superb. It's written using the original release of SQL2008 but all the steps work 99.9% of the time with R2 as well. Recommended !
Report as Inappropriate

"Excellent Book" - by ETL vs ELTL on 07-MAY-2011
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating

Cameron did a very well job. Thanks Cameron. I'm MSBI developer and doing many think without knowing their significance in SSAS but after reading this book I come to know more about the SSAS tool and terminology.

Report as Inappropriate

"Good book but not consistent with samples" - by SolutionsGuy on 15-MAR-2010
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
I have been using this book for the last couple weeks.  I think it reads great, and the examples are well explained and easy to follow.  I know so much more about building SSAS solutions in such a short time.

The only drawback I have found is the inconsistent references to some sample data (SSAS2008SBS.ds).  For example, when creating a Date dimension the book references the "Month" column, which does not physically exist.  During the modification of the Date dimension, again, NameColumns that do not physically exist are referenced.

These are small things but they can throw you off if you are a newbie like me.  Other than that, once I can get pass my errors I am sure the rest of the book will be very enlightening.

Report as Inappropriate

Table of Contents

 Index

Extras

The publisher has provided additional content related to this title.


Description
Content

Visit the catalog page for Microsoft® SQL Server® 2008 Analysis Services Step by Step

  • Catalog Page

Visit the errata page for Microsoft® SQL Server® 2008 Analysis Services Step by Step

  • Errata

Download the supplemental electronic content for Microsoft® SQL Server® 2008 Analysis Services Step by Step

  • Supplemental Content