Introduction to Data Modeling
Enroll in our Data Modeling course to learn the pillars of effective data modeling. Explore transactional systems and dimensional modeling. Create robust data models to bolster operations and enable analytical insights through BI.
- Course Info
- Instructor
- System Requirements
- What to know beforehand
Course Description
Course Outline ( Free Preview)
Data Modeling - What do you need to get started
Module 01 - Course Introduction
Module 02A - Modeling Methodologies (Transactional Model)
Module 02B - Modeling Methodologies (Dimensional Model) 19 min.
Module 03 - Transactional Model Design 18 min.
Module 04 - Dimensional Model Design 16 min.
Module 05A - Defining the Business Process (Planning a Project) 25 min.
Module 05B - Defining the Business Process (Declaring the Grain) 24 min.
Module 06A - Dimension Design (Dimension Types) 36 min.
Module 06B - Dimension Design (Conformed Dimensions) 14 min.
Module 06C - Dimension Design (Junk Dimensions) 9 min.
Module 06D - Dimension Design (Degenerate Dimensions) 7 min.
Module 06E - Dimension Design (Role Playing Dimensions) 9 min.
Module 06F - Dimension Design (Creating Dimensions) 12 min.
Module 06G - Dimension Design (Creating a Customer Dimension) 21 min.
Module 07A - Fact Design (Transaction Facts) 20 min.
Module 07B - Fact Design (Periodic Snapshot) 14 min.
Module 07C - Fact Design (Accumulating Snapshot) 7 min.
Module 08A - Relationships (Overview) 24 min.
Module 08B - Relationships (Many to Many - Double Counting) 14 min.
Module 08C - Relationships (Hierarchy and Parent-Child) 9 min.
Module 09A - Advanced Data Modeling Techniques (Overview) 21 min.
Module 09B - Advanced Data Modeling Techniques (Allocated Facts) 12 min.
Module 09C - Advanced Data Modeling Techniques (Other Dimensions) 14 min.
Module 10A - Designing for Business Intelligence (ETL Considerations) 17 min.
Module 10B - Designing for Business Intelligence (SSAS Consideration) 7 min.
This course includes:
- 6+ hours of training
- 26 Modules
- * Access on mobile and browser
- Certificate of Completion