Microsoft SQL Server 2008 Analysis Services Step by Step (Step By Step (Microsoft))

✍ Scribed by Scott Cameron

• Publisher: Microsoft Press
• Year: 2009
• Tongue: English
• Leaves: 424
• Series: Step By Step Microsoft
• Edition: 1
• Category: Library

✦ Synopsis

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.