Synopses & Reviews
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.
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
About the Author
Paul Turley, Joe Kasprzak, Scott Cameron, Satoshi Iizuka, and Pablo Guzman are each business intelligence experts who work for Hitachi Consulting.
Table of Contents
Acknowledgments; Introduction; Finding Your Best Starting Point in This Book; Conventions and Features in This Book; Hardware and Software Requirements; Practice Files and SQL Server 2008 Configuration; Find Additional Content Online; Support for This Book; Part I: Understanding Business Intelligence and Analysis Services; Chapter 1: Business Intelligence: A Data Analysis Foundation; Introducing Business Intelligence; Multidimensional Data Analysis; Understanding a Dimensional Data Warehouse; Multidimensional OLAP; Chapter 2: Understanding OLAP and Analysis Services; Understanding OLAP; Understanding Analysis Services; Analysis Services and the Microsoft Business Intelligence Platform; Analysis Services Tools; Chapter 3: Accessing Source Data; Creating a Business Intelligence Solution; Creating a Data Source; Creating a Data Source View; Part II: Design Fundamentals; Chapter 4: Creating Dimensions; Previewing Dimension Data; Creating a Standard Dimension; Creating a Time Dimension; Creating a Parent-Child Dimension; Chapter 5: Creating a Cube; Previewing Cube Data; Using the Wizard to Create a Cube; Deploying and Browsing a Cube; Using the Cube Designer to Modify a Cube; Chapter 6: Creating Advanced Measures and Calculations; Using Aggregate Functions; Using MDX to Retrieve Values from a Cube; Creating Calculated Members; Calculation Scripting; Creating KPIs; Chapter 7: Advanced Dimension Design; Dimension Usage; Creating Reference Dimensions; Creating a Fact Dimension; Creating a Many-to-Many Dimension; Part III: Advanced Design; Chapter 8: Working with Account Intelligence; Designing a Financial Analysis Cube; Working with Account Intelligence; Creating an Account Dimension; Chapter 9: Currency Conversion and Multiple Languages; Supporting Foreign Currency Conversion; Supporting Foreign Language Translation; Chapter 10: Interacting with a Cube; Implementing Actions; Using Writeback to Modify Analysis Services Data; Chapter 11: Retrieving Data from Analysis Services; Creating Perspectives; Creating MDX Queries; Accessing Analysis Services Using Excel 2007; Creating Reporting Services Reports; Chapter 12: Implementing Security; Understanding Roles; Securing Administrative Access; Securing Data Access; Chapter 13: Designing Aggregations; Understanding Aggregation Design; Using the Aggregation Design Wizard; Using the Usage-Based Optimization Wizard; Part IV: Production Management; Chapter 14: Managing Partitions and Database Processing; Working with Storage; Managing Analysis Services Processing; Working with Partitions; Chapter 15: Managing Deployment; Deployment Overview; Deployment Mechanics; Deployment Using Business Intelligence Development Studio; Deployment Using the Deployment Wizard; Understanding Deployment Scripts; Migrating Databases and Disaster Recovery; Chapter 16: Advanced Monitoring and Management Tools; Monitoring Analysis Services Using Windows Reliability And Performance Monitor; Monitoring Analysis Services Using SQL Server Profiler; Analysis Services Dynamic Management Views; Appendix : About the Author; Contributing Authors;