Course Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services

Duration (days): 2
Price (CZK): 10000

Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services topics:

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 (KPI)
• Implementing Actions
• Working with Perspectives
• Working with 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

All course schedules I will make suitable according your individual requirements.
If course topics are not suitable for you then contact me contact and we will come to topics meet your individual bussiness needs