06 / 06Data

Data in one place

Data from several platforms lives in one store that feeds the BI dashboards, pages generated from the data, the ad platforms and the team's AI assistants.

Status

In production

Built with

Data warehouse, dbt, MCP

Feeds

Dashboards, programmatic SEO, ads, AI assistants

Before

The company's data was spread across several platforms. Making a decision meant pulling it all together first.

What we built

A data warehouse, the central store that brings together the data from all those platforms. The transformations live in dbt, as code. The warehouse feeds BI dashboards and pages generated automatically from the data (programmatic SEO), connects to ad platforms, and through an MCP server lets AI assistants query the same data.

What changed

The data lives in one place. The dashboards, the pages and the AI assistants all read from the same store instead of several separate platforms.

Today

Running in production.