Normalized + Star Model
Take one business process you know, such as food delivery orders, and model it twice: a normalized OLTP schema and a star schema with one fact table. Write the fact table's grain in one sentence before adding any columns.
- Data Modeling
- SQL
- Data Warehousing
Be ready to explain: Why each dimension sits where it does, and one query that is simpler on the star schema.