MS SQL Server Training - MS SQL Server 2005: Designing an Analysis Solution Architecture (2796E)

Loading

MS SQL Server Training - MS SQL Server 2005: Designing an Analysis Solution Architecture (2796E) in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.


2050.-/d
ID : 18

Goal : The purpose of this training is to teach business intelligence (BI) professionals working in enterprise environments how to design a multidimensional solution architecture that supports their BI solution. The training focuses on the planning and design aspects of an analysis solution and does not teach students how to create Analysis Services database objects or how to use the development tools provided with SQL Server 2005.

Audience : This training is intended for experienced BI professionals. The target students for this training already have an understanding of how to use SQL Server 2005 tools to implement Analysis Services functionality, but need to develop their understanding of design principles and best practices when planning, implementing, and deploying an Analysis Services solution.

Prerequisites : The target students for this training already have an understanding of how to use the SQL Server 2005 tools to implement reporting functionality.

Goals :
  • Introduction
  • Capturing Business and Technical Requirements
  • Planning an Analysis Solution
  • Identifying Requirements and Constraints
  • Designing and Implementing a Logical OLAP Solution Architecture
  • Planning an OLAP Solution
  • Designing and Implementing Fact and Dimension Tables
  • Designing and Implementing Cubes
  • Designing Physical Storage for a Multidimensional Solution
  • Designing Physical Storage
  • Partitioning Relational Data
  • Partitioning Multidimensional Data
  • Creating Calculations
  • Implementing Calculated Members
  • Implementing Named Sets
  • Implementing Scoped MDX Scripts
  • Extending Cube Functionality
  • Key Performance Indicators
  • Actions
  • Stored Procedures
  • ...
Pedagogical method : Training based on MS slides and exercises

Suggested duration for presentiel training (days) : 3
Suggested duration for on-line training (days) : 3.6

Daily price in face-to-face : 2050 CHF
Daily price in remote : 984 CHF
Daily price in remote for students : contact us (only if student card!)
Daily price in remote (with recording) : 10250 CHF
Prices are per day per trainee without course material, without certificate, without evaluation, without exam, without training room or computer (these are each optional and must be requested in addition in the contact form for the establishment of the quote).


Tags : ms sql server 2005 training, analysis services, training ms 2796, ms sql 2005.