Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous
Next
Discovery Hub® 101 - Basics
Getting Started
What to Expect
Get a Discovery Hub License Key
Training Prerequisites
Overview: Installation - 1:50
Download AdventureWorks
Section Quiz
Using Discovery Hub
Overview: The User Interface - 1:46
Overview: Project Workflow - 2:32
Overview: The Project Repository & Metadata
Follow Along: Creating, Saving, & Versioning Projects - 1:52
Section Quiz
The Operational Data Exchange (ODX)
Overview: The Operational Data Exchange
Follow Along: Creating an Operational Data Exchange (Business Unit)- 2:08
Overview: Data Sources
Follow Along: Adding a SQL Server Data Source - 1:20
Follow Along: Adding Tables & Fields from a Data Source - 1:58
Follow Along: Configuring ODX Schemas and Adding Suggested Constraints - 1:51
Overview: Deployment & Execution
Follow Along: Deployment & Execution- 2:48
Section Quiz
Recharge
The Modern Data Warehouse (MDW)
Overview: The Modern Data Warehouse
Overview: The Dimensional Model
Overview: The MDW Model
Follow Along: Creating a Modern Data Warehouse - 1:43
Section Quiz
Creating the Product Dimension
Overview: The Product Dimension
Follow Along: Moving tables to the DSA - 1:45
Overview: Relations & Conditional Lookups
Follow Along: Denormalize Product Model - Relations & Conditional Lookups - 2:15
Follow Along: Denormalize Product Category - Relations, Lookups, & the Relation Diagram - 2:52
Overview: Transformations & Conditions
Follow Along: Resolving Nulls - Fixed Transformation & Conditions - 1:50
Overview: Data Selection Rules
Follow Along: Finalizing the Product Dimension - Data Selection - 2:00
Section Quiz
Creating Sales Transactions
Overview: Transaction Tables in the MDW
Follow Along: Denormalize Sales Transactions - Custom Transformations - 2:45
Section Quiz
Creating the Customer Dimension
Overview: The Customer Dimension
Follow Along: Denormalize Customers - Multi-Field Lookups - 4:23
Exercise: Create a CustomerType attribute
Exercise: Add PhoneNumber and EmailAddress to the Customer Table
Section Quiz
Recharge
Finalizing the MDW
Overview: The Date Dimension
Follow Along: Create a Date Table - 1:20
Follow Along: Relate tables in the MDW - 1:08
Section Quiz
The Semantic Layer
Overview: The Semantic Layer
Follow Along: Create a Semantic Model - 4:00
Next Steps
Optional Exercise: Build a Purchasing Semantic Model
Additional Resources
Feedback
Next Steps
Overview: The Dimensional Model
Contents locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock