DWH

CAP-Theorem

Availability (CAP-Theorem)

Partition tolerance (CAP-Theorem)

Consistency (CAP-Theorem)

Is eventual consistency ok?

New Data related trends

New Data Sources

(Near) real-time ETL

Self-service BI & data discovery

Information Needs Analysis (Components)

Requested information

Information supply

Objective Information need

subjective Information need

Operational Objectives & Business Strategy

DWH Definition Inmon

Data mart

Disadvantages of Data marts

Design principles

Design principle Examples for each step

Designing the multidimensional model (Process)

Logical data modeling Schema /
Generic DWH schema

Advantages Snowflake-schema

Disadvantages snowflake-schema

Advantages Star Schema

Disadvantages Star-Schema

Ways to handle slowly changing dimensions