Microsoft SQL Server 2005 Analysis Services Step by Step

Description

Annotation 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

A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to [email protected].

Get the book

Similar books

• 

  Inside Microsoft SQL Server 2008: T-SQL Querying

  By Itzik Ben-Gan

  Tackle the toughest set-based querying and query tuning problems--guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals--and gain practical approaches and...

• 

  Inside Microsoft SQL Server 2008: T-SQL Programming

  By Itzik Ben-Gan

  Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the...

• 

  Advanced Oracle PL/SQL: Programming with Packages

  By Steven Feuerstein

  Steven Feuerstein's first book,Oracle PL/SQL Programming, has become the classic reference to PL/SQL, Oracle's procedural extension to its SQL language. His new book looks thoroughly at one especially advanced and...

• 

  Inside Microsoft SQL Server 2005: Query Tuning and Optimization

  By Kalen Delaney

  Dig into the internals of tuning and optimization features in SQL Server 2005--with insights from leading SQL Server experts. This in-depth guide delivers best practices, pragmatic advice, and code samples...

• 

  A Developer's Guide to SQL Server 2005

  By Bob Beauchemin, Dan Sullivan

  "I come from a T-SQL background, so when I first laid my eyes on SQL Server 2005, I was shocked--and then, I was scared! I didn't have a CLR or...

• 

  SQL Fundamentals

  By John J. Patrick

  A comprehensive tutorial covering the fundamental concepts and ideas of SQL, and showing how these are implemented in both Oracle 9I and Access 2000 databases. John Patrick discusses how to...

• 

  Microsoft SQL Server 7.0 Programming Unleashed

  By Matthew Shepker, John Papa

  Certified professionals offer the benefits of their experiences in a variety of SQL Server settings as well as useful tips and workarounds to common problems. Overview of Major Topics: Part...

• 

  A First Look at SQL Server 2005 for Developers

  By Bob Beauchemin, Dan Sullivan, Niels Berglund

  Be the first to master SQL Server 2005's breakthrough database development capabilities Few technologies have been as eagerly anticipated as Microsoft SQL Server 2005 ("Yukon"). Now, three SQL Server insiders...

• 

  Real World SQL Server Administration with Perl

  By Linchi Shea

  This book is about solving SQL Server administrative problems with Perl. Linchi has designed it to consist of a series of scenarios covering a wide range of SQL Server administrative...

• 

  A Guide to the SQL Standard: A User's Guide to the Standard Relational Language SQL

  By C. J. Date, Hugh Darwen

  A guide for users and designers of database systems. Outlines the inherent problems in the study, design, and implementation, and examines the background issues of priorities, administrative prerequisites, design concepts,...