Recharge | TimeXtender Academy

Autoplay
Autocomplete

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

Recharge

Your doing great! Go ahead and reward yourself with a mind break.

Enjoy this relaxation breath guided meditation: