Microsoft SQL Server 2008 Analysis Services Step by Step
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.
CONTENTS:
Acknowledgments
Introduction
Part I: Understanding Business Intelligence and Analysis Services
- Chapter 1: Business Intelligence: A Data Analysis Foundation
- Chapter 2: Understanding OLAP and Analysis Services
- Chapter 3: Accessing Source DataPart II: Design Fundamentals
- Chapter 4: Creating Dimensions
- Chapter 5: Creating a Cube
- Chapter 6: Creating Advanced Measures and Calculations
- Chapter 7: Advanced Dimension DesignPart III: Advanced Design
- Chapter 8: Working with Account Intelligence
- Chapter 9: Currency Conversion and Multiple Languages
- Chapter 10: Interacting with a Cube
- Chapter 11: Retrieving Data from Analysis Services
- Chapter 12: Implementing Security
- Chapter 13: Designing AggregationsPart IV: Production Management
- Chapter 14: Managing Partitions and Database Processing
- Chapter 15: Managing Deployment
- Chapter 16: Advanced Monitoring and Management ToolsAppendix : About the Author