2074 - OLAP course

WHAT IS THE AIM OF THE COURSE?

This course provides students with the knowledge and skills necessary to design, implement, and deploy OLAP solutions by using Microsoft SQL Server 2000 Analysis Services!

WHO SHOULD ATTEND?

This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for working with the SQL Server.

HOW CAN I RECEIVE THE TRAINING?

1. You can do it via our mentored learning solution, MyChoice!
2. Day or evening training provided

EXAMINATIONS AND ASSESSMENTS

In support of your learning, New Horizons provides reinforcement tools to increase retention of the course material and move you further along your learning lifecycle. From hands-on practice to study aides and resources, we supply you with the tools necessary to enhance your New Horizons Integrated Learning experience.

LEARNING MATERIALS

All standard learning materials(like manuals) are included in the course fee!

WHAT DOES THE COURSE CONSIST OF?

The OLAP course consists of the following modules:

• Introduction to Data Warehousing and OLAP
• Introducing Analysis Manager Wizards
• Understanding Analysis Services Architecture
• Building Dimensions Using the Dimension Editor
• Using Advanced Dimension Settings
• Working with Cubes and Measures
• Case Study - Creating the Store Expense Cube
• Managing Storage and Optimization
• Processing Dimensions and Cubes
• Managing Partitions
• Implementing Calculations Using MDX
• Working with Virtual Cubes
• Using Excel as an OLAP Client
• Using Actions, Drillthrough, and Writeback
• Implementing Security
• Deploying an OLAP Solution
• Introduction to Data Mining
• Case Study - Working with the Foodmart Database