Omni Analytics Reviews & Product Details

Omni has greatly enhanced Dayton Freight Lines self-serve analytics and reporting for internal users. Training time has decreased, and adoption of the tool into daily workflows has increased noticeably. Whenever support is needed, the Omni team responds quickly with helpful guidance and best practice recommendations. From a development standpoint, the modeling layer has helped our BI team improve data governance, standardizing a single source of truth across all reporting metrics. Review collected by and hosted on G2.com.

There aren’t many drawbacks to working in Omni, but a few areas could be improved from a development standpoint. The modeling layer within the IDE would benefit from more robust IntelliSense suggestions—though this has improved compared to earlier versions. Additionally, stronger organizational and hierarchical features within workbooks would make a meaningful difference. For example, allowing fields to be nested beyond a single level in the field picker would enable structuring by business process objects, making it much easier for users to locate the fields they need. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

While they have lots of very cool features, some minor details are a bit "annoying" (but not deal breakers), like not providing contrast colors for graph labels, some important features being a bit "hidden", like filtered measures, etc.These are all small details, nothing major. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Some initial rough edges: We were a fairly early customer of theirs so there were naturally going to be features not yet in the product, and UI nits / occasional bugs we came across - but they've been very consistent in shipping updates.

Charting: Most of their charts use Vega-lite, so if you want to customise them further than you can in the UI it involves digging through JSON with some trial & error to get it right. You can also build an incredibly broad range of visualisations using their markdown visualisations (e.g. a table of embedded Gong calls, or a kanban board for Sales opportunities) - but this is quite fiddly to set up. Their native visualisations like their KPI tiles feel really polished, so I'd love at some point for all of their chart types to be similar. This isn't a frequent blocker for us - more a quality of life improvement. Review collected by and hosted on G2.com.

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 support 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. Review collected by and hosted on G2.com.

Omni is growing rapidly and the product is changing quickly as a result, but the team works in public and previews new and beta features in visible ways that let you get ready and excited (instead of blindsided by) the changes coming! Review collected by and hosted on G2.com.

The standout feature is how approachable it makes complex data analysis. Unlike other BI tools where only data analysts can build meaningful reports, Omni lets our entire team explore data confidently. The modeling layer is incredibly intuitive - you define metrics once and everyone uses the same definitions, which eliminated our "which number is right?" debates. Performance is snappy even with large datasets, and the visualization options hit that sweet spot between powerful and not overwhelming.

The team is also very pleasant to work with and engaging. Often not the case in BI tools. Review collected by and hosted on G2.com.

The learning curve for advanced features can be steep - while basic usage is intuitive, mastering the modeling layer and more complex joins takes time. Review collected by and hosted on G2.com.

I like Omni Analytics because it provides direct access to data, eliminating the need for Excel sheets and individual solutions. The wide variety of visualizations and the intuitive workbook-to-dashboard relationship make graph and dashboard creation easy. It's beneficial to add new fields seamlessly when you have a strong data team. Review collected by and hosted on G2.com.

I think that it's not intuitive how to set up topics. I think topics are the hardest part of topic curation. It is the most challenging thing. I think the other thing I would change is that there could be more attention given to the schedules and deliveries feature, like being able to notify when things change in the dashboard. I think that could use a lot of improvement, as it's just very basic right now. I would love to see more enhancements on that front. Review collected by and hosted on G2.com.

I love the AI building features of Omni Analytics and the simplicity of the drag-and-drop interface, which enhances responsiveness. The dashboards are equipped with more tools than just querying data, allowing text or markdown format integration and AI queries. I appreciate the customizability and advanced functionality that makes the product feel polished and professional. The Slack support has been beneficial, and the collaboration with a third-party training team was very helpful. The ability to white-label the dashboard aids in branding. The smooth setup process and the innovative AI dashboard creation greatly contribute to efficiency. Review collected by and hosted on G2.com.

The pricing structure is a significant concern for me. The current model, which charges $15 per user per month, is quite expensive given I have thousands of users. Many of these users are end users who simply need access to the application occasionally, and the cost per user does not align with the revenue generated per user. I would also prefer having an in-house customer success team to support us with setup and onboarding processes. Currently, this service is contracted out, which might not provide the same level of personalized and consistent service that an internal team could offer. Review collected by and hosted on G2.com.

Our organization has used a variety of business intelligence tools over the years, including Tableau, PowerBI, and most recently Looker. While all of these platforms are powerful, we often found them bloated and cumbersome to use. Looker’s LookML is excellent for data modeling, but it also locks you into the platform and centralizes modeling in a way that limits flexibility.

We use dbt for our data transformations, and Omni’s two-way integration with dbt has been a game changer. It allows us to leverage our central data model while also giving us the flexibility to do quick, ad hoc analysis directly in Omni when needed. Whether we are using our dbt models or building something fast in Omni, we can push the results back to our data warehouse with ease.

We transitioned all of our worksheets from Looker to Omni in about two months, largely because of how intuitive Omni is. The user experience draws on the best elements of other platforms. It includes Looker’s ease of drilling and exploring, Tableau’s tabbed workbook layout, and familiar Excel-like functions for non-SQL users. It covers everything we need without the extra weight of features we do not use.

Most importantly, Omni’s customer support is the best I have experienced from any vendor, not just in the business intelligence space but overall. We are in a Slack channel with their team, and their engineers and even their CEOs respond within minutes. They are hands-on, collaborative, and eager to help solve complex problems.

Omni has been a transformative partner for us. I highly recommend it to any team looking for a modern BI tool that blends power with simplicity and offers unmatched support. Review collected by and hosted on G2.com.

Omni is still a relatively new product, so there are some rough edges. I often tell my team to expect a little bit of jank here and there. But in our experience, the trade-off is well worth it. This might not be the right tool for a massive corporation that requires a perfectly polished platform with zero errors. However, if you can tolerate the occasional quirk, I highly recommend it.

We do run into small bugs from time to time, and a few expected features are still missing. For example, some visualization types and formatting options are not yet available. That said, the Omni team is incredibly responsive. They actively listen to feedback, frequently add our requests to their roadmap, and often come up with smart workarounds in the meantime. It really feels like they are building the product alongside their users. Review collected by and hosted on G2.com.

Hard to speak to one thing. Omni Analytics is by far the best BI tool I have used and I have used many from Tableau, Looker, Power BI, Superset, etc. The list goes on. Being able to have data modeled into topics within the Semantic Layer, have git branch like dev and prod releases, connect multiple data sources (within one connection), flexibility when working with data, separation of concerns with model layer and workbook layer, great customer support, straightforward implementation and integrations, etc Review collected by and hosted on G2.com.

Don't really have down sides. It would be nice to have a best practice guide on how to best work with the platform to scale your data and achieve optimal performance but that is more of a modeling issue than platform specific at the moment. Review collected by and hosted on G2.com.

For users of Looker, picking up Omni is an easy process, and our business users have also found Omni to be intuitive and powerful. Omni's visualization options are powerful, and they are constantly adding new features. It's a 100% upgrade from Looker. The Omni team is also easy to work with, easy to reach, and extremely helpful. Review collected by and hosted on G2.com.

As with any great BI tool, there is a learning curve to using Omni, but Omni's is the shortest I've experienced among modern BI tools. Review collected by and hosted on G2.com.