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

Full Product Details

Author:   Hitachi Consulting ,  Scott Cameron
Publisher:   Microsoft Press,U.S.
Imprint:   Microsoft Press,U.S.
Dimensions:   Width: 18.70cm , Height: 2.80cm , Length: 22.90cm
Weight:   0.902kg
ISBN:  

9780735626201

ISBN 10:   0735626200
Pages:   448
Publication Date:   15 April 2009
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Mixed media product
Publisher's Status:   Out of Print
Availability:   Awaiting stock  

Table of Contents

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

Reviews

Author Information

Paul Turley, Joe Kasprzak, Scott Cameron, Satoshi Iizuka, and Pablo Guzman are each business intelligence experts who work for Hitachi Consulting.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions