SQL Server 2005 Analysis Services Step by Step

Description

Teach yourself the fundamentals of SQL Server Analysis Services - one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to build flexible and powerful solutions that meet the analytical needs of your organization.

Discover how to:

* Start building cubes using the Microsoft Visual Studio 2005 Business Intelligence designers
* Create dimensions and measure groups to build, browse, and modify OLAP cubes
* Design objects to handle unique financial analysis requirements
* Improve query performance with aggregations and user hierarchies
* Customize cubes with multi-dimensional expressions (MDX) and other advanced design techniques
* Use actions to integrate Web pages, reporting applications, and drillthrough capabilities with cubes
* Manage role-based security and restrict data access
* Deploy and maintain a database in a production environment

CD features

* All practice exercises and answer files
* Fully searchable eBook

CONTENTS:

IntroductionPart I: Getting Started with Analysis Services
* Chapter 1: Understanding Business Intelligence and Data Warehousing
* Chapter 2: Understanding OLAP and Analysis Services
* Chapter 3: Building Your First CubePart II: Design Fundamentals
* Chapter 4: Designing Dimensions
* Chapter 5: Designing Measure Groups and Measures
* Chapter 6: Working with a Finance Measure Group
* Chapter 7: Designing Aggregations and HierarchiesPart III: Advanced Design
* Chapter 8: Using MDX
* Chapter 9: Exploring Special Features
* Chapter 10: Interacting with CubesPart IV: Production Management
* Chapter 11: Implementing Security
* Chapter 12: Managing Partitions and Database Processing
* Chapter 13: Managing DeploymentGlossaryAppendix : About the Authors