Advanced data modeling

The dbt Semantic Layer and MetricFlow are powerful tools that allow you to define metrics and semantic models in your dbt project.

This section covers advanced topics for the dbt Semantic Layer and MetricFlow, such as data modeling workflows, and more.

Fill null values for metrics

Use fill_nulls_with to set null metric values to zero, ensuring numeric values for every data row.

Metrics as dimensions with metric filters

Add metrics as dimensions to your metric filters to create more complex metrics and gain more insights.