Dimensional Modeling Video Tutorial

  • Draw-io Free Design Tool -Conceptual Model Purpose (Erwin Al... 
    • 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
Close
×

Congratulations!

Course completed!

Course completed!

Download certificate

Continue

Go to next course

×

You didn't quite make it

You didn't quite make it

Unfortunately, you didn't reach a passing score for this course

Go to course list

×

Notice

 Delete  Delete, don't keep asking Cancel
×

Notice

 Delete Cancel
×

Notice

 Discard changes Cancel