DIMENSIONAL MODELING Training

 >>  DIMENSIONAL MODELING Training

DIMENSIONAL MODELING Training


 (4.9) | 150 Ratings


Introduction


DIMENSIONAL MODELING Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 30 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course Curriculum

Dimensional modeling Online Training Course Modules

Module 1 : Relational Database Model

Topics : Review relational data Model and the importance of keys, Review the phases of Data Modeling,   different modeling diagrams and their uses, Entity Relationship Diagrams (ERD), Chen Diagrams, UML Diagrams, Normalization process in data modeling,  different data types for the physical model, views, partitioning, and summarization in physical models

Module 2 : Dimensional Data Model

Topics : The roles of Data Architect and Data Modeler, use of the Operational Data Store (ODS), structure of a Data Warehouse, the dimensional model vs. relational model, Facts, Dimensions, Measures, Additive vs Non-Additive, , Measures, Grain, Hierarchies

Module 3 : Data Marts and Subject Areas

Topics : Overview of   Data Marts, the transformation of data from source to reporting, Use of the ETL tools,   Dependent vs. independent data marts

Module 4 : Keys and Indexing

Topics :  Surrogate keys and their usage with Facts and Dimensions, natural key, indexes used with keys, best practices for surrogate keys

Module 5 : Hierarchy

Topics : Role Playing Dimensions, Conformed Dimensions, Degenerative Dimensions, Mini Dimensions, Junk Dimensions, define different Hierarchies, Balanced Hierarchy, Ragged Hierarchies, and Unbalanced Hierarchy

Module 6 : Dates and Slowly Changing Dimensions

Topics :  Significance of a Date Dimension, different date dimensions? Different slowly changing dimensions, multi-valued dimensions, different Fact tables, Transactional, Periodic snapshots, Accumulative snapshots

Exam & Certification

0

Course Review

(4.9)
5 stars
4 stars
3 stars
2 stars
1 stars

Course Curriculum

Dimensional modeling Online Training Course Modules

Module 1 : Relational Database Model

Topics : Review relational data Model and the importance of keys, Review the phases of Data Modeling,   different modeling diagrams and their uses, Entity Relationship Diagrams (ERD), Chen Diagrams, UML Diagrams, Normalization process in data modeling,  different data types for the physical model, views, partitioning, and summarization in physical models

Module 2 : Dimensional Data Model

Topics : The roles of Data Architect and Data Modeler, use of the Operational Data Store (ODS), structure of a Data Warehouse, the dimensional model vs. relational model, Facts, Dimensions, Measures, Additive vs Non-Additive, , Measures, Grain, Hierarchies

Module 3 : Data Marts and Subject Areas

Topics : Overview of   Data Marts, the transformation of data from source to reporting, Use of the ETL tools,   Dependent vs. independent data marts

Module 4 : Keys and Indexing

Topics :  Surrogate keys and their usage with Facts and Dimensions, natural key, indexes used with keys, best practices for surrogate keys

Module 5 : Hierarchy

Topics : Role Playing Dimensions, Conformed Dimensions, Degenerative Dimensions, Mini Dimensions, Junk Dimensions, define different Hierarchies, Balanced Hierarchy, Ragged Hierarchies, and Unbalanced Hierarchy

Module 6 : Dates and Slowly Changing Dimensions

Topics :  Significance of a Date Dimension, different date dimensions? Different slowly changing dimensions, multi-valued dimensions, different Fact tables, Transactional, Periodic snapshots, Accumulative snapshots

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry