Solutions / Semantic Layer

The no-code semantic layer built for analysts.

Change your model. See the impact immediately.

Adapt your model as your business changes and see the effect in your reports immediately. Complete control - from simple metrics to fully customised definitions. No code, no YAML.

“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 & OperationsOMD UK
Trusted by teams at
OMDSkySkyShowtimeFurniture VillageMacmillan Cancer SupportBarclaysMcDonald'sZenith

A semantic layer that computes, validates and orchestrates every data model change.

Define shared metrics and dimensions, build multi-level calculations, and control how your data connects—with visibility into the impact of every change.

Create a metric and put it straight to work.

Turn a source field into a shared metric, then use it immediately in a report. Define its logic once in the model, ready to reuse across your reporting.

Multiple data sources harmonised in seconds.

Combine any number of platforms into a single harmonised metric. No manual data blending, SQL transformations or database views required.

Simple calculations built on custom definitions.

Define simple calculations based on composite metrics such as total media cost and total clicks. Each metric can contain any depth of custom logic underneath, keeping the top-level formula simple. Define total media cost once, then reuse it in every calculation that needs it.

Custom dimensions. Built around your business.

Map your data to the way your business operates—its markets, brands, teams and classifications. Extend those mappings in moments as new sources arrive, and see which metrics become compatible with each dimension.

Update your model. Reports synchronise instantly.

Refine your metrics or dimension mappings and see the changes reflected across the reports that use them. Evolve and iterate your data model in seconds with modelling and reporting together in one platform.

Data Sources & Pipelines

Connect your data, wherever it lives.

Connect your existing databases and warehouses, let us collect data from your platforms, or combine both. Bring those sources into one shared model, with managed pipelines where you need them.

Need us to collect your data? We can connect your advertising, analytics and CRM platforms and bring their data into Bright Analytics, ready to model.

IntegrationsSearch integrations+CreatePaid SearchPaid SocialMeasurementProgrammaticWeb AnalyticsMMPsOrganicCRMAdobe AnalyticsAffiliate WindowAmazon AdsApple Search AdsBing AdsCampaign ManagerDV360Facebook PagesGoogle AdsGoogle Analytics - CoreGoogle Analytics - RawGoogle Search ConsoleHubspotMeta AdsSalesforceStackadaptTikTok AdsThe Trade Desk

Reporting & Visualisation

Reporting tailored to every team.

Build dashboards and explore detailed results using the metrics and dimensions defined in your model. Give teams reporting tailored to their needs, with consistent business logic underneath.

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

Reporting API

One shared model, serving all your tools.

Use your model’s metrics and dimensions in applications, integrations and workflows through the Reporting API. Keep definitions in one place as you build new ways to use your data.

POST/api/report/run
{
  "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"
}
{
  "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
    }
  ]
}

MCP Server

AI-ready data models, enriched with your context.

Connect AI tools to the same metrics and dimensions your teams use, with business context layered in to help interpret the data.

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.

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

Does an immediate reporting update mean source data is refreshed in real time?

No. Changes to your model are reflected immediately in Bright Analytics reporting. New data from advertising platforms and other sources arrives according to the refresh schedule of its pipeline. These are separate: you can validate a modelling change against the data already available.

Can Bright Analytics also collect data from advertising platforms?

Yes. We can connect your marketing platforms and set up and manage the pipelines that bring their data into Bright Analytics. You can use this alongside connections to your existing warehouses. Talk to us about the sources you need so we can scope the pipeline work.

Can we use the model in our existing tools?

The Reporting API makes modelled metrics and dimensions available to your applications and workflows. Tell us which BI tools you use so we can confirm the integration approach. Reporting API and MCP access are included in Advanced.

How do we get started?

Bring an example of your data and a reporting requirement to a demo. We can discuss the model, data connections and support you need. You can also start a free 14-day trial; Advanced includes hands-on support.

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. You can use it with your existing data infrastructure, ask us to collect and prepare your source data, or combine both. The shared model powers integrated reporting, APIs and AI.

Bring us a metric your current setup struggles with.

Show us a calculation, client-cost rule or reporting requirement. We’ll walk through how it could be modelled in Bright Analytics.