Illustrative specimen
Architecture decisions
CRM, billing and product events land in separate warehouse histories. An account-ID join produces a daily customer model shared by reporting, weekly LTV scoring and daily CRM audience assignments.
Constructed architecture. Hourly ingestion; daily model. 250k accounts retained for 365 days.
