MS SQL Server 2005: Implementing and Maintaining Analysis Services (2791E)

Formation MS SQL Server - MS SQL Server 2005: Implementing and Maintaining Analysis Services (2791E) 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 : 109

Goal : Describe how SQL Server Analysis Services can be used to implement analytical solutions: create multidimensional analysis solutions and Secure an Analysis Services database, maintain a multidimensional Analysis Services solution...

Audience : This training is intended for IT professionals and developers who need to implement analysis solutions by using MS Analysis Services.

Prerequisites : Before attending this training, students must have conceptual understanding of OLAP/SQL solutions and Windows Server environment.

Goals :

- Introduction

- Presentation of MS SQL Server 2005 Analysis Services

- Creating a Multidimensional Analysis Solution

- Defining Dimensions

- Configuring Measures and Measure Groups

- Querying a Cube

- Customizing a Cube

- Deploying and Securing an Analysis Services Database

- Maintaining an Analysis Services Database

- Introducing Data Mining

- Implementing Data Mining

- Training Conclusion

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 training, sql server 2005, ms sql server 2005 training, analysis services training, implementing analysis services, maintaining analysis services, ms training 2791, ssas training, cube creation, cube optimisation, training 2791, ms sql 2005.

Contents