Microsoft SQL Server 2005 Analysis Services Step by Step - Brossura

Jacobson, Reed; Misner, Stacia

Brossura

ISBN 10: 0735621993 ISBN 13: 9780735621992

Casa editrice: Microsoft Pr, 2006

Riassunto

Teach yourself the fundamentals of SQL Server Analysis Services—one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to build flexible and powerful solutions that meet the analytical needs of your organization.

Discover how to:

• Start building cubes using the Microsoft Visual Studio 2005 Business Intelligence designers
• Create dimensions and measure groups to build, browse, and modify OLAP cubes
• Design objects to handle unique financial analysis requirements
• Improve query performance with aggregations and user hierarchies
• Customize cubes with multi-dimensional expressions (MDX) and other advanced design techniques
• Use actions to integrate Web pages, reporting applications, and drillthrough capabilities with cubes
• Manage role-based security and restrict data access
• Deploy and maintain a database in a production environment

CD features

• All practice exercises and answer files
• Fully searchable eBook

Su questo libro

L'autore

Reed Jacobson is a senior architect in Hitachi Consulting’s Business Intelligence practice. He has authored several training courses and books, including Microsoft SQL Server 2000 Analysis Services Step by Step.

Hitachi Consulting, a division of Hitachi Ltd., is a global business and IT consulting firm serving Fortune 2000 companies. It is a leader in developing corporate training and custom solutions for Reporting Services

Stacia Misner, MCITP, MCTS, is a consultant and trainer specializing in Microsoft business intelligence solutions. She has more than 20 years of IT experience and has written several books on SQL Server, including Microsoft SQL Server 2008 Reporting Services Step by Step. Stacia is also one of the first to earn the new SQL Server Analysis Services Maestro certification.

Contenuti

IntroductionPart I: Getting Started with Analysis Services

• Chapter 1: Understanding Business Intelligence and Data Warehousing
• Chapter 2: Understanding OLAP and Analysis Services
• Chapter 3: Building Your First Cube

Part II: Design Fundamentals

• Chapter 4: Designing Dimensions
• Chapter 5: Designing Measure Groups and Measures
• Chapter 6: Working with a Finance Measure Group
• Chapter 7: Designing Aggregations and Hierarchies

Part III: Advanced Design

• Chapter 8: Using MDX
• Chapter 9: Exploring Special Features
• Chapter 10: Interacting with Cubes

Part IV: Production Management

• Chapter 11: Implementing Security
• Chapter 12: Managing Partitions and Database Processing
• Chapter 13: Managing Deployment

GlossaryAppendix : About the Authors

Dettagli dell?edizione

• Editore: Microsoft Pr
• Data di pubblicazione: 2006
• ISBN 10: 0735621993
• ISBN 13: 9780735621992
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero edizione: 1
• Numero di pagine: 384