6234 Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services

Displaying courses for United States [Change]
This course provides material for:
Microsoft Exam code: Exam 70-448

Overview

This course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube.

Objectives

After completing this course, students will be able to:
  • Describe how SQL Server Analysis Services can be used to implement analytical solutions.
  • Create multidimensional analysis solutions with SQL Server Analysis Services.
  • Implement dimensions and cubes 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.

Audience

The primary audience for this course is individuals who design and maintain business intelligence solutions for their organization. These individuals work in environments where databases play a key role in their primary job and may perform database administration and maintenance as part of their primary job responsibilities.The secondary audience for this course is individuals who develop applications that deliver content from SQL Server Analysis Services to the organization.

Syllabus

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

Training provider

Teaching mode:
Online - Self paced
Classroom - Instructor Led
Online - Instructor Led
Duration: 3 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Microsoft Analysis Services
United States
This skill has an average salary of
US$96,871
and is mentioned in
0.18%
of job ads in this area.
Analysis
United States
This skill has an average salary of
US$77,620
and is mentioned in
25.43%
of job ads in this area.
Data analysis
United States
This skill has an average salary of
US$77,039
and is mentioned in
4.29%
of job ads in this area.
Database
United States
This skill has an average salary of
US$77,360
and is mentioned in
14.10%
of job ads in this area.