Microsoft SQL Server 2008 Analysis Services Step by Step
Microsoft Press
Published on 15. April 2009
Book
Mixed media product
448 pages
978-0-7356-2620-1 (ISBN)
Description
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.
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
More details
Language
English
Place of publication
Redmond
United States
Target group
Professional and scholarly
Dimensions
Height: 229 mm
Width: 187 mm
ISBN-13
978-0-7356-2620-1 (9780735626201)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Persons
Paul Turley, Joe Kasprzak, Scott Cameron, Satoshi Iizuka, and Pablo Guzman are each business intelligence experts who work for Hitachi Consulting.
Content
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
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