Overview

One of the key skills utilized when building analytics is the ability to filter or otherwise transform data.

Data that represents a dataset (that is, a plurality of data points), is usually contained within an Javasript array. Arrays provide a set of functions for filtering and transformation.

In addition, the davinci platform provides an additional data type, $list which provides array like functionality and but also includes additional methods for querying and transforming the underlying data.

Topics

• Iterating a Dataset
• Filtering
• Transforming (Map)
• Grouping
• Joining

Transformation Apps

In addition to basic scripting facilities, the davinci platform provides a number of different apps and graphical tools for transforming data.

• View Data App
• Indicators App - adds computed columns to a tabular dataset. Mostly used with time series.
• Edit Table - lets users edit records in an array of data