Another month, another fresh set of demos. Big group today with a day off for post-Thanksgiving rest.

Below you'll see

• The launch of our embedded demo. A more full-featured flavor of the experience that can be created embedding Omni, including authentication, some nice visuals, and custom navigation controls.
• A new login flow for email-password users
• Some touch up to the binning and grouping UI in Omni after some customer feedback on 1. how bins can be easier to set-up and 2. more clear bin boundaries
• Elegant new controls for simpler, more-powerful search in field picker of the workbook, with specific focus on SQL queriers
• New controls to allow topic-by-topic permissions in a single model
• More controls for dashboards, now including the ability to selectively hide a filter on the dashboard, but still apply to many tiles dynamically. Most useful in embedded context where not all filters may be displayed to end users.
• A rich debugger for every step of the query, so both customers and Omni can better understand and improve speed in the app
• New visualization gridlines controls and an early look at restricting which rows in the data table are visualized
• Single dashboard tile scheduling, for when you don't want the whole dashboard in your inbox, just a single query

Embedded Demo Launch (Gleam)​

Field Picker 2.0​

Topic Permissions​

Hideable Dashboard Filters​

Better Binning​

Query Timing Debug​

Visualization Gridlines and Restricted Row Display​

Single Dashboard Tile Scheduling​

Email Login​

Below you'll see

• Soon-to-be-released dashboard drill menus to keep the full experience in the dashboard, and the groundwork for visualization drilling
• Lots of UX clean-up throughout the app - cleaner SQL workflows; improved color picker for charts; and aligned shortcuts across the workbook and dashboard, including cache clearing
• Better workflows for managing and permissing user groups in Omni
• An early look at flexible point labeling on charts
• More intelligent dimension fill means faster queries and fill even over thousands of rows (via recursive CTEs); also some bonus work on binning
• New references for column totals in calculations, allowing for percent of total even with count distincts
• Tuning up our naming for bins to make the borders clear with integers

Seamless Dashboard Drill-down​

UX Odds and Ends​

Permission Groups​

Point Labels on Charts​

Fast Dimension Fill​

Column Totals in Spreadsheet Calculation​

Clearer Bin Names​

Below you'll see

• A first look at inline dashboard drilldown
• The final touches on our overhaul of visualization that maintains ad hoc changes, but still intelligently updates as queries change
• Some design explorations to improve table layouts with pivots
• More progress on embedded user management
• Some in progress designs on the new embedded analytics content for omni.co core website

Dashboard Drill iFrame​

Vis Config Overhaul​

Table Layout Designs​

Embed​

New Embed Site​

Below you'll see

• A quick demo of what the dynamic embedding in Omni opens up. Here we show an embedded Google Sheet for end-user input on dashboards. The results are auto-pushed to BQ and joined in to other queries dynamically.
• Fresh controls for transposing tables, or even just transposing metrics independently. All of the goodness around calculations and charting comes along with the new measure controls.
• More refinement of the Excel/Sheets syntax. Dynamic column naming and formatting, easier empty calculation columns, and more elegant loading of results on only changed functions.
• Lots of improvement to retain changes to the visualization configuration while adapting to dynamic querying and exploration.
• Some clean up of the KPIs with value formatting
• Live exploration of early calculation function usage, plus a demo of the calculation UX live doing some string parsing.
• New model configuration for dynamic schema handling (ie a single model that can be configured to different schemas for each user)
• The launch of timezone configuration in Omni at the query and database level.

Google Sheets Embedding​

Transpose and Measures on Rows​

Calculations Refinement​

Autovis​

Timezone Configuration​

Dynamic Schema​

KPIs​

Exploring Calculation Usage​

Dynamic IP Allowlists​

Below you'll see

• More user management and permissioning controls for building embedded URLs
• Configurable KPI colors for those green churn reduction arrows
• More developments for spreadsheet lovers - blank columns to make formulas simple and easy to build
• Model configuration to wildcard out unwanted views in the model
• A micro app we build to explore and understand the Snowflake info schema -active queries, storage metadata, query volumes over time by source and much more.

More Embedding​

KPI Colors​

More Table Calculations​

ignored_views​

Snowflake Info Schema App​

Below you'll see

• An overhaul of our table interaction model to allow keyboard nav, editable quick-calcs, and in-line drill down
• Embedded session management for fine grained control of emphemeral SSO user sessions

More Table Calculations​

Embedded User Management​

Below you'll see

• More big developments on our calculation experience, including point and click creation and simple visual functional explanation
• The final touches on our table visualization feature to put charts on every row in a table
• The last piece of authenticating users into an embedded experience seamlessly
• More build out of the content validation experience to fix dashboards throughout the app when the database changes
• Flexible series stacking, allowing stacked charts + line on the same chart
• More goodies like menu nesting, shareability on light/dark mode, topic organization, better field search in calculations, and clearer SQL/UI borders

Point and Click Table Calculations​

Flexible Bar Stacking​

Table Visualizations​

Embedded Authentication​

Content Validation​

Grab Bag​

Below you'll see

• The next rev of table calculations - inline, contextual editing
• Scheduling reports to Slack
• Embedding Omni in Salesforce
• More organization for topics to improve self-service
• Richer KPI tiles (dynamic sizing, and more change metrics)
• Content validation for fixing broken reports and references
• Improvements to query view building

Inline Calculations​

Slack Scheduling​

Salesforce Embedding​

Topic Grouping​

KPIs Part 1 - Dynamic Font Sizing​

KPIs Part 2 - Richer Context​

Content Maintenance and Validation​

Better Query Views​

Below you'll see

• The launch of dynamic maps
• Better legend layout to avoid truncation
• More development in the calculation layer - a look at static references for semi-dynamic ranges like SUM(A1:A$1)
• Nested menus throughout the app to obviate the most important actions, and provide depth for more complex use cases
• CSV scheduling to complement PDFs and PNGs
• More flexible visualization mapping - concatenated dimensions on the x-axis to make sure anything in the table is plottable
• Design touch-ups for the workbook model experience

I hate to keep saying it but probably our biggest demo Friday yet. Lots of super visual changes, and big developments underneath that power all the magic.

Below you'll see

• A beautiful new browser extension that tucks data deeper in everyone's workflows. Any dashboard a click away anywhere on the web, and a pretty new empty browser experience.
• Another cut of the Excel-style calculation layer - multi-column formulas, auto-complete, and in-line docs
• Lots of new charting - trendlines, series formatting, axis limits, and re-organized controls to find it all
• More development on table visualizations and conditional formatting
• More flexible dashboard filter mapping for complex data mappings
• The final release of our new SQL UX to separate the pivottable experience and SQL workflows better - just as magical, just explicit now
• Permissions tweaks that allow easier analytical workflows for non-technical users