3. Gold Layer : Aggregate KPIs for Executives - RogerThattt/SAP-Retail-Data-Databricks GitHub Wiki

  1. Gold Layer (Planned): Aggregate KPIs for Executives πŸ† Objective: Derive high-value, business-facing metrics such as:

Revenue by Store / Week

Sales by Category / Region

Conversion Funnel per Campaign

πŸ’‘ Gold Table Sample Code: python Copy Edit @dlt.table(name="store_weekly_revenue") def gold_kpis(): df = dlt.read("validated_pos_transactions") return ( df.groupBy("store_id", "week_of_year") .agg(sum("total_amount").alias("weekly_revenue")) ) Gold Layer practices:

Materialized aggregates

Slowly Changing Dimensions (Type 2) for temporal logic

GenAI Prompt Features (e.g., β€œWhich stores underperformed last week?”) via semantically tagged metrics