Omni raises $69M in Series B funding 🥳 | Learn more

The only data model that doesn’t slow you down

Start exploring data instantly and build reusable, trustworthy metrics as you go.

Free Trial
A code snippet in the Omni IDE
A form to create new field from the UI in the workbook
A data table column with the option to promote it to the workbook
Census
Condé Nast
Perplexity
Ilia
Ritual
Incident.io
Zip
Hightouch
Prefect
Tickpick
Game lounge
AACSB
Lyka
Front
Dagster

See how Omni’s data model helps you move faster

Move fast, build trust

Get the speed of self-service with the governance of a data model.

Uniquely flexible architecture

With Omni, you can build your data model as you do analysis — so there’s no need to model everything upfront. Define and iterate on metrics, promote useful pieces to your organization's data model, and then repeat with more analysis.

This is made possible by our multi-layered architecture, reflecting the:

  • Database: Raw data and dbt models
  • Shared data model: Metrics and definitions relevant to the entire team
  • Workbook environment: Ad-hoc iterations for specific analyses
A diagram showing the layers of the omni data model.

Quick, collaborative modeling

Omni’s point-and-click UI, Excel functions, and AI agent enable anyone to explore data and develop metrics within self-contained workbooks. Your finance team can define key metrics like ARR and Profit once, directly within Omni’s UI. Then, the data team can easily review and promote reusable metrics to the shared model, allowing everyone to benefit from trustworthy definitions.

An table of data with a profit column. The users is selecting the promote to workbook option from the menu of options for that column

Streamlined dbt and data engineering workflows

Our bi-directional dbt integration makes it easy to view your dbt metadata, create and edit models within Omni, and keep your dbt and BI environments operating in lockstep. Built-in software development lifecycle controls like branching and our git integration help you manage your data model and safely deploy changes without having to worry about breaking reports or dashboards.

Analyze first, model later

Omni’s layered data model, flexible UI, and dbt integration enable a new data modeling workflow: just-in-time data modeling. Modeling as you’re doing analysis gives you the flexibility you need for early explorations and working with rapidly changing data, making it possible to measure the impact of a new product feature or diagnose a sudden spike in returns.

With just-in-time data modeling, anyone with the right permissions can quickly analyze data → promote what’s valuable into your data model → build more analysis on top → rinse and repeat.

A diagram showing taking a column from the result set, promoting it to the workbook, and then making a new aggregation from the promoted column.

Create scalable systems with extends, aggregate awareness, and more

Advanced modeling features enable data teams to create performant, secure data environments that scale.

  • Security controls for rows, columns, and fields make any permission structure possible
  • Dynamic schemas let you query data across separate but identical schemas
  • Extends facilitates a hub-and-spoke data model across teams, products, or customers
  • Aggregate awareness dynamically queries roll-up tables to optimize performance
  • Templated filters inject dynamic text into a SQL query, allowing you to parametrize fields and views
A view of the omni data model highlight various features
We want to own our business logic, so the dbt <> git workflow works well for us. None of the other vendors seemed to offer that flexibility, but Omni’s bi-directional dbt integration really stood out to us as something that aligned with our philosophy. Beyond technical alignment, Omni seemed like the right partner as a company; it was by far the best sales experience I’ve had. I believe in the future with Omni.Joe Horowitz, VP of Growth & Analytics

Related resources