Give your entire team the ability to view, analyze, and securely share data in the way that works best for them.
Explore data easily
Build data models in SQL or interactively as you query. Explore data easily with our point-and-click UI and spreadsheet-style formulas.
Build beautiful visualizations
Clearly communicate the metrics that matter to your business using out-of-the-box visualizations or easily customizing your own.
Rapidly share findings
Securely share content via URL, scheduled reports, or embedded into your line of business apps so everyone can access and act on data within their preferred workflow.
With Omni, our data team now focuses on new projects, while business
users make faster decisions. This efficiency is crucial for
sustainable business operations.— Ari Stern, Staff Analytics Engineer
You don't have to choose between the flexibility of workbooks and the governance of enterprise BI. Have it all — without the enterprise price tag.
Flexible
Fast time-to-value
Simple ad hoc analysis
Easy data integrations
Democratized access
Omni Analytics
Governed
Reliable, curated metrics
Clear permissions
Centralized management
Operational workflows
Omni balances the best of Looker's code-based modeling layer approach
with the best of Tableau's self-service workbooks — empowering a wider
variety of users to explore and consume without falling into the
pitfall of complexity creep.— Martin Zerbib, Head of Product
Omni's data model allows for reusability, governance, and performance optimization as you query, so you can focus on answering your questions.
Explore data your way
Connected workbooks
Workbooks combine the simplicity of a point-and-click UI with the flexibility of spreadsheets. Explore modeled or un-modeled data within your sandbox environment, and when you discover something interesting, promote it to your teams shared data model for reuse and governance.
Spreadsheet-style formulas
Efficiently explore data and create new metrics inside our workbook UI with Calculations. Rather than reinventing the wheel, Omni is compatible with many of the popular spreadsheet formulas you may already know and love.
=(B1 - B8)/B8
A
B
C
OrdersCreated Date
OrdersOrders Count
% Change
1
2024-10-14
401
=(B1 - B8)/B8
2
2024-10-13
357
7.53%
3
2024-10-12
347
-0.57%
4
2024-10-11
252
1.25%
5
2024-10-10
282
5.92%
6
2024-10-09
419
-1.43%
7
2024-10-08
406
8.94%
8
2024-10-07
389
2.15%
9
2024-10-06
332
-7.12%
10
2024-10-05
349
0.92%
Switch Topic
Marketing
Operations
Salesforce
Web Analytics
Products
ADVANCED
All Views & Fields
SQL
Switch Topic
Marketing
Operations
Salesforce
Web Analytics
Products
ADVANCED
All Views & Fields
SQL
Switch Topic
Marketing
Operations
Salesforce
Web Analytics
Products
ADVANCED
All Views & Fields
SQL
Curated data sets
Set up curated data sets for different teams within your organization. For example, build marketing curated data sets with pre-defined join paths for querying multiple tables (such as website traffic and form fills) and field descriptions to make it easy for everyone to understand and explore conversion metrics.
SQL mode
When you write SQL in Omni, you'll have SQL Super Powers, which understand and parse your query into its component logic (field definitions, joins, etc). This makes you super efficient by allowing you to build new queries via the UI and reuse the logic in the future.
Communicate findings with teammates
Flexible visualizations
Communicate your analysis with an auto viz recommended by Omni or choose from our library. You can also customize visualizations with text, imagery, iframes and more, or use our built-in Vega editor to create something entirely new.
Interactive dashboards
Monitor and communicate KPIs with dashboards powered by our intelligent cache (so you don't have to worry about slow load times). Get a bird's eye view of your business or drill down to row-level detail.
Easily shareable
Share workbooks or dashboards with URLs that maintain all your query parameters or schedule them to be sent via email. If you want to share data outside of your organization, check out our embedded analytics.
We have a lot of people who are Excel power users and they love the
ability to pivot quickly in Omni.— Griffin Tschurwald, Head of Engineering
Omni gives you the speed of in-memory extracts with the scale of a data warehouse, so you don't have to choose between running large queries in-database or pulling data that gets stale quickly.
Integrated
Connect Omni directly to your database (including AWS Redshift, Google BigQuery, Snowflake, Databricks, MySQL, Postgres, and MotherDuck), leverage our bi-directional dbt integration , and operationalize data into your workflow via email or tools like Salesforce or Notion.
Trust the results
Governed data model
Our data model creates balance to ensure organizational consistency without constraining workflows. Omni's layered data model allows you to keep in sync with the database and create a single source of truth while maintaining flexibility for ad hoc exploration.
Permissions
Maintain control over access to your data, models, and content in Omni. Manage permissions at two levels — by connection and user to give users the access they need while maintaining secure guardrails in place.
SOC 2
HIPAA
GDPR
CCPA
Security
Meet industry-leading security and privacy requirements including SOC 2, HIPAA, GDPR, and CCPA with Omni's row and column-level permissions, content controls, user attributes, and SSO authentication.
Support
Get hands-on product support and expert advice on building and maintaining a data-driven culture from a team with decades of data experience.
One platform to meet all your analytics needs
Everyone wants data, but not everyone wants to log into a BI tool to get it. The Omni Platform powers internal reporting, operationalizes data into workflows, and puts dashboards and visualizations directly into your product.
Internal Analytics
Operational Analytics
Embedded Analytics
Workbook
Workbook
Workbook
Shared Model
Schema
Materialized
Replacing our previous BI tool with Omni gave us another level of
insight and ease that we really need, internally and for our
companies. Now, we're able to extend that impact across our companies
to help them access data without requiring in-house data experts or
tools.— Mark Valdez, CEO
We're constantly adding to our database support. Currently, you can connect Omni directly to AWS Redshift, Google BigQuery, Snowflake, Databricks, MySQL, Postgres, Microsoft SQL Server, and MotherDuck
Does Omni integrate with dbt?
Omni has a bi-directional dbt integration that allows you to:
seamlessly surface dbt model changes in Omni
pull dbt context in Omni for deeper visibility
author dbt models from Omni model definitions.
What type of visualizations does Omni support?
Omni offers out-of-the-box visualizations including line, bar, stacked, grouped, scatter, table, map, area, heatmap, KPIs, and more. You can use markdown elements to create visualizations with text, images, links, data, iframes, and more! Additionally, you can use the advanced visualization editor to leverage the entire VegaLite spec library Omni.
How do you manage workbook versioning?
Omni's workbook UI is focused on asking any question of both modeled and un-modeled data in your databases. The URL will update with each user action, allowing easy back and forward motions in your browser, and instant shareability of results (across all of the tabs in your workbook). When a workbook is saved, it will appear alongside other dashboards and workbooks in the content system. If a workbook is not saved, you can still return to that analysis via the Activity section or URL. You can interact with workbooks via View or Edit mode. Edit mode will save changes as you go, and you can restore the previous version from the Version History panel.
What is your support model?
We believe in providing first-class customer support. Our experienced team is here to help you with Omni and general data questions, and we're happy to introduce you to outside experts if there's something we can't help with. We want you to be successful, and we're here to help.
Are you looking to deliver external-facing analytics?