Onderwerpen
De cursus Implementing and Maintaining Microsoft SQL Server2008 Analysis Services behandelt de volgende onderwerpen:
- Module 1: Introduction to Microsoft SQL Server Analysis Services
- This module introduces common analysis scenarios and describes how Analysis Services provides a powerful platform for multidimensional OLAP solutions and data mining solutions. The module then describes the main considerations for installing Analysis Services.
- Lessons
- Lesson 1: Overview of Data Analysis Solutions
- Lesson 2: Overview of SQL Server Analysis Services
- Lesson 3: Installing SQL Server Analysis Services
- Module 2: Creating Multidimensional Analysis Solutions
- This module introduces the development tools you can use to create an Analysis Services multidimensional analysis solution, and describes how to create data sources, data source views, and cubes.
- Lessons
- Lesson 1: Developing Analysis Services Solutions
- Lesson 2: Creating Data Sources and Data Source Views
- Lesson 3: Creating a Cube
- Module 3: Working with Cubes and Dimensions
- This module describes how to edit dimensions and to configure dimensions, attributes, and hierarchies.
- Lessons
- Lesson 1: Configuring Dimensions
- Lesson 2: Defining Attribute Hierarchies
- Lesson 3: Sorting and Grouping Attributes
- Module 4: Working with Measures and Measure Groups
- This module explains how to edit and configure measures and measure groups.
- Lessons
- Lesson 1: Working With Measures
- Lesson 2: Working with Measure Groups
- Module 5: Querying Multidimensional Analysis Solutions
- This module introduces multidimensional expressions (MDX) and describes how to implement calculated members and named sets in an Analysis Services cube.
- Lessons
- Lesson 1: MDX Fundamentals
- Lesson 2: Adding Calculations to a Cube
- Module 6: Customizing Cube Functionality
- This module explains how to customize a cube by implementing key performance indicators (KPIs), actions, perspectives, and translations.
- Lessons
- Lesson 1: Implementing Key Performance Indicators
- Lesson 2: Implementing Actions
- Lesson 3: Implementing Perspectives
- Lesson 4: Implementing Translations
- Module 7: Deploying and Securing an Analysis Services Database
- This module describes how to deploy an Analysis Services database to a production server, and how to implement security in an Analysis Services multidimensional solution.
- Lessons
- Lesson 1: Deploying an Analysis Services Database
- Lesson 2: Securing an Analysis Services Database
- After completing this module, students will be able to:
- Deploy an Analysis Services database.
- Secure an Analysis Services database.
- Module 8: Maintaining a Multidimensional Solution
- This module discusses the maintenance tasks associated with an Analysis Services solution, and describes how administrators can use the Analysis Services management tools to perform them.
- Lessons
- Lesson 1: Configuring Processing
- Lesson 2: Logging, Monitoring, and Optimizing an Analysis Services Solution
- Lesson 3: Backing Up and Restoring an Analysis Services Database
- Module 9: Introduction to Data Mining
- This module introduces data mining, and describes how to implement data mining structures and models. It then explains how to validate data model accuracy.
- Lessons
- Lesson 1: Overview of Data Mining
- Lesson 2: Creating a Data Mining Solution
- Lesson 3: Validating Data Mining Models
Meer informatie?
Geïnteresseerd geraakt in deze opleiding
en wilt u weten wanneer er weer een sessie gepland wordt?

Vraag informatie aan
| Lesmethode | Klassikaal |
| Cursusduur | 3 dagen |
| Cursuscode | M6234 |
| Locatie | Amsterdam-1 | Drachten | Nieuwegein | Op uw locatie? |
| Prijs | € 2.223,08 | € 2.223,08 | € 2.223,08 | Vraag info aan |
| Actieprijs | € 1.372,75 | € 1.372,75 | € 1.372,75 | |
| Cursusdata (*) | 09-07, 10-07 en 11-07.
| 10-09, 11-09 en 12-09.
| 01-10, 02-10 en 03-10.
| Vraag info aan |
| Info van de leverancier | Info | Info | Info |
Ook partner worden van Pluspartner? Neem contact op met ons voor meer info.