Microsoft® SQL Server™ 2005 Analysis Services Step by Step - Softcover

Jacobsen, Reed; Consulting, Hitachi; Misner, Stacia

Softcover

ISBN 10: 0735621993 ISBN 13: 9780735621992

Publisher: Microsoft Press, 2006

Synopsis

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

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

About this title

From the Publisher

The popular STEP BY STEP approach provides hands-on guidance to beginning-level programmers and those new to SQL Server 2005. A sequential, learn-by-doing tutorial, this book covers key features and techniques of Analysis Services to help programmers harness the full power of SQL Server 2005. The companion CD includes data sets and sample code.

Key Book Benefits:

· Delivers step-by-step instruction about how to install, enable, envision, create, and share analytical models based on SQL Server 2005 data stores

· Provides hands-on exercises that help develop proficiency quickly—based on data stores and examples provided on the enclosed CD

· Features expertise from Hitachi Consulting, which creates specialized SQL Server–based data solutions for corporate customers

· STEP BY STEP is ideal for anyone with a basic understanding of SQL Server

About the Author

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

Edition details

• Publisher: Microsoft Press
• Publication date: 2006
• ISBN 10: 0735621993
• ISBN 13: 9780735621992
• Binding: Paperback
• Language: English
• Number of pages: 400