Data modeling challenges
Practice the data modeling decisions real schema design turns on: grain, keys, history, and trade-offs. Read the scenario, requirements, and workload context for free. Progress and submissions need an account.
| Type | ||||
|---|---|---|---|---|
| Pick an SCD pattern Slowly changing dimensions: Type 2 | Slowly changing dimensions: Type 2 | Easy | Quick decision | 5m |
| Price history with SCD2 Slowly changing dimensions: Type 2 | Slowly changing dimensions: Type 2 | Medium | Concept challenge | 20m |
| Campaign enrollment bridge Many-to-Many Modeling | Many-to-Many Modeling | Medium | Concept challenge | 20m |
| Degenerate dimensions Degenerate Dimensions | Degenerate Dimensions | Medium | Concept challenge | 20m |
| Daily balance snapshots Fact Table Grain | Fact Table Grain | Medium | Concept challenge | 20m |
| Conform customer across facts Conformed Dimensions | Conformed Dimensions | Hard | Concept challenge | 25m |
| Subscriber health model Fact vs Dimension Roles | Fact vs Dimension Roles | Hard | Open scenario | 30m |
| Fact type: order-line revenue Fact Table Grain | Fact Table Grain | Easy | Quick decision | 5m |
| Fact type: daily inventory Fact Table Grain | Fact Table Grain | Easy | Quick decision | 5m |
| Fact type: claim lifecycle Fact Table Grain | Fact Table Grain | Easy | Quick decision | 5m |
| Claim lifecycle snapshot Fact Table Grain | Fact Table Grain | Medium | Concept challenge | 25m |
| Inventory: movement vs snapshot Fact Table Grain | Fact Table Grain | Medium | Concept challenge | 30m |
1-12 of 72