BI Modeling in a nutshell

Kurs Inhalt

Alle erweitern

Introduction to BI modeling in a nutshell 1 Thema

Lektion Inhalt

0% Vollständig 0/1-Stufen

Modeling What Matters: A Business-First Approach to BI

Module 1: Entity Relationship Modeling 6 Module

Lektion Inhalt

0% Vollständig 0/6-Stufen

Introduction to Module 1: Entity Relationshop Modeling

Concept of Data Models

ER Model Components

Notation Forms and Extended Constructs

Summary of Module 1: Entity Relationship Modeling

Module 2: Multidimensional Data Structures 7 Module

Lektion Inhalt

0% Vollständig 0/7-Stufen

Introduction to Module 2: Multidimensional Data Structures

Structural Components of Multidimensional Data Structures

Key Figures (Metrics)

Key Figure Systems and Dimensions

Design Rules and Semantic Modeling

Summary of Module 2: Multidimensional Data Structures

Module 3: Star Schema for Multidimensional Data 10 Module

Lektion Inhalt

0% Vollständig 0/10-Stufen

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 Module

Lektion Inhalt

0% Vollständig 0/7-Stufen

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 Module

Lektion Inhalt

0% Vollständig 0/11-Stufen

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 Module

Lektion Inhalt

0% Vollständig 0/2-Stufen

From Business Process to Scalable Data Models

Bridging Business Needs and Data Modeling

Angetrieben von DigiMember

Deutsch (Schweiz)