The ability to clean data using conditional functions that create custom dimensions or alter data within the dimensions themselves. This is a standard feature in many competing platforms. Example Conditional Functions: IF Evaluates the condition of each successive WHEN clause and returns the first result where the condition is true; any remaining WHEN and ELSE clauses are not evaluated. If all conditions are false or NULL, returns else_result if present; if not present, returns NULL. Syntax IF(condition, true_result, false_result) CASE Compares input_expression to expression_to_match of each successive WHEN clause and returns the first result where this comparison returns true. Syntax CASE WHEN condition THEN result [WHEN condition THEN result] [...] [ELSE else_result] END Then any kind of string functions like concatenate, upper, lower, title, etc.
