Solutions / Semantic Layer

The no-code semantic layer built for analysts.

Put your analysts in control of your data modelling.

Our no-code interface lets your analysts build a shared, governed data model that powers our BI layer, Reporting API and MCP server. Your data stays in your warehouse. Bright Analytics sits on top. All teams and tools work from the same shared definitions.

Free trialBook a demoSee pricing
“Bright Analytics have been instrumental in helping us to create bespoke, world class reporting and analytics frameworks for some of our largest and most complex clients.”
Steve PeacockHead of Digital Trading & Operations, OMD UK

Connect the data you already have.

Bring your existing databases and warehouses into Bright Analytics. Build a shared model around the data your business already holds, with connections managed in one place.

Data HostsConnect your databases to Bright Analytics.Connect toMySQLConnect toGoogle BigQueryConnect toSnowflakeConnect toAzure SQLConnect toDatabricksActive Connections (2)TechnologyNameEndpointDatabaseStatusRDSBA Mainbrightanalytics.abc.eu-west-1.rds.amazon.comdemo_dataConnectedBigQueryBA BigQuery SalesN/Aba_salesConnected

Put your analysts in charge of the model.

Business knowledge belongs in your data model. Let your analysts define reusable metrics, map dimensions across sources and refine the logic as your reporting needs evolve.

Define your metrics once and re-use them in other metrics. A governed set of definitions behind every dashboard, API call, and AI query.

Total Media CostPermissionsGeneralSettingsChangelogUsage in reportsRelated componentsDimension CompatibilityNAMETotal Media CostBA REFcore.total_media_costINFOTotal Media Cost : Meta + Google Ads + DV360 + TikTokPublishedDefinitions+Definition from template+Custom DefinitionDeleteDeactivateEdit formulaMedia Cost [Meta]+Spend [Google Ads]+Media Cost [DV360]+Media Cost [TikTok]

Your teams own their reporting.

Give teams the freedom to build dashboards and reports around their questions, using the metrics and dimensions your analysts have defined.

Build dashboards in minutes and share them with your team. Set access levels, use interactive filters, apply drill-downs and add commentary.

Bright Analytics dashboard

Take your model into your own tools.

Use the Reporting API to bring governed metrics and dimensions into your applications and workflows. Keep the business logic in one model as you build new ways to use the data.

POST/api/report/run
Request body
{
  "metrics": ["core_spend", "core_clicks", "core_sales"],
  "dimensions": ["core_channel"],
  "filters": [
    {
      "dimension": "core_channel",
      "type": "in",
      "values": ["Paid Search", "Paid Social", "Display"]
    }
  ],
  "start": "2026-05-01",
  "end": "2026-05-14"
}
Response
{
  "data": [
    {
      "core_channel": "Paid Search",
      "core_spend": 42850.25,
      "core_clicks": 18420,
      "core_sales": 1206
    },
    {
      "core_channel": "Paid Social",
      "core_spend": 31200.18,
      "core_clicks": 24990,
      "core_sales": 892
    },
    {
      "core_channel": "Display",
      "core_spend": 12400.74,
      "core_clicks": 9310,
      "core_sales": 214
    }
  ]
}

Give AI the same definitions as your analysts.

Connect AI to your shared model so its queries use the same metrics and dimensions as your dashboards and reports.

What was our cost per registration by market last month?
Bright Analytics MCP

Here's the breakdown for April 2026:

MarketMedia CostRegistrationsCPR
UK£74,0501,001£73.98
DE€41,200587€70.19
US$98,3001,843$53.33

UK cost per registration is up 12% vs March. Germany is stable. US improved by 8%.

Why did UK get more expensive?
Bright Analytics MCP

Paid Social CPR in UK rose 31% in April. Meta CPMs increased 18% while conversion rate dropped 9%. Google Ads held steady.

Pricing

Start with one data host and reporting. Advanced unlocks cross-data warehouse modelling: one unified semantic layer across any number of data warehouses and clouds, accessible through reports, the Reporting API and the MCP server.

Starter

£500/ month

Model your data and put it to work in live dashboards.

Free trial
  • Semantic layer
  • Reporting
  • 1 admin user
  • 5 reporting users
  • 1 data host
  • Custom data model
  • Unlimited dashboards
  • Live-chat support

Advanced

from£1,500/ month

Unify your data warehouses and clouds in one semantic layer.

Book a demo
  • Semantic layer
  • Reporting
  • AI
  • API
  • 3 admin users
  • 10 reporting users
  • Multiple data hosts
  • Cross-warehouse data modelling
  • Reporting API
  • MCP Server
  • Hands-on support

Questions

Can we connect our existing data warehouse?

Yes. Connect your existing databases and warehouses through Data Hosts, including BigQuery, Snowflake, Databricks, MySQL and Azure SQL.

Who builds and maintains the model?

Your analysts define and refine the metrics and dimensions, bringing their knowledge of your business into the model. Bright Analytics supports your team as the model evolves.

What happens when a metric definition changes?

The updated definition is shared across dashboards, reports, API requests and AI queries. Teams can evolve their reporting while keeping the underlying business logic consistent.

How does this relate to the Marketing Analytics Platform?

The Semantic Layer is the modelling foundation of the Marketing Analytics Platform. This solution focuses on connecting your existing data infrastructure and making a shared model available to reporting, APIs and AI.

Put your analysts at the heart of your data model.

Start a free 14-day trial, or talk to us about your data infrastructure, metrics and reporting needs.

Free trialBook a demo