TimeXtender Core Product Training

Course description and Duration

In this 2 day instructor led course you’ll get an introduction in all basic features TimeXtender has to offer to build your data warehouse / data estate.

During the training you will build an entire TimeXtender project using a personalized TimeXtender environment we’ve setup for you. On request we can even give you access to your environment for a longer time so you can practice whenever you want (extra costs will be charged for using the Azure Labs environment).

Learning outcomes

  • Introduction
  • TimeXtender Basics
  • Operational Data Exchange
    • ODX Overview
    • Data Sources
    • Deployment & Execution
  • Modern Data Warehouse
    • Modern Data Warehouse overview
    • Data Staging Area overview
    • System Fields
  • Sprint 1 – Product Model & Sales Orders
    • Denormalization
    • Table Relationships
    • Conditional Lookups
    • Add New Fields
    • Transformations
  • Sprint 2 – Product Category
    • 2-step Denormalization
    • Field Validations
    • Transformations with conditions
    • Handling nulls
    • Date Table
  • Sprint 3 – Customer Dimensions
    • Data Selection Rule
    • SQL Snippets
  • Sprint 4 – Optimize MDW
    • Surrogate Keys
    • Handle null surrogate keys
    • Relationships in the MDW
  • History & Slowly Changing Dimensions
  • Incremental Load
  • Views, Tracing and Documentation
  • Execution Packages
  • Semantic Models
  • Final Exercise
  • Q & A