New: AI & text-to-SQL on your own SupersetBook a demo
Semantic Layer

Define metrics once. Trust them everywhere.

One source of truth for every number in the business.

Semantic layer · one definition, everywhere

Net Revenue

SUM(amount) WHERE status=paid

canonical

Churn Rate

churned_mrr / prior_mrr

canonical

Active Users (30d)

COUNT DISTINCT user_id, last 30d

canonical
01
One metric definition, everywhere
01

One metric definition, everywhere

Define a metric once in the semantic layer and it flows into every Superset chart, AI query, embedded dashboard, and API export automatically.

  • Central metric definitions in dbt or Superset virtual datasets
  • Change once, propagates to all downstream consumers instantly
  • Version-controlled metric history — see who changed what and when
02
dbt + Superset native
02

dbt + Superset native

D23 supports both dbt metrics (including dbt Cloud and dbt Core) and Superset's native virtual dataset layer — whichever fits your stack.

  • dbt metrics exposed natively in Superset Explore
  • Superset virtual datasets for teams without dbt
  • Hybrid mode: dbt for modelled metrics, Superset for ad-hoc
03
AI text-to-SQL grounding
03

AI text-to-SQL grounding

The AI generates SQL against your semantic layer, not the raw warehouse schema — so it uses correct metric logic and respects business rules.

  • AI queries routed through the semantic layer automatically
  • Metric names in plain English map to correct SQL
  • No hallucinated table names or wrong join paths

Works with your warehouse and your cloud

snowflake
bigquery
aws-color
claude-color
openai

How semantic layer works

  1. 1

    Audit your metrics

    D23 catalogs your existing dashboards and finds every divergent definition of each key metric.

  2. 2

    Define the canonical version

    Your data team and D23 agree on the correct SQL logic for each metric and encode it in the semantic layer.

  3. 3

    Deprecate the divergent datasets

    Old ad-hoc datasets are replaced with references to the semantic layer. Existing dashboards are migrated.

  4. 4

    Every tool reads the same layer

    Superset charts, AI queries, embedded analytics, and exports all query through the semantic layer — one truth.

See it in context

The board meeting discrepancy

Before

The CFO's revenue number is $2M higher than the CRO's. Both have data to back them up. The meeting derails.

With D23

Both dashboards query the canonical "Net Revenue" metric from the semantic layer. The number matches everywhere, every time.

The policy change

Before

Finance changes the revenue recognition policy. A data analyst updates 23 separate dashboards over three days. Some are missed.

With D23

The analyst updates the "Net Revenue" definition in the semantic layer once. Every dashboard and AI query reflects the change immediately.

What teams use it for

Single source of metric truth

Encode revenue, churn, LTV, and every other key metric once — and eliminate dashboard disagreements permanently.

dbt metrics integration

D23 connects your existing dbt semantic layer to Superset and the AI text-to-SQL engine with no extra work.

AI-ready schema

The semantic layer gives the AI correct table names, metric logic, and join paths — so text-to-SQL generates accurate SQL every time.

The evidence · 2025-26

The numbers behind modern BI

You don't have to take our word for it. Here's what analysts and data teams are reporting right now.

Likely ROI

Most teams cut their BI cost by half and ship dashboards in days, not quarters.

D23 estimate, based on typical data-team workloads: hours saved on Superset ops, faster dashboard delivery, and self-serve analytics that no longer requires a dedicated analyst for every question. Your mileage depends on warehouse size and how many teams need access to data.

Typical BI cost reduction~50%
Dashboard delivery timeDays, not quarters
Uptime SLA99.9%
Real-world proof · 2024

It already works at this scale

Not a demo. A team in the same kind of work, with results they published.

Nielsen logo

Nielsen

Financial Services · analytics

Reported 2024

Nielsen migrated its enterprise BI stack to Apache Superset, reducing per-seat BI licensing costs by more than 60% and enabling its data teams to ship new dashboards in days instead of weeks.

60%+

BI licensing cost reduction

days

to ship a new dashboard

1 platform

replacing multiple BI tools

Nielsen · Reported 2024

The strongest results come from teams with a connected warehouse, defined metrics, and dashboards their stakeholders actually use. That is exactly what D23 delivers.

define a metric, use it everywhere

One definition of revenue, churn, and every other metric — trusted by every team.

Try D23 for Free

Turn every team into a data team.

Get managed Apache Superset, the dashboards your business needs, and AI on top, without hiring a data team.

Get Started

Ready to give D23 a try?
Get up and running in minutes.

For Enterprises

Need a custom solution?
Reach out for consultation.