Ships from: STERLING HEIGHTS, MI
Usually ships in 1-2 business days
Ships from: Sausalito, CA
Usually ships in 1-2 business days
Want a NOOK? Explore Now
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.
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
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 Data
Part II: Design Fundamentals
Chapter 4: Creating Dimensions
Chapter 5: Creating a Cube
Chapter 6: Creating Advanced Measures and Calculations
Chapter 7: Advanced Dimension Design
Part 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 Aggregations
Part IV: Production Management
Chapter 14: Managing Partitions and Database Processing
Chapter 15: Managing Deployment
Chapter 16: Advanced Monitoring and Management Tools
Appendix : About the Author
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, ...