Autoplay
Autocomplete
Previous
Next
TimeXtender Classic - Basics
Getting Started
What to Expect: Course Overview
Instructor-Led Training
Get a TimeXtender License Key
Prerequisites: Configure Your Environment
Download the AdventureWorks Sample Database
Introduction to TimeXtender
What is TimeXtender Classic?
The User Interface
Data Storage & Metadata Repository
Foundation: Select your Deployment Target
Foundation: Understanding Project Repositories
Configuring Users & Permissions
Exercise: Create a Project Repository
Exercise: Create Local Development Environment
Foundation: Global Databases
Exercise: Create Global Databases
Optional: Deploy to Azure SQL Database
Projects
Foundation: Understanding Projects
Exercise: Create a Project
Exercise: Save your Project
Exercise: Open Project Versions
Quiz: Projects
Business Unit & Data Sources
Foundation: Business Unit
Exercise: Create Business Unit
Exercise: Enable Simple Mode
Foundation: Data Sources
Exercise: Add a Data Source
Exercise: Select Tables for Ingestion
Exercise: Configure Schemas
Exercise: Sync Keys and Relations
Optional: Data Source Selection Rules
Optional: Query Tables
Foundation: Deployment and Execution
Exercise: Deploy & Execute Business Unit
Quiz: Business Units
The Modern Data Warehouse (MDW)
Foundation: Understanding the Modern Data Warehouse
Foundation: The Dimensional Model
Foundation: The MDW Model
Exercise: Creating the MDW and DSA
Quiz: MDW and the Dimensional model
The Product Dimension
Exercise: Reorder tables, Deploy and Execute
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
Foundation: Transaction Table Granularity
Exercise: Denormalize the Sales Order Tables
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
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
Foundation: The Date Dimension
Exercise: Add Date Table to MDW
Exercise: Relate tables in MDW
Quiz: Finalizing Modern Data Warehouse
Semantic Layer
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
Quiz: Data Transformation - Relations, Lookups, conditions and selections
Next