TARGIT Certified Professional

In depth knowledge and insight!

Purpose

The purpose of this course is to teach participants about the rationale and underlying technology associated with the process of implementing a multidimensional data mart.

The course will enable the participant to use the SQL Server 2005 as the end-to-end data solution for creating, deploying and managing multidimensional data marts. Compared with SQL 2000, the new SQL 2005 introduces radical changes and improvements to Analysis Services and ETL. The main purpose of getting data from A to Z will be the same, but the way to implement it, is quite different.

Duration

The course is a 4 day course and is concluded with a four-hour examination, including a multiple choice test and practical implementation exercises. Participants' performance is then evaluated, and each participant will be notified of their result via e-mail.

Goals

After having passed this course, participants will be able to:

Understand and use basic data warehouse techniques
Monitor and carry out the implementation of a data mart from start to finish
Build and optimize a data mart
Install and configure TARGIT with their own business terms

Content

The TARGIT environment: The physical environment, elements and relationships
Foundational data warehouse terms and definitions
Extracting, transforming and loading data
Creating an Analysis Services Project; defining cubes, dimensions and measures
Using SQL Server Integration Services to automate data migration
Expanding the data model with additional data and advanced dimensions
Defining sets of Dimensions and Measures through the use of Perspectives
Best practices for handling data inconsistency

Participant Skills

Certain parts of the course involve manipulation of both data and database structure. This requires experience in working with relational databases, data modelling and general SQL. Foundational understanding of, and experience with, these elements is necessary in order to pass the final examination and subsequent certification.

Course Calendar for TARGIT Certified Professional (with SQL Server 2005)