espace vide espace vide espace vide
espace vide
Evaluant Training - formation et transfert de compétences Evaluant Services - consulting, développement sur les technologies Microsoft
espace vide
espace vide

Filière Décisionnel
Formation 2791AUS

Filières de formations

Accédez directement à une filière de formation :

Recherchez une formation

Rechercher :
 

Décisionnel


Formation Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services


Objectif de la formation

Describe how SQL Server Analysis Services can be used to implement analytical solutions.
Create multidimensional analysis solutions with SQL Server Analysis Services.
Implement dimensions in an Analysis Services solution.
Implement measures and measure groups in an Analysis Services solution.
Query a multidimensional Analysis Services solution.
Customize an Analysis Services cube.
Deploy and Secure an Analysis Services database.
Maintain a multidimensional Analysis Services solution.
Implement a Data Mining solution.

Profil des participants

This course is intended for information technology (IT) professionals and developers who need to implement analysis solutions by using Microsoft SQL Server 2005 Analysis Services.

Pré-requis

Conceptual understanding of OLAP solutions.
Experience with Microsoft SQL Server

Programme de la formation


Thématiques 
Introduction to Microsoft SQL Server 2005 Analysis Services
  • Overview of Data Analysis Solutions
  • Overview of SQL Server 2005 Analysis Services
  • Installing SQL Server 2005 Analysis Services
Creating Multidimensional Analysis Solutions
  • Developing Analysis Services Solutions
  • Data Sources and Data Source Views
  • Creating a Cube
Working with Dimensions
  • Configuring Dimensions
  • Defining Hierarchies
  • Sorting and Grouping Attributes
Working with Measures and Measure Groups
  • Working with Measures
  • Working with Measure Groups
Querying Multidimensional Analysis Solutions
  • MDX Fundamentals
  • Adding Calculations to a Cube
Customizing Cube Functionality
  • Implementing Key Performance Indicators
  • Implementing Actions
  • Implementing Perspectives
  • Implementing Translations
Deploying and Securing an Analysis Services Database
  • Deploying an Analysis Services Database
  • Securing an Analysis Services Database
Maintaining a Multidimensional Solution
  • Configuring Processing Settings
  • Logging, Monitoring, and Optimizing an Analysis Services Solution
  • Backing Up and Restoring an Analysis Services Database
Introduction to Data Mining
  • Overview of Data Mining
  • Creating a Data Mining Solution
  • Validating Data Mining Models

Prix

1230 € HT

(410 € HT / jour / personne)

Informations

Code : 2791AUS
Durée : 3 jours

Calendrier des sessions

Prochaines sessions dans notre centre de Strasbourg (Alsace).

Accéder au calendrier général

Actions

flèche Télécharger la fiche
flèche Envoyer à un ami
flèche Imprimer la fiche
flèche S'inscrire
espace vide
espace vide espace vide espace vide