Excel provides the ability to create complex formulas for computing new values based on arbitrary selections of cells.
Dataiku’s approach to tabular data is similar to Excel’s structured references to columns. Instead of referring to cells within a table, Dataiku formulas refer to column names, and the formula is applied to each row in the table. Formulas are provided as a step in Dataiku’s Prepare recipe, along with an expression editor to validate your formula. The expression editor shows a preview of results of your formula, examples of correct syntax, and a reference guide to functions you can use in formulas. See the Prepare Recipe: Formulas video below for an introduction to handling these tasks in Dataiku.