Data EngineeringJudging
Model a warehouse analysts won't hate
A team writes the same 200-line query every week. Design the star schema that ends that.
- Time needed
- 5 days
- Sources
- 5 tables
The brief
A dimensional modelling challenge judged by usability, not elegance. You get the source schema and three real analyst questions that currently take a 200-line query each. Your star schema wins if those questions become short, obvious queries — and if the grain of every table is unambiguous.
What you submit
- A star schema with documented grain for every table
- The transformation SQL or dbt models that build it
- The three analyst questions rewritten against your model
How to participate
- Register free: create your account and tell us a little about yourself.
- Download the source schema and the three questions.
- Model it, build it, and rewrite the queries.
- Submit; mentors judge how short the new queries got.
How it’s judged
- Unambiguous grain
- Query simplicity after modelling
- Documentation
What you walk away with
Feedback for every entry · Top 3 win up to 50% off a flagship seat
Resources
Everything you need, in one zipThe dataset, the full brief and the guides for this challenge.Register free to unlock