Skip to content
Yash Singh Ramgadiya

Project overview

Organisation
Burda Luxury, Asia Pacific

Semantic-Layer Governance & Data Contracts

KPI definitions, semantic models, metric governance, data contracts and source-specific transformation standards that keep executive reporting consistent across 22+ transformation layers and approximately 45 semantic models.

22+governed transformation layers

Metric GovernanceData ContractsSemantic Layer

Context

With many brands, markets and sources, the same KPI can be defined differently in every dashboard unless definitions are governed centrally.

Scope

  • KPI definitions and metric governance
  • Semantic models
  • Data contracts
  • Source-specific transformation standards
  • Executive reporting consistency

Approach

Create a governed measurement layer that separates business definitions from individual dashboards and analyses. Definitions live once in the semantic layer; transformation layers follow source-specific standards; data contracts make the expectations between layers explicit.

Purpose

  • Consistent metric definitions across 22+ transformation layers and approximately 45 semantic models.
  • Executive reporting that reconciles across brands and markets.
  • A governed foundation for self-service and AI-enabled analytics.

Technology

  • dbt
  • Cube.js
  • SQL