Omni Live: Accelerate BI with Excel syntax & AI

During this Omni 🎙️ Live, Colin Zima discusses why we’re committed to replicating Excel syntax character-by-character and shares live demos using the latest functions with Omni Calculations and Calculations AI 🤖

0:00 Omni’s philosophy
2:43 Quick calculations
4:39 SUM(), IF(), Arithmetic
11:24 Working with dates
14:46 Promoting Excel calculations to the data model
17:34 SUMIF() percent of totals
20:40 Example: Outliers
23:17 AI Example: Extracting number from string
25:32 AI Example: Finding median household income and population
28:13 Free text entry
29:35 Using OpenAI for AI calculations
31:24 xlookup()
34:23 Formatting strings
37:22 Linear regression