#modeling
Posts tagged with #modeling.
Modeling & metricsDerived metrics without double counting
Derived metrics compose other metrics, not raw columns — get the expansion order wrong and a ratio silently double-counts. Here's how datahashi keeps composition honest.
Modeling & metricsEntities and relationships in the semantic model
Metrics sit on entities. Relationships tell the layer how to join without letting every consumer reinvent the graph.
Modeling & metricsAdditive vs non-additive metrics
Why some metrics can be summed across dimensions and time, and why others must never be.
Modeling & metricsFan-out-safe metrics explained
What fan-out risk looks like in metric queries and how to keep aggregates correct.
Modeling & metricsDimensions that do not explode joins
How to model dimensions so metric grain stays correct and joins do not multiply rows.
Modeling & metricsYour first metric: name it, do not hand-write SQL
Walk through defining a first certified metric by name and measure without pasting hand-written SQL into the agent path.
Modeling & metrics