Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services

MOC 6234 Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services

Dauer 3 Tage

Preis Euro 1690,0000 zzgl. MwSt.

Zielgruppe IT-Professionals, die Ihren Kenntnisstand auf Business Intelligence Lösungen für den SQL Server 2008 erweitern wollen.

Voraussetzungen Konzeptionelles Verständnis von OLAP-Lösungen wie es in dem Seminar MOC2796 vermittelt wird.
Erfahrung mit dem Windows Server
Erfahrung mit dem SQL Server, insbesondere:
- SQL Server Agent
- SQL Server Query Language (SELECT, UPDATE, INSERT und DELETE)
- SQL Server System Tables
- SQL Server Accounts

Inhalte Introduction to Microsoft SQL Server Analysis Services Overview of Data Analysis Solutions Overview of SQL Server Analysis Services Installing SQL Server Analysis Services Creating Multidimensional Analysis Solutions Developing Analysis Services Solutions Creating Data Sources and Data Source Views Creating a Cube Working with Cubes and Dimensions Configuring Dimensions Defining Attribute 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 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

Kleiner Bildungsberater