Your hands-on, practical guide to Microsoft SQL Server 2005 Analysis Services. Get started using Business Intelligence tools that simplify data analysis and with this popular, learn-by-doing tutorial.

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

The CD that accompanies the print edition of this book is not available with its eBook edition, although select CD content is available for download. A link to the content is included in your eBook.