Microsoft SQL Server 2008 Analysis Services : Step by Step

Paperback
from $0.00

Author: Scott Cameron

ISBN-10: 0735626200

ISBN-13: 9780735626201

Category: Applications & Languages - Databases

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...

Search in google:

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 DVDThe 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 OReilly Medias Digital Distribution services. To download this content, please visit OReillys 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.

AcknowledgmentsIntroductionPart I: Understanding Business Intelligence and Analysis ServicesChapter 1: Business Intelligence: A Data Analysis FoundationChapter 2: Understanding OLAP and Analysis ServicesChapter 3: Accessing Source DataPart II: Design FundamentalsChapter 4: Creating DimensionsChapter 5: Creating a CubeChapter 6: Creating Advanced Measures and CalculationsChapter 7: Advanced Dimension DesignPart III: Advanced DesignChapter 8: Working with Account IntelligenceChapter 9: Currency Conversion and Multiple LanguagesChapter 10: Interacting with a CubeChapter 11: Retrieving Data from Analysis ServicesChapter 12: Implementing SecurityChapter 13: Designing AggregationsPart IV: Production ManagementChapter 14: Managing Partitions and Database ProcessingChapter 15: Managing DeploymentChapter 16: Advanced Monitoring and Management ToolsAppendix : About the Author