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

Special Monday demo session coming off a team offsite last week. Big focus on the depth of the dashboard experience and tried to get outstanding visual layout out of the box. We also give a look at pulling richer dbt metadata into the BI layer.

Below you'll see:

• Our new dashboard layout and design functionality
• Table visualizations for more quickly understanding row-by-row differences in tabular results
• More scheduling options
• Easier visualization configuration to handle the 10s of new toggles for your charts
• A first cut at SAML integration
• Read-only lineage from dbt live next to your data model