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
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