course overview
START
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!
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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
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.
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.
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.
Additional training modules are still being developed. Check back later for more content.
Until then, continue with the old training.
Review the Study Guide,
Exam Registration, Get Certified!
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.