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

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.

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.

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