Mirlan Dzhumagulov
← All work

Kimball data architecture for mobile games

From raw sources to data marts and BI cubes for game metrics.

Architecture diagram: Kimball data architecture for mobile games
  1. ELT pipeline design in GCP (Dataform, schedulers, Cloud Functions)
  2. Data integration from APIs, S3 buckets, Firebase and BigQuery
  3. Master data table design
  4. Data mart design
  5. OLAP cubes for BI tools (Tableau, Metabase)
    • Metrics: retention, churn, level progress, installs, DAU, sessions, traffic source, ROAS
    • Cohorts: install date, ad campaign, country, device, depositors

Need something similar? mirlan@dataengineer.fi

Next: dbt vs SQLMesh: scheduled model runs on GCP →