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
Exercise: Add Product Table to Sales Model
Steps:
Drag the
Product
table from the
MDW
Data Warehouse and drop it on the
Tables
node in the Semantic Model
Sales
Select the fields
Color, ProductCategoryName,ProductModelName, ProductName and ProductSubCategoryName
and click
OK
button
Show Example
Note: Video is free of audio
Next