Skip to content
CDMP trainings
Presence seminars
Online seminars
TDWI trainings
Video courses
Online congress
Publications
CDMP trainings
Presence seminars
Online seminars
TDWI trainings
Video courses
Online congress
Publications
Contact us
BI Modeling in a nutshell
Course Content
Expand All
Introduction to BI modeling in a nutshell
1 Topic
Expand
Lesson Content
0% Complete
0/1 Steps
Modeling What Matters: A Business-First Approach to BI
Module 1: Entity Relationship Modeling
6 Topics
Expand
Lesson Content
0% Complete
0/6 Steps
Introduction to Module 1: Entity Relationshop Modeling
Concept of Data Models
ER Model Components
Cardinalities
Notation Forms and Extended Constructs
Summary of Module 1: Entity Relationship Modeling
Module 2: Multidimensional Data Structures
7 Topics
Expand
Lesson Content
0% Complete
0/7 Steps
Introduction to Module 2: Multidimensional Data Structures
Structural Components of Multidimensional Data Structures
Key Figures (Metrics)
Key Figure Systems and Dimensions
Hierarchies
Design Rules and Semantic Modeling
Summary of Module 2: Multidimensional Data Structures
Module 3: Star Schema for Multidimensional Data
10 Topics
Expand
Lesson Content
0% Complete
0/10 Steps
Introduction to Module 3: Star Schema for Multidimensional Data
Star Schema Fundamentals
Keys and Queries in the Star Schema
Hierarchies and Attributes in the Star Schema
Measures in Star Schema
Fact Constellation Schema
Normalization in dimensions
Snowflake Schema
Additivity of measures
Summary of Module 3: Star Schema for Multidimensional Data
Module 4: Historization with Star Schema
7 Topics
Expand
Lesson Content
0% Complete
0/7 Steps
Introduction to Module 4: Historization with Star Schema
Historization in the Star Schema
As-is, as-of, and as-posted
Solution options
Master Data Historization
Transactional Historization
Summary of Module 4: Historization with Star Schema
Module 5: Core Data Warehouse Modeling
11 Topics
Expand
Lesson Content
0% Complete
0/11 Steps
Introduction to Module 5: Core Data Warehouse Modeling
Business Intelligence architectures
Layered Data Flow
Choosing Modeling Methods
Historization in the 3NF model
Data Vault: Hubs, Sats, Links
Handling Change in Data Vault
Data Vault Historization
Hybrid Models (DV + 3NF)
Best Practices in DWH Modeling
Summary of Module 5: Core Data Warehouse Modeling
Summary of BI modeling in a nutshell
2 Topics
Expand
Lesson Content
0% Complete
0/2 Steps
From Business Process to Scalable Data Models
Bridging Business Needs and Data Modeling
English
Deutsch
Deutsch (Schweiz)
Deutsch (Österreich)
Español
English
English 
Deutsch 
Deutsch (Schweiz) 
Deutsch (Österreich) 
Español