DataLane

All stacks · Serving & BI

BI & semantic layer

Looker, Tableau, Power BI, Superset, and the metrics layer.

BI & semantic layer cover

Related reading

About BI & semantic layer

Looker, Tableau, Power BI, Superset, and a semantic / metrics layer are how the warehouse earns its keep. The DE job is grain, certified datasets, and not letting every analyst SELECT * a 12-billion-row fact.

LookML, DAX, and published datasets are contracts. If the metric lives in three workbooks, you do not have a metric — you have an argument.

What you'll learn here

  • Semantic layers: LookML, MetricFlow, Power BI datasets, and Cube
  • Extract vs live query and who pays the warehouse
  • Row-level security that matches warehouse RBAC
  • Why “we will fix it in Tableau” is a modeling failure

Frequently asked questions

Which BI tool should we pick?

The one your org already pays for, unless it cannot do governed metrics. Looker if you want a Git-shaped semantic layer. Power BI if you are Microsoft/Fabric. Tableau if visual analysis is the culture. Superset if you want open-source and will staff it.

Does a semantic layer replace dbt?

No. dbt builds tested tables. The semantic layer defines metrics on top. Both, or you will redefine revenue in YAML and SQL forever.

Why is the dashboard wrong but the SQL is right?

Extract lag, a filter on the wrong grain, or a join in the workbook. Replicate the number in the warehouse first. If it matches, the BI layer is the bug.

New BI & semantic layer posts, straight to your inbox

One email a week with our latest tutorials. No spam.

Newsletter signup is not live yet. Use the contact form if you want to be notified.

↑↓ navigate openesc close