Data Modeling
Designing an event schema you will not regret. Naming conventions, property design, avoiding the analytics debt that accumulates when events are added ad hoc, and structuring data so that tomorrow's questions remain answerable.
5 guides on data modeling.
Implementing Data Retention Without Breaking Your Reports
GDPR wants a retention limit; your year-over-year chart wants history. Pre-aggregating before deletion, per-site policies, and the sweep that enforces them without locking the table.
Designing a Custom Dashboard Builder
Letting users arrange their own widgets means a layout model, a widget registry and a migration story. What to store, what to compute, and why saved layouts need versioning from day one.
Privacy-First Database Design for Analytics
How to design an analytics schema that cannot leak personal data — pseudonymous IDs, salt rotation, aggregation at write time, retention windows, and deletion by design.
Event Schema Design: Naming, Properties, and Avoiding Analytics Debt
How to design an analytics event taxonomy that survives three years — naming conventions, property design, versioning, and the anti-patterns that make data unqueryable.
Designing a Star Schema for Web Analytics Data
How to model pageviews, sessions, and events as facts and dimensions — grain, surrogate keys, slowly changing dimensions, and where to denormalize for a columnar engine.