Omni raises $69M in Series B funding 🥳 | Learn more

Demos

Google Sheets embedding, Transpose & measures on rows, Calculations refinement, & more

November 4, 2023

Google Sheets Embedding

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 into other queries dynamically.

Jack SweeneyJack Sweeney•Workbook, Dashboard, Analysis Pattern, Embed

Transpose and Measures on Rows

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.

Steven TalbotSteven Talbot•Table, Visualization, Workbook

Calculations Refinement

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.

Richard CzechowskiRichard Czechowski•Calcs, Workbook

Autovis

Lots of improvements to retain changes to the visualization configuration while adapting to dynamic querying and exploration.

Jamie DavidsonJamie Davidson•Visualization

Timezone Configuration

The launch of timezone configuration in Omni at the query and database level.

Cathy LennonCathy Lennon•Modeling, Administration

Dynamic Schema

New model configuration for dynamic schema handling (ie a single model that can be configured to different schemas for each user)

Conrad SlimmerConrad Slimmer•Modeling, Administration, Analysis Pattern

KPIs

Some clean-up of the KPIs with value formatting

Elliot ParkElliot Park•Visualization

Exploring Calculation Usage

Live exploration of early calculation function usage, plus a demo of the calculation UX live doing some string parsing.

Colin ZimaColin Zima•Calcs

Dynamic IP Allowlists

New IP allowlist functionality

Brian FrantzBrian Frantz•Administration