Data Warehouse

The warehouse consolidates operational exhaust into analyzable history: player events, transactions, commission ledgers, campaign data, joined and conformed.

iGaming build notes

Grain decisions (event-level bets vs aggregates) trade cost against depth; multi-brand/multi-market conformance (currencies, timezones, definitions — the recurring theme) is most of the work; regulatory splits (data-residency requirements per market) shape architecture; and access governance covers both GDPR and internal-fraud surfaces. The affiliate-program slice — click-to-commission lineage queryable end-to-end — is what turns dispute resolution and deal analysis from archaeology into SQL.