Omni gives us the very sweet spot between providing good Governance for the data team to maintain some order within metrics, but also enough flexibility to allow ad hoc versions for users. Their team is also always working very hard to provide us with new features and great support. We had a very smooth implementation, we used to work with Looker and we were able to full transition within 2 months.

Design philosophy: Omni pitch themselves as the balance between flexible BI (think notebook-style BI tools like Power BI, Metabase, Tableau) and governance (think semantic layer based BI tools like Looker), and they've absolutely nailed it. Tables in BigQuery are automatically reflected in Omni's "schema" layer, governance is then through a "shared" layer (yml defined joins, measures, custom columns), but the real differentiator is their "workbook" model - each dashboard in Omni acts as a git branch based off the "shared" model. This allows you to have reusable measures / joins / custom columns etc. defined just inside a dashboard, without editing the company-wide "shared" model (but it's easy to promote changes if you want). It's a really nice balance of shared definitions across the company, but with necessary flexibility on top. Features: To call out a few - Excel-style calculations on table results, filtered measures (a UI based approach to doing things like "SUM(IF(column="x", y, NULL))" without having to write SQL - much faster and far safer), and generally the overall speed due to their caching / using duckDB. They've also launched spreadsheets that can be powered by multiple workbook queries - which cuts out a lot of copy/pasting into Google Sheets. Team: Tons of experience in the BI space which shows in the product - and frequent product updates with quality of life improvements, plus they've been excellent to work with over the past ~1.5 years with any questions or requests that we've had.

Omni completely transformed our embedded analytics experience for our customers. I lead a small team of analysts, and in a matter of weeks, our team was able to leverage Omni to convert the analytics within our product from a legacy set of static charts into fast, interactive dashboards that feel native to our platform. Omni’s dbt integration let us efficiently manage our business logic, their flexible and expanding visualization tools give us a ton of optionality on how we represent our data, and their team is incredibly responsive and supportive. I highly recommend Omni to any company that wants to turn analytics into a true competitive advantage.