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