Feedback | TimeXtender Academy

Autoplay
Autocomplete

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

Feedback

If you are unable to view the form below please click the following link: TimeXtender Online Training Feedback

Next

Lecture Content Locked

Your session expired. Please sign in again to continue.

Login