How it works Skills Methodology Pricing Sign In / Up

← All patterns

Pattern

Dimensional modeling

4 problemsin this pattern, climbing easy → medium → hard. Pick wherever you're calibrated.

MD

Medium

0 / 2 solved

Flatten the order model into a line-grain report
SQL · ~10 min
NEW
Find dimension members with no facts
SQL · ~8 min
NEW

HD

Hard

0 / 2 solved

Build a customer dimension with lifetime measures
SQL · ~16 min
NEW
Assign customers to a revenue band via a lookup table
SQL · ~14 min
NEW