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

Designing Data Warehouses using Dimensional Modeling

2 days
usdwh-1
2 days

Upcoming Sessions

Date: currently not scheduled

Format: Classroom

Price: 900€

Subscribe to waiting list

Date: currently not scheduled

Format: Classroom

Price: 900€

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

not specified

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.

Contact Us
  • Address:
    U2U nv/sa
    Z.1. Researchpark 110
    1731 Zellik (Brussels)
    BELGIUM
  • Phone: +32 2 466 00 16
  • Email: info@u2u.be
  • Monday - Friday: 9:00 - 17:00
    Saturday - Sunday: Closed
Say Hi
© 2021 U2U All rights reserved.