Category: Calculations
-
Winners, Losers, and the Trade Game

A visual history of MLB trades and their ripple effects. In every MLB season, team trade activity revolves around one key date — the official trade deadline at the end of July. For those less familiar with baseball, trades serve many purposes beyond just swapping players. Like any professional sport, baseball is a business, and…
-
Breakdown: Level of Detail (LOD) Calculations

Foundation of a LOD calculation Just like a SQL query, there are specific ‘keywords’ to a LOD calculation. In SQL, you have a select statement, from statement and may also have a variation of other keywords to query specific cohorts of data. Let’s look the keywords needed to create a LOD calc: Example of a…