Looker — BI Platform with LookML Modeling Layer

Looker is a BI platform with a unique LookML layer. Centralized metric definitions ensure consistent analytics across the entire organization.

Looker — BI with a Modeling Layer¶

LookML — a declarative language for the data model. Define metrics once, use everywhere.

# Looker — BI Platform with LookML Modeling Layer
view: orders {
  sql_table_name: analytics.fct_orders ;;

  dimension: order_id {
    type: number
    primary_key: yes
  }

  measure: total_revenue {
    type: sum
    sql: ${TABLE}.total_czk ;;
    value_format: "#,##0 Kč"
  }

  measure: average_order_value {
    type: average
    sql: ${TABLE}.total_czk ;;
  }
}

Advantages¶

• Single source of truth — one metric definition
• Git-based — LookML versioned in Git
• API-first — programmatic access
• Governance — centralized control

Summary¶

Looker is for organizations that need centralized metric definitions. LookML ensures consistent numbers.