Autoplay
Autocomplete
Previous
Next
v20 TimeXtender - Basics
Getting Started
What to Expect: Course Overview
Get a TimeXtender License Key
Prerequisites: Configure Your Environment
Download the AdventureWorks Sample Database
Introduction to TimeXtender
What is TimeXtender?
The Three Layers
The User Interface
ODX Server
Section Contents
ODX Server Configuration & Considerations
Foundation: Understanding the ODX Server
Exercise: Connect to ODX Server
Exercise: Create Data Source in the ODX Server
Exercise: Select Tables for ODX
Exercise: Override Data Types
Foundation: ODX Tasks
Exercise: Create Task and Schedule for ODX Data Source
Exercise: Synchronize and Transfer ODX tables
Foundation: ODX Logs
Exercise (optional): Add a Query Table to Data Source
Exercise (optional): Create an Azure Data Factory Data Source
Quiz: ODX Server
Project Repositories & Global Databases
Section Contents
Foundation: Understanding Project Repositories
Exercise: Create Local Development Environment
Foundation: Global Databases
Exercise: Create Global Databases
Exercise (optional): Create & Deploy to Azure SQL Database
Projects
Section Contents
Foundation: Understanding Projects
Exercise: Create a Project
Exercise: Save your Project
Exercise: Open Project Versions
Quiz: Projects
The Modern Data Warehouse (MDW)
Foundation: Understanding the Modern Data Warehouse
Foundation: The Dimensional Model
Foundation: The MDW Model
Quiz: MDW and the Dimensional model
The Product Dimension
Section Contents
Exercise: Creating Data Warehouses
Exercise: Add Product tables from ODX Server to Data Warehouse
Foundation: Deployment and Execution
Exercise: Reorder tables, Deploy and Execute
Quiz: Deployment and Execution
Exercise: Rename fields to ProductModel and ProductName
Foundation: Relations and Conditional Lookups
Exercise: Relate ProductModel to Product and Lookup ProductModelName
Exercise: Lookup Product Categories to Product table
Foundation: Transformations and Conditions
Exercise: Add Field Transformations ProductModel, ProductCategory, and ProductSubCategory
Foundation: Data Selection Rules
Exercise: Add Product table to MDW database applying Data Selection Rule
Quiz: Data Transformation - Relations, Lookups, conditions and selections
Sales Transactions
Section Contents
Foundation: Transaction Table Granularity
Exercise: Add SalesOrder tables and Lookup values to DSA
Exercise: Add field GrossLineTotal with Custom Transformation
Exercise: Add Sales Order tables to MDW
Quiz: Multiple Lookups and Parameters
Exercise (optional): Validate and Transform data in a newly imported table
Recharge
The Customer Dimension
Section Contents
Foundation: The Customer Dimension
Exercise: Add Customer dimension
Exercise: Add Customer Type
Exercise: Add Phone number and E-mail address to Customer table
Quiz: Multi-Field Lookup
Finalizing Modern Data Warehouse
Section Contents
Foundation: The Date Dimension
Exercise: Add Date Table to MDW
Exercise: Relate tables in MDW
Quiz: Finalizing Modern Data Warehouse
Semantic Layer
Section Contents
Foundation: Understanding the Semantic Layer
Exercise: Create Semantic Model
Exercise: Add Order and Ship Date tables to Sales Model
Exercise: Add Product Table to Sales Model
Exercise: Add Customer Table to Sales Model
Exercise: Add SalesOrderDetail Table to Sales Model
Foundation: Analysis Services Tabular
Exercise: Add Tabular Endpoint to Sales Model
Quiz: Semantic Layer
Exercise (optional): Connect PowerBI to Tabular Model
Exercise (optional): Deploy your semantic model to Tableau & Qlik Endpoints
Exercise (optional): Deploy to Azure Analysis Services
Next Steps
TimeXtender Tuesday
Exercise (optional): Build a Purchasing Semantic Model
Exercise (optional): Export and Import a TimeXtender Project
Next Steps
Feedback
Section Contents
This section will cover:
Adding a Date table to the MDW
Relating Date table to other tables in the the MDW
Next