Dimensional Modeling Video Tutorial
Data Modeling - Career Option ( 2 mins)
Data Modeling Introduction
Importance of Data Modeling and Data Modelers Role...
Data Modeling "what , why, when ,how " Factors (2...
Data Modeling Introduction - Slides
Data Modeling Introduction - Quiz
Data Warehousing - Concepts
Under standing OLTP, OLAP , Differentiating wrt ...
Datawarehousing Concepts ( 32 mins)
Data Warehousing Concepts - Quiz
Requirements Gathering - Data Model
Requirements Phase Importance (3 mins)
Building Dimensional Modelling -Requirements Gathe...
TOP Down and Bottom UP Approach - Case Study ( 5...
TOP Down and Bottom UP Approach -Part 2 (7 mins)
Why Separate Design Patterns (18 mins)
Banking Enterprise - Case Study -1
Second - Case Study
Building a Dimensional Model_Requirement Gathering...
Requirement Gathering - Quiz
Erwin Tool Introduction
Learner Expectations on ERwin Tool ( 12 mins)
ERwin Tool Introduction (30 mins)
Erwin Tool Introduction - Slides
Erwin Tool Introduction - Quiz
ERwin Tool Alternatives -For practising
Draw-io Free Design Tool -Conceptual Model Purpose...
DB Diagram - Erwin Alternative (Reference)
Erwin Tool Installation
Erwin Tool Installation ( 3 mins)
Erwin Installation - Slides
Erwin Installation - Quiz
Building a Data Model in Erwin
Building a Data Model ( 11 mins)
Building a Data Model - Slides
Create Entity ( 1 min)
Building a Data Model - Quiz
Erwin Tool bars and windows
Erwin Toolbars and Windows (47 mins)
Subject Areas ( 17 mins)
Diagrams and Themes in Erwin (10 mins)
Working with Erwin Tool - slides
Diagrams and Themes - Slides
Domains in Erwin Tool
Working with Domains (10 mins)
Domains - Slides
Working with Erwin Tool - Quiz
Dimensions In Detail
Dimensions (60 mins)
Slowly Changing Dimensions-SCD (19 mins)
SCD -Quiz Discussion( 8 mins)
Hybrid Dimensions (8 mins)
Fast Changing Dimension-FCD and Junk or Garbage di...
Degenerate Dimension ( 6 mins)
Conformed and Static and Role Playing Dimension (1...
Role Playing Dimensions in ERwin (5 mins)
Dimensions Basic - Part-1- slides
Dimensions Basic - Part-2- slides
Dimensions - Quiz
Facts
Facts-Concept (13 mins)
Facts-Types (fully Additive,Non Additive,Semi Addi...
Facts-Less Fact in Erwin(24 mins)
Facts -Slides
Facts - Quiz
Sample Data
Real Time Data -Dimensions and Facts (13 mins)
Grain and Hierarchy
Grain - Concept (12 mins)
Grains - Concept - slides
Grains -Multiple slides
Hierarchies Balanced /Unbalanced/Ragged (20 mins)
Hierarchies - slides
Grains and Hierarchies- Quiz
Schema Patterns
Star Schema (10 mins)
SnowFlake Schema ( 22 mins)
Schema Patterns - Slides
Schema Patterns - Quiz
Data Modeling Examples
Dimensional Modeling Examples (11 mins)
FAQ Videos
FAQ on Facts and Dimensions - (47 mins)
Data Abstraction
Conceptual ,Logical ,Physical Models (24 mins)
Conceptual Logical Physical Model - slides
Data Abstraction - Quiz
Enforcing Business Rules in Erwin
Constraints in Erwin ( 25 mins)
Default Values and Logical /Physical Only ( 16 m...
Constraints in Erwin - Slides
Business Rules in erwin - Quiz
DMDL
Dimension Model Design Life Cycle -DMDL (4 mins)
Dimensional model life cycle- DMDL - Slides
DMDL- Quiz
Forward and Reverse Engineering
Forward Engineering (26 mins)
Reverse Engineering (12 mins)
Forward and Reverse Engineering - Slides
Forward and Reverse Engineering - Quiz
Naming Standards - Erwin
Model Naming Options (12 mins)
Naming Standards Editor (27 mins)
Import glossary from CSV file (2 mins)
Name Hardening in Detail ( 11 mins)
Naming Standards - Slides
Naming Standards - Quiz
Data type Standards
Data Type Standards - Detail (29 mins)
Data Type Standards- Brief (3 mins)
Data Type Standards - Slides
Data Type Standards - Quiz
Data Modeling Standards - Sample Documents
Data Modelling Standards- Sample Document
Data Modeling - Best Practices
Comparison of Models
Complete Compare Feature (26 mins)
Comparison of Models- slides
Complete Compare - Quiz
Querying and Report Generation
Query Tool -Detailed (8 mins)
Query Tool - Brief (4 mins)
Bulk Editor (9 mins)
Generating Diagram Pictures (5 mins)
Report Designer (12 mins)
Querying and Reporting in Erwin - Slides
Querying and Reporting in Erwin - Quiz
Validating Data Model
Validating Data Model ( 16 mins)
Validating Data Model - Slides
Validating Data Model - Quiz
Inmon Vs Kimbal Approach
Inmon Vs Kimbal Approach (11 mins)
Inmon vs Kimball Approach - Slides
Relationship and Cardinality
Relationship Types - ( 9 mins)
Cardinality and Degree - ( 32 mins)
Identifying and Non-Identifying Relationships (11 ...
Relationship Types - Slides
Relationship and Cardinality - Quiz
Normalization Concepts
Need of Normalization ( 10 mins)
First Normalization -1NF ( 10 mins)
Second and Third Normal Forms (13 mins)
Normalization -Example ( 16 mins)
Normalization - Case Study Discussion and Quiz (15...
Primary key and Other Keys (17 mins )
Foreign Keys (5 min)
Surrogate Keys (19 mins)
Case study for Normalization
Normalization- slides
Normalization - Quiz
Using Erwin Help / Data Modeling References
Using Erwin Help (3 mins)
Reference Material Information
Reference Material Future reading on DataModel (8 ...
Dimensional Modeling Examples (11 mins)
Additional Videos
How to "Add Audit Columns" in "ERwin Tool" ( 6 min...
How to "Add Audit Columns" using Forward Engineer...
Split Model ( 3 mins)
Derive Model ( 4 mins)
Split Model and Derive Model - slides
Add Model Source( 3 mins)
Dimensional modeling features (3 mins)
Export Import Formats in Erwin( 5 mins)
Vertical Partitioning in ERwin ( 11 mins)
Demo Videos
Generating Diagrams pictures in ERwin Tool ( 5 mi...
Erwin Tool Installation ( 3 mins)
Data Modeling - Career Option ( 2 mins)
Data Modeling Demo (25 mins)
Erwin Tool Demo ( 5 mins)
Data Modeling Interview Questions ( 2 mins)
Designing Hive Tables in Erwin ( 6 mins)
Import table metadata using api in erwin ( 5 mins)
Testimonial on ERwin Training
FAQ / Interview Questions
Data Modeling - Interview Questions
Job Winning Data Modelling Strategies
Mock Tests -Test Your Knowledge (40 Questions)
Mock Test -1
Course info
×
Course info
Dimensional Modeling Video Tutorial
Content
Data Modeling Introduction
Importance of Data Modeling and Data Modelers Role ( 3 mins)
Data Modeling "what , why, when ,how " Factors (22 mins)
Data Modeling Introduction - Slides
Data Modeling Introduction - Quiz
Data Warehousing - Concepts
Under standing OLTP, OLAP , Differentiating wrt Requirements. (25 mins)
Datawarehousing Concepts ( 32 mins)
Data Warehousing Concepts - Quiz
Requirements Gathering - Data Model
Requirements Phase Importance (3 mins)
Building Dimensional Modelling -Requirements Gathering (37 mins)
TOP Down and Bottom UP Approach - Case Study ( 5 mins)
TOP Down and Bottom UP Approach -Part 2 (7 mins)
Why Separate Design Patterns (18 mins)
Banking Enterprise - Case Study -1
Second - Case Study
Building a Dimensional Model_Requirement Gathering- Slides
Requirement Gathering - Quiz
Erwin Tool Introduction
Learner Expectations on ERwin Tool ( 12 mins)
ERwin Tool Introduction (30 mins)
Erwin Tool Introduction - Slides
Erwin Tool Introduction - Quiz
ERwin Tool Alternatives -For practising
sample
Draw-io Free Design Tool -Conceptual Model Purpose (Erwin Alternative)
sample
DB Diagram - Erwin Alternative (Reference)
sample
Erwin Tool Installation
Erwin Tool Installation ( 3 mins)
Erwin Installation - Slides
Erwin Installation - Quiz
Building a Data Model in Erwin
Building a Data Model ( 11 mins)
Building a Data Model - Slides
Create Entity ( 1 min)
Building a Data Model - Quiz
Erwin Tool bars and windows
Erwin Toolbars and Windows (47 mins)
Subject Areas ( 17 mins)
Diagrams and Themes in Erwin (10 mins)
Working with Erwin Tool - slides
Diagrams and Themes - Slides
Domains in Erwin Tool
Working with Domains (10 mins)
Domains - Slides
Working with Erwin Tool - Quiz
Dimensions In Detail
Dimensions (60 mins)
Slowly Changing Dimensions-SCD (19 mins)
SCD -Quiz Discussion( 8 mins)
Hybrid Dimensions (8 mins)
Fast Changing Dimension-FCD and Junk or Garbage dimension (24 mins)
Degenerate Dimension ( 6 mins)
Conformed and Static and Role Playing Dimension (15 mins)
Role Playing Dimensions in ERwin (5 mins)
Dimensions Basic - Part-1- slides
Dimensions Basic - Part-2- slides
Dimensions - Quiz
Facts
Facts-Concept (13 mins)
Facts-Types (fully Additive,Non Additive,Semi Additive (23 mins)
Facts-Less Fact in Erwin(24 mins)
Facts -Slides
Facts - Quiz
Sample Data
Real Time Data -Dimensions and Facts (13 mins)
Grain and Hierarchy
Grain - Concept (12 mins)
Grains - Concept - slides
Grains -Multiple slides
Hierarchies Balanced /Unbalanced/Ragged (20 mins)
Hierarchies - slides
Grains and Hierarchies- Quiz
Schema Patterns
Star Schema (10 mins)
SnowFlake Schema ( 22 mins)
Schema Patterns - Slides
Schema Patterns - Quiz
Data Modeling Examples
Dimensional Modeling Examples (11 mins)
FAQ Videos
FAQ on Facts and Dimensions - (47 mins)
Data Abstraction
Conceptual ,Logical ,Physical Models (24 mins)
Conceptual Logical Physical Model - slides
Data Abstraction - Quiz
Enforcing Business Rules in Erwin
Constraints in Erwin ( 25 mins)
Default Values and Logical /Physical Only ( 16 mins)
Constraints in Erwin - Slides
Business Rules in erwin - Quiz
DMDL
Dimension Model Design Life Cycle -DMDL (4 mins)
Dimensional model life cycle- DMDL - Slides
DMDL- Quiz
Forward and Reverse Engineering
Forward Engineering (26 mins)
Reverse Engineering (12 mins)
Forward and Reverse Engineering - Slides
Forward and Reverse Engineering - Quiz
Naming Standards - Erwin
Model Naming Options (12 mins)
Naming Standards Editor (27 mins)
Import glossary from CSV file (2 mins)
Name Hardening in Detail ( 11 mins)
Naming Standards - Slides
Naming Standards - Quiz
Data type Standards
Data Type Standards - Detail (29 mins)
Data Type Standards- Brief (3 mins)
Data Type Standards - Slides
Data Type Standards - Quiz
Data Modeling Standards - Sample Documents
Data Modelling Standards- Sample Document
Data Modeling - Best Practices
Comparison of Models
Complete Compare Feature (26 mins)
Comparison of Models- slides
Complete Compare - Quiz
Querying and Report Generation
Query Tool -Detailed (8 mins)
Query Tool - Brief (4 mins)
Bulk Editor (9 mins)
Generating Diagram Pictures (5 mins)
Report Designer (12 mins)
Querying and Reporting in Erwin - Slides
Querying and Reporting in Erwin - Quiz
Validating Data Model
Validating Data Model ( 16 mins)
Validating Data Model - Slides
Validating Data Model - Quiz
Inmon Vs Kimbal Approach
Inmon Vs Kimbal Approach (11 mins)
Inmon vs Kimball Approach - Slides
Relationship and Cardinality
Relationship Types - ( 9 mins)
Cardinality and Degree - ( 32 mins)
Identifying and Non-Identifying Relationships (11 mins)
Relationship Types - Slides
Relationship and Cardinality - Quiz
Normalization Concepts
Need of Normalization ( 10 mins)
First Normalization -1NF ( 10 mins)
Second and Third Normal Forms (13 mins)
Normalization -Example ( 16 mins)
Normalization - Case Study Discussion and Quiz (15 mins)
Primary key and Other Keys (17 mins )
Foreign Keys (5 min)
Surrogate Keys (19 mins)
Case study for Normalization
Normalization- slides
Normalization - Quiz
Using Erwin Help / Data Modeling References
Using Erwin Help (3 mins)
Reference Material Information
Reference Material Future reading on DataModel (8 mins)
Dimensional Modeling Examples (11 mins)
Additional Videos
How to "Add Audit Columns" in "ERwin Tool" ( 6 mins)
How to "Add Audit Columns" using Forward Engineering Template (8 mins)
Split Model ( 3 mins)
Derive Model ( 4 mins)
Split Model and Derive Model - slides
Add Model Source( 3 mins)
Dimensional modeling features (3 mins)
Export Import Formats in Erwin( 5 mins)
Vertical Partitioning in ERwin ( 11 mins)
Demo Videos
Generating Diagrams pictures in ERwin Tool ( 5 mins)
sample
Erwin Tool Installation ( 3 mins)
sample
Data Modeling - Career Option ( 2 mins)
sample
Data Modeling Demo (25 mins)
sample
Erwin Tool Demo ( 5 mins)
sample
Data Modeling Interview Questions ( 2 mins)
sample
Designing Hive Tables in Erwin ( 6 mins)
sample
Import table metadata using api in erwin ( 5 mins)
sample
Testimonial on ERwin Training
sample
FAQ / Interview Questions
Data Modeling - Interview Questions
sample
Job Winning Data Modelling Strategies
sample
Mock Tests -Test Your Knowledge (40 Questions)
Mock Test -1
Completion rules
All units must be completed
×
Congratulations!
Course completed!
Download certificate
Continue
Go to next course
×
You didn't quite make it
Unfortunately, you didn't reach a passing score for this course
Go to course list
×
Notice
×
Notice
×
Notice