Dot
Dot
Dot

course overview

Dot
Dot
Dot
Dot
Dot
Dot
Dot

START

Dot
Dot
Dot
Dot
Dot

what is Timextender?

Learn the key concepts, native features, customer use cases, and reference architectures that TimeXtender provides for future-proof, and holistic data solutions.


This is a great way to kick-start your learning!

Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot

Create a sandbox

Quickly setup an environment for learning or testing TimeXtender in the cloud or on you machine.


See module Table of Contents for topics covered.

Dot
Dot
Dot
Dot
Dot
Dot

Portal & INstallATION

Master the TimeXtender Portal to create instances, manage user access, data sources, and install the TimeXtender Desktop application and ODX Server, as well as Multiple Enviroments and Transfer Environments between instances.


See module Table of Contents for topics covered.

Dot
Dot
Dot
Dot
Dot
Dot

OPERATIONAL DATA EXCHANGE

From data source configuration, and data transfers, to mastering tasks for data ingestion and storage management, and automated incremental loads, dive into the ODX to learn about how to ingest data with TimeXtender.


See module Table of Contents for topics covered.

Dot
Dot
Dot
Dot
Dot
Dot

Modern Data Warehouse

Dot
Dot

Learn the foundational concepts of modern data warehousing, including Dimensional Modeling, understanding Dimension & Fact tables, the significance of Denormalization, and the structure of the Star Schema.


See module Table of Contents for topics covered.

Dot
Dot
Dot
Dot
Dot
Dot

Product Dimension

Techniques for efficient data extraction and analysis are rooted in denormalization and the creation of MDW dimensions. Let’s see how to create a “Product Dimension” using AdventureWorks dataset.


See module Table of Contents for topics covered.

Dot
Dot
Dot

Customer Dimension

Harness TimeXtender's capabilities to streamline conditional transformations, optimize multi-field lookups, and fine-tune data management with field transformations and conditions.


See module Table of Contents for topics covered.

Dot
Dot
Dot

Sales Transactions

Learn data integration with TimeXtender: denormalizing “Header to Detail”, deployment, field calculations, and custom views.


See module Table of Contents for topics covered.

Dot
Dot
Dot
Dot
Dot
Dot
Dot

Finalizing the MDW

Explore the Presentation Layer, create a Date dimension,

and automate Incremental Load in the MDW.


See module Table of Contents for topics covered.

Dot
Dot
Dot

Semantic models

Construct data marts, translate technical data into business terms, and deploy seamlessly to across data visualization platforms, like Power BI, Tableau, and Qlik.


See module Table of Contents for topics covered.

Dot
Dot
Dot
Dot

Data Quality

Grasp techniques for data integrity, from primary key checks and referential integrity, to validation rules and efficient synchronization.


See module Table of Contents for topics covered.

Dot
Dot
Dot
Dot
Dot

Optimize data warehouse performance with tools for cleanup, indexing, version control, and effective tracking of object dependencies.


See module Table of Contents for topics covered.

Dot
Dot
Dot
Dot
Dot

Understand table transformations with schema management, streamlined data aggregation, practical SQL snippets, and seamless custom data and code integration.


See module Table of Contents for topics covered.

TABLE TRANSFORMATIONS

Dot
Dot

SLOWLY CHANGING DIMENSIONS

Understand data history and SCD Types 0, 1, and 2 in TimeXtender. Learn effective SCD implementation, surrogate and supernatural keys, and methods to automatically track data changes in your data solution.


See module Table of Contents for topics covered.

Dot
Dot
Dot
Dot

SECURITY

Implement role-based security across ODX, MDW, and SSL, with granular control from data areas to object, row, and model levels, ensuring precise access and endpoint mappings.


See module Table of Contents for topics covered.

Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot

JOBS

Implement Jobs to schedule End-to-End data refresh, schedule ODX tasks and to automate your work and get the most out of your data estate. External Executions (PowerShell) and “Data On-Demand” are advanced features but simple to implement.


See module Table of Contents for topics covered.

Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot

END

Dot

END

CERTIFICATION EXAM

Review the Study Guide,

Exam Registration, Get Certified!

Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot
Dot

Check out this highly technical, concise, and informative how-to series! We release new episodes regularly, so stay tuned.


View the full list of episodes.