Omni Analytics

I appreciate Omni Analytics because it provides direct data access, 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. I think it's not intuitive how to set up topics; topics are the hardest part of curation. That's the most challenging thing. Another thing I'd change is giving more attention to schedules and deliveries, like being able to notify when changes occur in the dashboard. That could use a lot of improvement; it's just very basic now. I'd love to see more enhancements on that front. I use Omni Analytics to provide direct data access, reducing reliance on Excel and ensuring uniform data availability and intuitive visualization tools for easy dashboard creation.

The standout feature is how approachable it makes complex data analysis. Unlike other BI tools where only analysts can build meaningful reports, Omni allows our entire team to explore data confidently. The modeling layer is incredibly intuitive—you define metrics once and everyone uses the same definitions, eliminating debates about which number is right. Performance is snappy even with large datasets, and visualization options hit the sweet spot between powerful and not overwhelming. The team is also pleasant and engaging to work with, which is often not the case in BI tools. The learning curve for advanced features can be steep—basic usage is intuitive, but mastering modeling and complex joins takes time. We're making faster, better decisions. When anyone can quickly validate hypotheses or spot trends without waiting days for an analyst, the whole company moves faster. Our product launch cycles have shortened because we can measure impact in real-time and iterate quickly. That's the kind of competitive advantage that's hard to quantify but absolutely critical.

Omni completely transformed our embedded analytics experience for customers. I lead a small analyst team, and within weeks, we leveraged Omni to convert our product's analytics from static charts to fast, interactive dashboards that feel native. Omni's dbt integration enables efficient management of business logic, flexible visualization tools give us many options, and their team is incredibly responsive and supportive. I highly recommend Omni to any company wanting analytics as a true competitive advantage. Omni is growing rapidly and changing quickly, but they work in public and preview new features in visible ways, letting you prepare and get excited instead of being blindsided. Omni solved three major problems for us: slow development and bug fixes, inconsistent metrics causing customer distrust, and limited customer ability to see and trust data. Now we ship new analytics quickly, customers explore data on their own with confidence, and our team focuses on serving customers better instead of handling ad-hoc requests.

Design philosophy: Omni pitches itself as the balance between flexible BI (like notebook-style tools such as Power BI, Metabase, Tableau) and governance (like semantic layer-based tools such as Looker), and they've absolutely nailed it. Tables in BigQuery automatically reflect in Omni's schema layer, with governance through a shared layer (yml-defined joins, measures, custom columns), but the real differentiator is their workbook model—each dashboard acts as a git branch based on the shared model. This allows you to have reusable measures, joins, custom columns defined just within a dashboard without editing the company-wide shared model, but it's easy to promote changes if desired. It's a great balance of shared definitions across the company with necessary flexibility on top. Features: To name a few—Excel-style calculations on table results, filtered measures (a UI approach to doing things like SUM(IF(column="x", y, NULL)) without writing SQL—much faster and safer), and overall speed due to caching and DuckDB. They've also launched spreadsheets powered by multiple workbook queries, eliminating much copy-pasting into Google Sheets. Team: Tons of experience in the BI space that shows in the product, and frequent updates with quality-of-life improvements. They've been excellent to work with over the past ~1.5 years, addressing questions and requests. Some initial rough edges: As an early customer, there were naturally feature gaps, UI nits, and occasional bugs, but they've been consistent in shipping updates. Charting: Most charts use Vega-Lite, so customization beyond the UI requires digging into JSON with some trial-and-error. You can also build a broad range of visualizations using markdown visualizations (e.g., a table of embedded Gong calls or a kanban board for sales opportunities) but it's fiddly to set up. Their native visualizations like KPI tiles feel polished, so I'd love for all chart types to be similar eventually. This isn't a frequent blocker for us—more of a quality-of-life improvement. We use Omni for all internal BI and reporting, from monitoring product launches to tracking customer health and giving sales leadership visibility into pipeline.

Omni strikes the perfect balance between giving our data team governance to keep metrics orderly and providing users enough flexibility to create ad hoc versions. Their team consistently works hard to deliver new features and excellent support. Our implementation was smooth; we switched from Looker in just two months. While they have many cool features, some minor details are a bit annoying (but not deal breakers), like graph labels lacking contrast colors and some important features being somewhat hidden, such as filtered measures. These are all small issues, nothing major. It provides our users with high-quality data so they can independently build their own reports and make data-driven decisions. We implement governance of metrics and data across the company, making Omni the source of truth.

Omni has significantly boosted self-serve analytics and reporting for Dayton Freight Lines' internal users. Training time has dropped, and daily adoption of the tool has risen noticeably. Whenever we need support, the Omni team responds promptly with useful guidance and best practices. From a development perspective, the modeling layer has improved our BI team's data governance, standardizing a single source of truth across all reporting metrics. There aren't many drawbacks, but a few areas could be enhanced from a development standpoint. The modeling layer in 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 instance, 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 fields. Omni has greatly enhanced Dayton Freight Lines' self-serve analytics and reporting for internal users. Training time has decreased, and adoption into daily workflows has increased noticeably. Omni's modeling layer has allowed our development team to create a standardized source of truth for all reporting metrics across our entire userbase. The point-and-click nature of the field picker in workbooks is simple and straightforward for users to grasp, but also offers plenty of enhanced capability for advanced users with complex use-cases.

The dynamic user flow and dashboard configuration are excellent. It's a bit challenging initially to grasp the building process, but for me, it's valuable because it simplifies tracking key metrics, enhances visibility across various data sources, and makes it easier to spot trends and patterns without heavy reliance on technical teams. It saves time, improves decision-making, and enables more efficient reporting through centralized dashboards and visual analytics.

My favorite aspect of Omni Analytics is how it simplifies data exploration and dashboard creation for both analysts and business users. It accommodates various workflows, including SQL and spreadsheet-style formulas, while maintaining consistent metrics and remaining fast even on intricate dashboards. There are a few areas for improvement: some advanced features are somewhat obscure, and the modeling/IDE could benefit from enhanced IntelliSense and better organization, like deeper field nesting, to simplify navigation of large workbooks. I've also noticed occasional rough spots—complex dashboards may be unstable depending on underlying models, and documentation sometimes falls behind new releases, which can hinder customization. Omni addresses the 'multiple sources of truth' issue by centralizing metric definitions in a governed semantic layer, so teams align on consistent KPIs. It also connects technical and non-technical users: analysts can use SQL while business users use spreadsheet-like formulas, enabling more self-service and reducing reliance on data teams. As a result, we can respond to questions faster, consolidate analyses, and scale reporting more reliably across the organization.

The tool makes exploring company data and extracting actionable insights straightforward and effortless. It has expanded my knowledge of our operations and performance, and I'm thoroughly impressed. Honestly, I haven't encountered anything I dislike. If I could suggest one improvement, it would be to simplify saving AI chats and their outputs. It aids in understanding core business challenges and working towards solving them. It essentially highlights where to focus, and then I can take concrete steps to address those issues.

Despite being a new entrant, Omni has packed in a lot of essential capabilities. The interface is straightforward to navigate. It integrates with many data sources, and setting up connections is simple. For smaller datasets, performance is excellent. I've also found their onboarding videos and documentation quite useful. The Blobby AI and AI-generated summary charts are unique offerings, making data exploration interesting. However, when dealing with large datasets and numerous charts, there can be some lag. Currently, it doesn't support multiple dashboards within a single file like Tableau. Additionally, many chart types are missing and must be coded manually. Omni adopts a shared model, facilitating collaboration across teams. By promoting changes, everyone can access and utilize your updates easily.