Call Us: +32 2 466 00 16
Email: info@u2u.be
Follow Us:

Design, Build and Administer Data Warehouses with SQL Server 2008 Integration Services

5 days
usdwh
5 days

Upcoming Sessions

Date: currently not scheduled

Format: Classroom

Price: 1900€

Subscribe to waiting list

Date: currently not scheduled

Format: Classroom

Price: 1900€

Subscribe to waiting list

Interested in a private company training? Request it here.

The need for Data Warehousing

  • Data Warehouse definitions and terminology
  • Issues with live database reporting
  • Data Warehouse advantages
  • Conducting user interviews
  • Prioritizing the requirements
  • Documenting the requirements

Dimensional Modeling

  • Advantages and disadvantages of normalizing data
  • Fact tables
  • Dimension tables
  • Star versus snowflake dimensions

Designing the Time Dimension

  • Why do we need a time dimension
  • Designing the time dimension
  • Useful tools and scripts

Working with Slowly Changing Dimensions

  • Type I, II and III slowly changing dimensions
  • Designing for SCD
  • Advanced SCD types

Advanced dimensional design

  • Early arriving facts
  • Late arriving facts
  • Dealing with currency conversion
  • Dealing with hierarchies
  • Modeling many to many relations

Physical database design

  • Staging tables
  • Table design
  • Indexing

Tools

  • Overview of tools
  • Brief introduction into the Microsoft Data Warehousing tools

The goal of this course is to study the design of Data Warehouses and to focus on the implementation, maintenance and administration of the ETL packages needed to build actual Data Warehouses.

Participants should be familiar with the concepts of relational database design (tables, foreign keys, constraints, indexes). The exercises in this course are pen and paper exercises, so no specific software knowledge is needed.

© 2021 U2U All rights reserved.