Study planner
Data modeling tracker
Star and snowflake schemas, facts and dimensions, SCD types 0–6, Kimball, Inmon and Data Vault. 42 topics. Open a topic to study it, then tick your progress.
Data modeling studied0 of 42
Studied, Practised, Revised and a confidence score (1–5) for each topic, as in the planner spreadsheet. A topic counts as complete once it is marked studied.
Saved in this browser only. Back it up from the study planner page.
| # | Topic | Category | Level | Studied | Practised | Revised | Confidence |
|---|---|---|---|---|---|---|---|
| 1 | Star Schema | Schema Design | Beginner | ||||
| 2 | Snowflake Schema | Schema Design | Beginner | ||||
| 3 | Galaxy / Fact Constellation | Schema Design | Beginner | ||||
| 4 | Grain definition | Schema Design | Advanced | ||||
| 5 | Normalization (1NF-3NF/BCNF) | Schema Design | Intermediate | ||||
| 6 | Denormalization trade-offs | Schema Design | Intermediate | ||||
| 7 | Dimensional vs wide tables | Modern Practice | Beginner | ||||
| 8 | One Big Table (OBT) | Methodologies | Advanced | ||||
| 9 | Fact tables | Facts & Dimensions | Beginner | ||||
| 10 | Additive/semi-additive/non-additive measures | Facts & Dimensions | Advanced | ||||
| 11 | Transaction vs periodic snapshot vs accumulating snapshot | Facts & Dimensions | Advanced | ||||
| 12 | Factless fact tables | Facts & Dimensions | Intermediate | ||||
| 13 | Slowly changing facts | Modern Practice | Beginner | ||||
| 14 | Late arriving facts | Modern Practice | Intermediate | ||||
| 15 | Dimension tables | Facts & Dimensions | Beginner | ||||
| 16 | Surrogate keys | Facts & Dimensions | Expert | ||||
| 17 | Natural vs surrogate keys | Facts & Dimensions | Expert | ||||
| 18 | Conformed dimensions | Schema Design | Advanced | ||||
| 19 | Degenerate dimensions | Schema Design | Advanced | ||||
| 20 | Junk dimensions | Schema Design | Expert | ||||
| 21 | Role-playing dimensions | Schema Design | Expert | ||||
| 22 | Late arriving dimensions | Modern Practice | Beginner | ||||
| 23 | Bridge tables | Facts & Dimensions | Intermediate | ||||
| 24 | Handling many-to-many | Modern Practice | Intermediate | ||||
| 25 | Hierarchies (fixed/ragged) | Modern Practice | Advanced | ||||
| 26 | SCD Type 0 | SCD | Beginner | ||||
| 27 | SCD Type 1 (overwrite) | SCD | Beginner | ||||
| 28 | SCD Type 2 (history) | SCD | Intermediate | ||||
| 29 | SCD Type 3 (limited history) | SCD | Intermediate | ||||
| 30 | SCD Type 4 (history table) | SCD | Advanced | ||||
| 31 | SCD Type 5 | SCD | Advanced | ||||
| 32 | SCD Type 6 (hybrid 1+2+3) | SCD | Expert | ||||
| 33 | Kimball dimensional modeling | Methodologies | Beginner | ||||
| 34 | Inmon (3NF/CIF) | Methodologies | Beginner | ||||
| 35 | Data Vault 2.0 (Hubs/Links/Satellites) | Methodologies | Intermediate | ||||
| 36 | Anchor Modeling | Methodologies | Intermediate | ||||
| 37 | Medallion architecture (bronze/silver/gold) | Methodologies | Advanced | ||||
| 38 | Activity Schema / event modeling | Methodologies | Expert | ||||
| 39 | Data modeling for streaming | Modern Practice | Advanced | ||||
| 40 | Semantic layer / metrics layer | Modern Practice | Advanced | ||||
| 41 | Modeling in dbt | Modern Practice | Expert | ||||
| 42 | Idempotent incremental models | Modern Practice | Expert |
No topics match these filters
Clear a filter to see more topics.