SQL pattern · 5 problems

Dimensional modeling

Graded problems on dimensional modeling, from easy to hard.

5 problems · about 1 h 10 min in all

Start with problem 01Flatten the order model into a line-grain report · 10 min

Easy

1 problem · about 10 min

01Flatten the order model into a line-grain report10 min →

Medium

1 problem · about 14 min

02Conformance check: products vs order lines14 min →

Hard

3 problems · about 50 min

03Build a customer dimension with lifetime measures16 min →04Assign customers to a revenue band14 min →05Build an accumulating-snapshot fact for the order lifecycle20 min →