MongoDB document design, Redis data structures, Neo4j graph patterns — when to abandon relational models and the trade-offs that come with each alternative.
MongoDB document design, Redis data structures, Neo4j graph patterns — when to abandon relational models and the trade-offs that come with each alternative.
Day 3 of Data Modeling in 5 Days is the midpoint — and often the most rewarding day. The pieces from Day 1 and Day 2 start connecting. Most students have an 'it clicks' moment on Day 3.
Understanding star schema is the core goal of Day 3. The concept is straightforward once you see it in practice — most confusion comes from skipping the mental model and jumping straight to implementation. Start with the model, then write the code.
# star schema — Working Example
# Study this pattern carefully before writing your own version
class starschemaExample:
"""
Demonstrates core star schema concepts.
Replace placeholder values with your real implementation.
"""
def __init__(self, config: dict):
self.config = config
self._validate()
def _validate(self):
required = ['name', 'type']
for field in required:
if field not in self.config:
raise ValueError(f"Missing required field: {field}")
def process(self) -> dict:
# Core logic goes here
result = {
'status': 'success',
'topic': 'star schema',
'data': self.config
}
return result
# Usage
example = starschemaExample({
'name': 'my-implementation',
'type': 'star schema'
})
output = example.process()
print(output)
facts is the practical application of star schema in real projects. Once you understand the underlying model, facts becomes the natural next step.
SCDs rounds out today's lesson. It connects star schema and facts into a complete picture. You'll use all three concepts together in the exercise below.
Extend today's exercise by adding one feature that wasn't in the instructions. Document what you built in a comment at the top of the file. This habit of going one step further is what separates engineers who grow fast from those who stay stuck.
The foundations from today carry directly into Day 4. In the next session the focus shifts to dbt and the Modern Data Stack — building directly on everything covered here.
Before moving on, verify you can answer these without looking:
Live Bootcamp
Learn this in person — 2 days, 5 cities
Thu–Fri sessions in Denver, Los Angeles, New York, Chicago, and Dallas. $1,490 per seat. June–October 2026.
Reserve Your Seat →