metrics-layer

Define semantic models and metrics for dbt Semantic Layer, MetricFlow, and Cube.

1|1|Updated Feb 27, 2026
One-click install
npx skills add https://github.com/nrakow/ae-skills-dev --skill metrics-layer
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: metrics-layer
Source: https://github.com/nrakow/ae-skills-dev/tree/main/skills/metrics-layer
Command: npx skills add https://github.com/nrakow/ae-skills-dev --skill metrics-layer

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

In many analytics environments, metric definitions drift across tools. This skill provides a centralized approach to define and manage metrics using dbt Semantic Layer, MetricFlow, or Cube to ensure consistency and governance across BI surfaces.

Core Features & Use Cases

  • Define semantic models and metrics that can be consumed by multiple BI tools (Tableau, Looker, Power BI) and dashboards.
  • Validate metric definitions automatically using dbt parse and MetricFlow validation, catching inconsistencies before deployment.
  • Reuse saved queries and exports (semantic_models.yml, metrics.yml) to accelerate governance and cross-team reporting.

Quick Start

Create your first semantic model and metrics using the templates, then run dbt parse and mf validate to verify them.

Frequently Asked Questions about metrics-layer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I unify KPI definitions across multiple BI tools like Tableau and Looker?

To define metrics in dbt Semantic Layer, create semantic_models.yml and metrics.yml files using established templates. Once defined, validate your metric definitions by running dbt parse and mf validate to catch inconsistencies before deployment.

What is a semantic metrics layer and when do I need one for analytics?

A semantic metrics layer is a centralized framework that defines KPIs to prevent metric drift across analytics environments. You need one when multiple BI tools or dashboards consume the same metrics and require strict governance and consistent reporting.

How do I validate metric definitions in MetricFlow before deployment?

Validate MetricFlow definitions by running mf validate alongside dbt parse. This automated validation catches inconsistencies and functional errors in your semantic models and metrics YAML files before they reach production dashboards.

Can I use Cube and dbt Semantic Layer together to manage metrics?

Yes, Cube and dbt Semantic Layer can be used together. This skill provides centralized guidance for building semantic models, metrics definitions, and saved queries across both platforms to ensure consistent KPI calculations and cross-tool governance.

Why do my KPI calculations drift between different analytics dashboards?

KPI calculations drift when metric definitions are managed independently across tools. Implementing a unified semantic layer with standardized semantic_model and metrics YAML definitions prevents this drift and ensures cross-team reporting consistency.